Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launching from IE
Hiya,
I've built an Excel file with a user form that provides boxes to search our SQL database and populate the spreadsheet with the data it finds. This works absolutely fine when opening from a local or network drive, but when providing this on our intranet, the form works the first time, but when clicking the New Search button (which just invokes the form) I get VBA error messages. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launching from IE
I'm guessing that you have a link on a web page that points to your excel file.
And when you open the excel file, it opens in MSIE--not excel proper. If that's true, then I'd change this behavior (and not update the code). Open windows explorer (not MSIE). Tools|folder options|file types tab Scroll down to XLS and select it Click the Advanced button And uncheck Brows in Same window Do the same for all the extensions you need: XLSM, XLSX, etc... ======= I've never found a good way to be 100% sure that the Excel VBA code will work when the file is opened in MSIE. Andy Smith wrote: Hiya, I've built an Excel file with a user form that provides boxes to search our SQL database and populate the spreadsheet with the data it finds. This works absolutely fine when opening from a local or network drive, but when providing this on our intranet, the form works the first time, but when clicking the New Search button (which just invokes the form) I get VBA error messages. Any ideas? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Launching Excel | Setting up and Configuration of Excel | |||
Launching Excel programmatically not the same as launching excel manually | Excel Programming | |||
Launching form | Excel Programming | |||
Launching Excel | Excel Programming | |||
Launching a DOS box from VBA | Excel Programming |