Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |