Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run multiple excel files off of one macro
This isn't typical behavior, so it is hard to say how to fix it. What do you
think is preventing the macro from running a second time? Are you getting an error message - what are the symptoms that indicate it is not allowed to run again? -- Regards, Tom Ogilvy "ahsya" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run multiple excel files off of one macro
Excel will either do nothing, or it will highlight the entire spreadsheet of
data. "Tom Ogilvy" wrote: This isn't typical behavior, so it is hard to say how to fix it. What do you think is preventing the macro from running a second time? Are you getting an error message - what are the symptoms that indicate it is not allowed to run again? -- Regards, Tom Ogilvy "ahsya" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run multiple excel files off of one macro
Highlighting the entire spreadsheet would be an indication it is running -
but perhaps not as you expected. Seeing no visible response doesn't necessarily mean it doesn't run. I would look at any conditions you have placed within the macro to control program flow. Perhaps the conditions are not being met on the new sheets which results in the apparent aberrant behavior. Also, if you have recorded the code, it could be very dependent on what is selected when you run it. Again, verify that you complete the essential preparations that could govern a successful run. -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "ahsya" wrote: Excel will either do nothing, or it will highlight the entire spreadsheet of data. "Tom Ogilvy" wrote: This isn't typical behavior, so it is hard to say how to fix it. What do you think is preventing the macro from running a second time? Are you getting an error message - what are the symptoms that indicate it is not allowed to run again? -- Regards, Tom Ogilvy "ahsya" wrote: 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run multiple excel files off of one macro
Also asked in Worksheet.Functions group.
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "ahsya" wrote in message 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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run multiple excel files off of one macro
Did you get the subject line so that I can refer to it? I searched by two
different subject lines, but was unable to find anything similar to my question. Thank you. "Jim Cone" wrote: Also asked in Worksheet.Functions group. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "ahsya" wrote in message 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Read Multiple CSV files into Excel | Excel Worksheet Functions | |||
Macro to access multiple Excel files | Excel Discussion (Misc queries) | |||
Run multiple excel files off of one macro. | Excel Discussion (Misc queries) | |||
Run multiple excel files off of one macro. | Excel Worksheet Functions | |||
Importing/saving multiple files in Excel w/ macro | Excel Programming |