Automated Process that Updates all Spreadsheets in a Folder

A

Adel Pascaris

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automated Process that Updates Multiple Spreadsheets 2
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Automating complex workbook 3
A code to import other xls data into one xls file 3
Automated Print from Excel to PDF 2
copy a template and fill in data from a single worksheet 1
Excel Automation 10
comparing a column in two separate spreadsheets 2

Top