ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening an Excel template from a 3rd party app (https://www.excelbanter.com/excel-discussion-misc-queries/28250-opening-excel-template-3rd-party-app.html)

TonyL

Opening an Excel template from a 3rd party app
 
I am running a 3rd party app & have have created a menu item in this app
which opens a Excel template. The only problem that it opens the Excel
template and not a xls file based on the template & this causes sharing
problems as multple users use this spreadsheet. Is there a switch or
different command in the command line that I have to put in to open as an xls
file?

The command line I have is:

Excel.Sheet.8, [Open("F:\Excel Forms\Application Form.xlt")]

Using Excel 2002

TIA
--
Tony

Barb Reinhardt

If I want to create a new document based on the template on my computer, I
have to choose NEW instead of OPEN when I select the document. I don't
know if this helps.

"TonyL" wrote in message
...
I am running a 3rd party app & have have created a menu item in this app
which opens a Excel template. The only problem that it opens the Excel
template and not a xls file based on the template & this causes sharing
problems as multple users use this spreadsheet. Is there a switch or
different command in the command line that I have to put in to open as an
xls
file?

The command line I have is:

Excel.Sheet.8, [Open("F:\Excel Forms\Application Form.xlt")]

Using Excel 2002

TIA
--
Tony




TonyL

Barb. I tried "New" in the command line & it worked!. Many thanks
--
Tony


"Barb Reinhardt" wrote:

If I want to create a new document based on the template on my computer, I
have to choose NEW instead of OPEN when I select the document. I don't
know if this helps.

"TonyL" wrote in message
...
I am running a 3rd party app & have have created a menu item in this app
which opens a Excel template. The only problem that it opens the Excel
template and not a xls file based on the template & this causes sharing
problems as multple users use this spreadsheet. Is there a switch or
different command in the command line that I have to put in to open as an
xls
file?

The command line I have is:

Excel.Sheet.8, [Open("F:\Excel Forms\Application Form.xlt")]

Using Excel 2002

TIA
--
Tony






All times are GMT +1. The time now is 08:47 AM.

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