Macro to open report, and run the macro inside the report.

[help_questions]

I have a report, titled Report.xls; in Report.xls is a macro that is titled "Run()".
What I need is a macro that will open Report.xls and then execute "Run()".
How would I write this code?
Thanks in advance

 

[MarkAndrews]

Re: Macro to open report, and run the macro inside the repor

What I need is a macro that will open Report.xls and then execute "Run()

What program are you using to open Report.xls?

In order for a macro to run automatically, the document either needs to be already open, told to open from another program

Private Sub Workbook_open()

  Run

End Sub

 

[help_questions]

I want to use another excel workbook and have macro that's commands will tell excel to open report.xls.

Then i want another line of code to run "RUN()".

I dont want to use workbook_open(but thanks for this solution)

Any other ideas

 

[MarkAndrews]

You could use this to open your report.xls

Application.ScreenUpdating = False
ChDir "\\hqnas01p\cac$\Management\Customer Relations\Complaint Log"
Workbooks.Open Filename:= _
"\\hqnas01p\cac$\Management\Customer Relations\Complaint Log\Complaint Log 2006.xls"
Application.ScreenUpdating = True

(Above on button)

Replace '\\hqnas01p\cac$' with 'p:\\type filepath here (eg)

Then have my above suggestion in the workbook_open event of the report.xls workbook

Mark

 

[help_questions]

Re: Macro to open report, and run the macro inside the repor

I have a report, titled Report.xls; in Report.xls is a macro that is titled "Run()".
What I need is a macro that will open Report.xls and then execute "Run()".
How would I write this code?
Thanks in advance

Any other solutions to achieve my goal? The suggestion works, but i want a solution that does not use workbook_open.....

 

[help_questions]

bump