ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open Excel file from the web (https://www.excelbanter.com/excel-programming/378905-open-excel-file-web.html)

Damien

Open Excel file from the web
 
I have an Excel application that contains a number of buttons that have code
behind them which opens various documents (word docs, powerpoint
presentations and excel workbooks). The issue that I have is that when the
application is promoted to Internet Explorer I can only open the word and
p.p. items and not the excel w/books.

the usual :
Workbooks.Open "file and path name"
does not work.
Any solutions out there?
Cheers Damo

Martin Fishlock

Open Excel file from the web
 
Damo:

I'm not sure but it may be because for the none excel items you invoke a
new object whereas for excel you do not specify the excel object try
referencing the full excel object like you did for the word and power point
links.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Damien" wrote:

I have an Excel application that contains a number of buttons that have code
behind them which opens various documents (word docs, powerpoint
presentations and excel workbooks). The issue that I have is that when the
application is promoted to Internet Explorer I can only open the word and
p.p. items and not the excel w/books.

the usual :
Workbooks.Open "file and path name"
does not work.
Any solutions out there?
Cheers Damo



All times are GMT +1. The time now is 01:37 PM.

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