Using a Macro from one workbook within another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

Here's the scenario... I have one workbook open and I copy specific sheets
into a new woorkbook, now both have the same macros in them, what I want to
do is use woorkbook1 to switch control to workbook2 and run a macro that is
in workbook2.

For example: Workbook1 code...

Private Sub CommandButton1_Click()
'Select Tabs and Copy
Sheets(Array("Info", "Data")).Copy

'Save New Workbook
ActiveWorkbook.SaveAs Filename:="WorkBook2.xls", FileFormat:=xlNormal,
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,
CreateBackup:=False

Windows("WorkBook2.xls").Activate

'Use Macro That's In WorkBook2
Call DoThis(WorkBook2.xls)

End Sub

Here's the Code in WorkBook2.xls:

Sub DoThis()
WorkBooks("WorkBook2.xls").Close
MsgBox("All Done Boss.")
End Sub


Any Ideas on this?

Thanks in Advance.
Rob
 
If your workbooks have the same macros in them, wouldn't it be as well to
run the macro DoThis() from workbook1?
 

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

Giving Macro control to another workbook 3
Copying tabs from one workbook to another workbook 2
Need help cleaning up a macro that "copies" data from another work 1
copy range using last active cell reference from 1 wkb to another 1
efficient code to copy/paste 7
Transfer data from one workbook to another workbook based on a key 2
Auto Open question 2
cell reference in another workbook 1

Back
Top