Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling different worksheets, via automation.
Why don't you think it would work?
if the total number of rows don't exceed 65536, then you should be able to do it with a macro. Or you could try manual copy and paste, but if you can do that, a macro should work as well. -- Regards, Tom Ogilvy Dinesh wrote in message ... Hi again: I have 7 different data worksheets that need to be compiled as one. I was wondering if there is a way to automate this? I thought about using a Macro, but I'm not sure if it would work in this case. Again, your advise would be very greatly appreciated. Regards, Dinesh. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling different worksheets, via automation.
If you use the scheduler software in the operating system, you could have
the schedular open a workbook in Excel. In the workbook you could use the Workbook_Open event to fire the macro to do your work. The workbook_Open event runs when a workbook is opened. -- Regards, Tom Ogilvy "Dinesh" wrote in message ... Hi Tom: Thanks for your help. Let me ask you, or anyone else who may know, this question: By using a Macro to compile the data from different worksheets, can this be automated (say in a certain day and time), or does someone have to do go into Excel and run the Macro over again? Your help would be greatly appreciated! -----Original Message----- Why don't you think it would work? if the total number of rows don't exceed 65536, then you should be able to do it with a macro. Or you could try manual copy and paste, but if you can do that, a macro should work as well. -- Regards, Tom Ogilvy Dinesh wrote in message ... Hi again: I have 7 different data worksheets that need to be compiled as one. I was wondering if there is a way to automate this? I thought about using a Macro, but I'm not sure if it would work in this case. Again, your advise would be very greatly appreciated. Regards, Dinesh. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling data from several worksheets | Excel Discussion (Misc queries) | |||
Compiling | Setting up and Configuration of Excel | |||
Compiling data from multiple worksheets into one worksheet | Excel Discussion (Misc queries) | |||
Stopping "Link Worksheets?" message box (using automation) | Excel Programming | |||
compiling multple worksheets | Excel Programming |