ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In IE: err: Opened Excel document links to another Excel doc (https://www.excelbanter.com/excel-discussion-misc-queries/184202-ie-err-opened-excel-document-links-another-excel-doc.html)

Alex SC

In IE: err: Opened Excel document links to another Excel doc
 
- The user clicks on a link on our intranet
- An Excel document is opened in IE
- In this Excel document you can click on a button/column that updates the
values in columns with values from another Excel-document (placed on a
fileshare /file server)
-This command does not work. It stops on "Workbooks.open xxx " (the
specified second excel file).

All of this works just fine if you perform it in Excel instead (save the
file and open it from Excel instead of inside Internet Explorer), then the
data from the second Excel-file is updated into the first Excel-file.

Have you any idea on how to solve this so the users can use the Excel doc.
in IE?

(We do not want to change settings so that Excel is always opened instead of
IE.
But if you have an HTML-command to open Excel for this specific document;
that would be great.)

Best Regards Alex




All times are GMT +1. The time now is 04:37 AM.

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