LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Run multiple excel files off of one macro

I have different files each quarter that I export into excel, then run the
same macro on all of them. The macro does not allow me to run it in the same
instance. After running it once, I have to close the macro, open it back up
then run it for the second spreadsheet, etc. Is there any way around this
problem, so I can run the control-y macro consistantly without having to
close it out to run more than one instance?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Read Multiple CSV files into Excel Kirstin Donaldson Excel Worksheet Functions 0 August 2nd 10 05:08 AM
Macro to access multiple Excel files [email protected] Excel Discussion (Misc queries) 4 March 7th 07 04:50 PM
Run multiple excel files off of one macro. ahsya Excel Discussion (Misc queries) 5 October 4th 06 03:01 PM
Run multiple excel files off of one macro. ahsya Excel Worksheet Functions 1 October 3rd 06 11:43 PM
Importing/saving multiple files in Excel w/ macro Mike M[_2_] Excel Programming 3 January 18th 05 02:13 PM


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"