LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Follow on to: Determine if a workbook is already open

Follow-up question to the post "Determine if a workbook is already open":

Given:
- At least two excel instances running. Only two are of interest, call them
A and B
- Excel instance B has a workbook open that I want to access for
manipulation, call it TargetWkbk
- Excel instance A has VBA code that I am executing... it knows that the
TargetWkbk is not open in this Excel instance (i.e. A) but that the
TargetWkbk is open somewhere (this is what I learned todo from the previous
post)

My Question:
How can I get a reference (handle?) to Excel instance B so that I can
manipulate (read, write) its contents from the VBA code in Excel instance A?

Thanks for any thoughts...

Charles
 
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
Determine if a workbook is already open [email protected] Excel Programming 6 February 28th 07 04:05 PM
SAVE DOC. FROM WORKBOOK SO THAT INTERLINKING FORMULAS DON'T FOLLOW Kat Gebhart New Users to Excel 0 May 29th 06 07:32 PM
How can I determine who has workbook open? Dean Hinson[_3_] Excel Programming 3 April 20th 05 04:01 PM
Follow up question for Tom Ogilvy - linking a text box to an external workbook JENNA Excel Programming 2 January 17th 04 11:29 PM
Determine if Workbook is Open or Closed jurgenC![_2_] Excel Programming 2 December 28th 03 10:12 PM


All times are GMT +1. The time now is 01:47 AM.

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

About Us

"It's about Microsoft Excel"