Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open an Excel file in a new Excel session
Type this code into a text file and save the text file with extension VBS,
like (MY.VBS) set aa=createobject("Excel.Application") aa.Workbooks.Open "c:\my.xls" aa.visible = true set aa = nothing Change line 2 to show your workbook name. Create your shortcut to this VBS file in the usual way. "Tetsuya Oguma" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open mutiple spreadsheets in one session of Excel and use 'ALT' + | Setting up and Configuration of Excel | |||
Open xls file from other xls-file in same session | Excel Discussion (Misc queries) | |||
Startup and template locations in Citrix TS session and local session | Setting up and Configuration of Excel | |||
Make it so a new session of Excel opens with each file in 2002? | Excel Discussion (Misc queries) | |||
Each New Excel to open in another session | Excel Worksheet Functions |