Open an Excel file in a new Excel session
Hi all,
This is a bit tricky question. I would like to open my Excel file in a new
session of Excel.
First, I thought of creating a shortcut to the file and append switch like
"/e" or "/m". Nope! Doesn't work!
Next, VBA code (e.g., using CreatObject). But given that the code resides
within the file, how can I open the file itself in the new Excel session???
Any idea? I prefer creating a shortcut for the ease of use for our users and
then do something extra.
Thanks for your ideas/thorughts.
---
Tetsuya Oguma, Singapore
|