Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem opening xls files from Explorer when IgnoreRemoteReqests set to True
Hi all,
I've been working on a VB app that has an instance of Excel running i the background, hidden from the user.To get around the problem of m session being hijacked when another workbook is opened, I've set th IgnoreRemoteRequests property of the Application object to True when first create it. However when a user double-clicks an Excel file i Explorer it attempts to open various combinations of the file pat before finally opening the workbook in a new instance of Excel. Fo example, say I'm attempting to open the following file; P:\DannyF\My Documents\xls\Test Sheet2.xls The following list of files are attempted to be opened before the fil is finally opened; P:\Dannyf\My.xls Documents\xls\Test.xls Sheet2.xls It's splitting the path up when there are spaces! Any ideas how I ca rectify this? Cheers Dann -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem opening xls files from Explorer when IgnoreRemoteReqests set to True
Now I appear to be getting the following mesage as well!
Cannot find the file 'P:\DannyF\My Documents\xls\Test Sheet2.xls' (o one of its components). Make sure the path and filename are correc and that all required libraries are available. And I also now get this message when attempting to open a workbook fro explorer even when my app isn't running. I'm switching IgnoreRemoteRequests back to false when exiting m application so it's not that - any ideas?!?!? Cheers Dann -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem opening xls files from Explorer when IgnoreRemoteReqests set to True
Fixed the problem - I modified the XLS File Type Open Action settings;
The command line used to start Excel didn't have quotation marks aroun the %1 parameter. Hurrah -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks from Excel to .JPG files are opening in an explorer win | Excel Discussion (Misc queries) | |||
Opening .xlt files within Explorer vs.using Excel/Open | Excel Discussion (Misc queries) | |||
Opening Excel files in Explorer | Excel Discussion (Misc queries) | |||
Problem opening Excel files from Windows Explorer | Excel Discussion (Misc queries) | |||
opening files from explorer with startup file and addin | Excel Programming |