Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 205
Default Open a workbook as another Excel process

Hi Augustus,

Is there way to prevent other workbook from openning inside (WOrkbook A) via
VBA?


Application.IgnoreRemoteRequests=True

will stop Explorer opening new files in that instance of Excel - but be sure to
set it back to False when you've finished with it!

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get each spreadsheet to open in a seperate process? Horrgakx Excel Discussion (Misc queries) 3 November 21st 06 02:57 PM
excel 2003 saved file will not open without a blank workbook open Bob Excel Discussion (Misc queries) 4 November 11th 06 04:24 PM
Open/Close Event and Excel Saving process Hari[_3_] Excel Programming 2 September 10th 04 03:16 PM
Process data in a sheet within workbook using SQL query? Stevie_mac Excel Programming 1 July 29th 04 09:59 AM
Open & process multiple worksheets then move them to different folder. Prasad Vanka Excel Programming 1 May 18th 04 03:26 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"