ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Open 2 independent sessions of EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/60900-open-2-independent-sessions-excel.html)

MD

Open 2 independent sessions of EXCEL
 
Good morning,

I looking for a way to open a work book by clicking on it's existing icon or
it's shortcut of MYWORKBOOK and have it open in a new session of EXCEL even
if an other workbook is already opened.

The reason is that this particular workbook has an auto auto macro that
edits
that when EXCEL looks and I don't wish for any existing opened workbook to
be modified also.

So what I need is a command or a property of some kind what defines
MYWORKBOOK so that when it is called to be opened, it opens in a new session
of EXCEL and is independent of the fist one that is running

What I've found so far is that I can put in the properties / target of the
icon the command to start the application EXCEL "C:\Program Files\Microsoft
Office\Office10\EXCEL.EXE" and then put a space and then I put the
destination of my file C:\MyFile.xls

This will work but the only problem is the version issue. If the user does
not have Office10 then the command is no good!!!



Regards

MD




All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com