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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Jkilburn said:
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.
Click to expand...

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 Metcalfe said:
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.
Click to expand...
Ed,
You were right on the money. Thank you very much for the help.

James Kilburn
 
Back
Top