How do I use switches to open a workbook in EXCEL?

[Jkilburn]

I am trying to setup a Macro in Access that will open Excel and then open up
a specific workbook so I can update the data. I can find a switch that will
allow me to open the workbook in Read Onlu mode. Is there a switch setting
that will open the workbook in ReadWrite mode?

Thanks in advance.

 

[Ed Metcalfe]

I am trying to setup a Macro in Access that will open Excel and then open
up
a specific workbook so I can update the data. I can find a switch that
will
allow me to open the workbook in Read Onlu mode. Is there a switch
setting
that will open the workbook in ReadWrite mode?

Thanks in advance.

I assume you are using RunApp and you have got as far as working out how to
pass the path of the relevant workbook as part of the command line
parameter.

If you exclude the read-only switch I believe the macro will default to
opening the workbook as read-write:

"excel.exe " "C:\MyWorkbook.xls"

Ed Metcalfe.

 

[Jkilburn]

I assume you are using RunApp and you have got as far as working out how to
pass the path of the relevant workbook as part of the command line
parameter.

If you exclude the read-only switch I believe the macro will default to
opening the workbook as read-write:

"excel.exe " "C:\MyWorkbook.xls"

Ed Metcalfe.

Ed,
You were right on the money. Thank you very much for the help.

James Kilburn