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.

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.

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.

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.

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.