Hi all,



I was wondering if there is a way to automate a process that automatically
runs a VB module which updates all spreadsheets in a folder. I have created
VB code that copies columns on a current worksheet (sheet 1) and transposes
them onto a new worksheet (sheet 2). I would like to do this for all the
spreadsheets in the folder, and I was wondering if there's a way to automate
the process. Meaning: Is there a way I could create a VB module that will
copy columns from all worksheets (sheet 1) of all spreadsheets (in the
folder) and transpose them onto the new worksheet (sheet 2) of all
spreadsheets?



Thanks in advance,



Adel

Yes, that is possible. Check out this link to get you started...

http://www.rondebruin.nl/tips.htm
Specifically look at the merge data section...
--
HTH...

Jim Thomlinson


"Adel Pascaris" wrote:

Hi all,



I was wondering if there is a way to automate a process that automatically
runs a VB module which updates all spreadsheets in a folder. I have created
VB code that copies columns on a current worksheet (sheet 1) and transposes
them onto a new worksheet (sheet 2). I would like to do this for all the
spreadsheets in the folder, and I was wondering if there's a way to automate
the process. Meaning: Is there a way I could create a VB module that will
copy columns from all worksheets (sheet 1) of all spreadsheets (in the
folder) and transpose them onto the new worksheet (sheet 2) of all
spreadsheets?



Thanks in advance,



Adel