Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to tell if workbook is opened in browser
Don't know the exact answer - but why not just add an On Error line to your code.
Regards BrianB ------------------------------------------------------ (Ted Theodoropoulos) wrote in message . com... i have macros that won't run successfully in a browser window and need to run in a stand alone instance of excel. is there a function that can determine if the workbook is opened in IE or excel? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to tell if workbook is opened in browser
i could but each macro gives different errors. it would take a bit of
work to test every macro, record the error number and then trap it. i will do it if i have to but it seems like a crude approach. i'm not above using a crude approach i just hope there's a better way. something with the application object maybe??? Don't know the exact answer - but why not just add an On Error line to your code. Regards BrianB |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to tell if workbook is opened in browser
Some additional information
http://support.microsoft.com/?id=162059 How to Configure Internet Explorer to Open Office Documents in the Appropriate Office Program Instead of in Internet Explorer -- Regards, Tom Ogivy "Ted Theodoropoulos" wrote in message om... i could but each macro gives different errors. it would take a bit of work to test every macro, record the error number and then trap it. i will do it if i have to but it seems like a crude approach. i'm not above using a crude approach i just hope there's a better way. something with the application object maybe??? Don't know the exact answer - but why not just add an On Error line to your code. Regards BrianB |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to tell if workbook is opened in browser
thanks for the article that will help me personally but unfortunately
there will be several hundred users downloading this spreadsheet from our intranet and i will have no control over how they configure IE. i would think that the spreadsheet would open in the Intranet Zone and allow me to manipulate it via VBA but for some reason, it doesn't. this is a corporate environment where all IE settings are locked down so i can't add trusted sites, etc. any other ideas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open workbook b when workbook a opened | Excel Discussion (Misc queries) | |||
Formating Cells used code when worksheet opened | Excel Worksheet Functions | |||
Excel cannot open while web browser opened | Excel Discussion (Misc queries) | |||
Publish A Workbook Onto The Web, Then Access Using My Web Browser. | New Users to Excel | |||
Run a macro when a workbook is opened | Excel Programming |