Tracing where spreadsheet is opened from

  • Thread starter Thread starter A.for.Andy
  • Start date Start date
A

A.for.Andy

Dear All

I am currently opening an existing Excel file from a macro within
SolidWorks (thus written in VBA). Is there any way that when the
spreadsheet opens, it checks to see where it was opened from? If it is
opened from SolidWorks I would like it to launch a certain macro
within the spreadsheet.

Many thanks in advance

Andy
 
Is there any way that when the
spreadsheet opens, it checks to see where it was opened from?
Click to expand...

I think Application.Caller does what you need. See the Online help for
"Caller"
 
Back
Top