View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
d_farquhar d_farquhar is offline
external usenet poster
 
Posts: 1
Default 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