+ Reply to Thread
Results 1 to 4 of 4

Macro to Open, Save and Close Excel Files

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    Stuttgart, Germany
    MS-Off Ver
    Excel 2010
    Posts
    26

    Macro to Open, Save and Close Excel Files

    Hi,
    I need to program a macro that will open an Excel file, add the current date in the cell to the right of the previous date, save and close the file, open another file, copy certain cells from that file and paste into yet another file and so on. In other words, I need to program a macro to open different Excel files and perform certain operations within each Excel file. Where do I save this macro? How do I set it up? I am new to VBA. : ) Any help would be greatly appreciated!

    Thank you in advance!

  2. #2
    Registered User
    Join Date
    06-29-2011
    Location
    MUMBAI
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    85

    Re: Macro to Open, Save and Close Excel Files

    even i am new to macro but just think i might be able to help u
    U need to put the cell ref in which u want the date change.

  3. #3
    Registered User
    Join Date
    06-30-2011
    Location
    Stuttgart, Germany
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Macro to Open, Save and Close Excel Files

    Bump no response

  4. #4
    Registered User
    Join Date
    06-30-2011
    Location
    Stuttgart, Germany
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Macro to Open, Save and Close Excel Files

    Bump no response

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1