Re-write generator macro to exctract csv data and save in a template excel sheet $30
Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Re-write generator macro to exctract csv data and save in a template excel sheet $30

  1. February 12th, 2012 #1
    teekay
    teekay is offline Member
    Join Date
    12th February 2012
    Posts
    27

    Re-write generator macro to exctract csv data and save in a template excel sheet $30

    Hi Guys,

    I have an macro based generator in excel which extracts data from a csv file (based on a common row value) then pastes and saves automatically into a template word file. What i want done is for the generator to paste into an excel template instead of the word one. This would require the macro's in the generator to be altered.

    I've attached the generator, if you think you can help me out, then we can discuss this on another platform as I dont want to attach all the files necessary on this thread.

    Thankyou all!
    Last edited by teekay; February 12th, 2012 at 17:43.

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  2. February 12th, 2012 #2
    S M C's Avatar
    S M C
    S M C is offline The Oracle [Expert Coder]
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,239

    Re: Re-write generator macro to exctract csv data and save in a template excel sheet

    I will have a look at this and revert if I'd be able to take this up
    Cheers,

    S M C

    Click To Read: How To Use Tags In Your Threads/Posts
    Please take time to read Forum Rules before posting
    Message to Cross Posters
    Reply With Quote Reply With Quote
  3. February 12th, 2012 #3
    S M C's Avatar
    S M C
    S M C is offline The Oracle [Expert Coder]
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,239

    Re: Re-write generator macro to exctract csv data and save in a template excel sheet

    Will need to csv file alo
    Cheers,

    S M C

    Click To Read: How To Use Tags In Your Threads/Posts
    Please take time to read Forum Rules before posting
    Message to Cross Posters
    Reply With Quote Reply With Quote
  4. February 12th, 2012 #4
    teekay
    teekay is offline Member
    Join Date
    12th February 2012
    Posts
    27

    Re: Re-write generator macro to exctract csv data and save in a template excel sheet

    here is the csv

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  5. February 12th, 2012 #5
    teekay
    teekay is offline Member
    Join Date
    12th February 2012
    Posts
    27

    Re: Re-write generator macro to exctract csv data and save in a template excel sheet

    Cant upload file
    Last edited by teekay; February 12th, 2012 at 12:41.

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  6. February 12th, 2012 #6
    S M C's Avatar
    S M C
    S M C is offline The Oracle [Expert Coder]
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,239

    Re: Re-write generator macro to exctract csv data and save in a template excel sheet

    Alright, I have to rush out for 5-6 hours. Will be back and revert on this.
    Cheers,

    S M C

    Click To Read: How To Use Tags In Your Threads/Posts
    Please take time to read Forum Rules before posting
    Message to Cross Posters
    Reply With Quote Reply With Quote
  7. February 12th, 2012 #7
    S M C's Avatar
    S M C
    S M C is offline The Oracle [Expert Coder]
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,239

    Re: Re-write generator macro to exctract csv data and save in a template excel sheet

    I will send you my email on PM. Send it there pls
    Cheers,

    S M C

    Click To Read: How To Use Tags In Your Threads/Posts
    Please take time to read Forum Rules before posting
    Message to Cross Posters
    Reply With Quote Reply With Quote
  8. February 16th, 2012 #8
    S M C's Avatar
    S M C
    S M C is offline The Oracle [Expert Coder]
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,239

    Re: Re-write generator macro to exctract csv data and save in a template excel sheet

    Modified file sent, please confirm if requirement is met, and if yes, when payment can be made. If not met, what has been missed out?
    Cheers,

    S M C

    Click To Read: How To Use Tags In Your Threads/Posts
    Please take time to read Forum Rules before posting
    Message to Cross Posters
    Reply With Quote Reply With Quote
« Control user access to workbook with a changeable password | WebBrowser Design Issue: $10 »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Macro to save data to another sheet
    By gman430 in forum EXCEL HELP
    Replies: 3
    Last Post: August 26th, 2012, 14:07
  2. USD $30 via Paypal. Macro to copy data from one sheet and save to another sheet
    By kwasi in forum HIRE HELP
    Replies: 4
    Last Post: June 13th, 2011, 14:47
  3. Loop and copy rows to template and save sheet as text file
    By Stressd_oot in forum EXCEL HELP
    Replies: 1
    Last Post: April 25th, 2011, 09:51
  4. Template Wizard - Save As Macro
    By JasonK in forum EXCEL HELP
    Replies: 12
    Last Post: January 5th, 2006, 06:52

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules