vba courses london - Macros - Enabling them to work across multiple workbooks

Resolved · Low Priority · Version Standard

Tue 12 Dec 2006, 10:46 Delegate Alex said...

Alex has attended:
Project Intro Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Macros - Enabling them to work across multiple workbooks

I seem to remember from my course something about Macros being allowed to work across different workbooks? Is there a way of enabling this?

Tue 12 Dec 2006, 12:02 Trainer David said...

RE: Macros - Enabling them to work across multiple workbooks

Hi Alex

I believe the peice of VBA code that you are looking for, to include in your macro is:

Workbooks("YourWorkbook").activate

where you place the name of your workbook in the above statement where is says yourworkbook.

If this does not solve your problem get back to me

Hope this helps

David

VBA tip:

Add A New Sheet at the end of the Workbook

To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:

Sheets.Count

Then use this value as the rank of the sheet after which you want to add the new sheet:

Sheets.Add After:=Sheets(Sheets.Count)

View all VBA hints and tips

vba courses london - Macros - Enabling them to work across multiple workbooks

Macros - Enabling them to work across multiple workbooks

RE: Macros - Enabling them to work across multiple workbooks

VBA articles

VBA tip:

Add A New Sheet at the end of the Workbook