| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increment Value By 1 Each Time Spreadsheet is Opened | Excel Discussion (Misc queries) | |||
| EDate Unrecognized When Spreadsheet Opened Again | Excel Worksheet Functions | |||
| Can I set a spreadsheet so that when it is opened, a particular toolbar is loaded. | Excel Programming | |||
| Spreadsheet opened by user or programme | Excel Programming | |||
| Manipulating a spreadsheet opened in IE using VBA | Excel Programming | |||
Linear Mode
