View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tetsuya Oguma[_4_] Tetsuya Oguma[_4_] is offline
external usenet poster
 
Posts: 19
Default 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