Tracing where spreadsheet is opened from
 

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

Tracing where spreadsheet is opened from
 

On 8 May, 16:49, wrote:

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

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