| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to access multiple Excel files
Hello,
I am trying to look for some pointers to get me started with macros in Excel. I have been assigned to create a macro which would consolidate and pivot data from the excel files(particular worksheet) present in a directory into a new excel file. I do apologize for asking a vague question but that is all I got. Thanks, Sam. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to access multiple Excel files
You can start here Sam
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... Hello, I am trying to look for some pointers to get me started with macros in Excel. I have been assigned to create a macro which would consolidate and pivot data from the excel files(particular worksheet) present in a directory into a new excel file. I do apologize for asking a vague question but that is all I got. Thanks, Sam. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to access multiple Excel files
Thanks for the pointer. Worked great! One thing which is undesirable while running the macro is when "workbooks.open(filename)" is invoked, I can actually see the files being opened in the taskbar. Is there a way to avoid that? Thanks, Sam On Mar 1, 3:57 pm, "Ron de Bruin" wrote: You can start here Samhttp://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm wrote in ooglegroups.com... Hello, I am trying to look for some pointers to get me started with macros in Excel. I have been assigned to create a macro which would consolidate and pivot data from the excel files(particular worksheet) present in a directory into a new excel file. I do apologize for asking a vague question but that is all I got. Thanks, Sam. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to access multiple Excel files
This has to be done programmatically since the macro is used on
multiple machines. Thanks, Sam. On Mar 7, 10:31 am, wrote: Thanks for the pointer. Worked great! One thing which is undesirable while running the macro is when "workbooks.open(filename)" is invoked, I can actually see the files being opened in the taskbar. Is there a way to avoid that? Thanks, Sam On Mar 1, 3:57 pm, "Ron de Bruin" wrote: You can start here Samhttp://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm wrote in ooglegroups.com... Hello, I am trying to look for some pointers to get me started with macros in Excel. I have been assigned to create a macro which would consolidate and pivot data from the excel files(particular worksheet) present in a directory into a new excel file. I do apologize for asking a vague question but that is all I got. Thanks, Sam. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to access multiple Excel files
Try
Application.ShowWindowsInTaskbar = False -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... This has to be done programmatically since the macro is used on multiple machines. Thanks, Sam. On Mar 7, 10:31 am, wrote: Thanks for the pointer. Worked great! One thing which is undesirable while running the macro is when "workbooks.open(filename)" is invoked, I can actually see the files being opened in the taskbar. Is there a way to avoid that? Thanks, Sam On Mar 1, 3:57 pm, "Ron de Bruin" wrote: You can start here Samhttp://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm wrote in ooglegroups.com... Hello, I am trying to look for some pointers to get me started with macros in Excel. I have been assigned to create a macro which would consolidate and pivot data from the excel files(particular worksheet) present in a directory into a new excel file. I do apologize for asking a vague question but that is all I got. Thanks, Sam. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro: Filter Multiple header then extract to Multiple 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 | |||
| Macro for multiple open files | Excel Discussion (Misc queries) | |||
| How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) | |||
Linear Mode
