LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default export data to an existing and open workbook without knowing t

yes, that is the problem I have, can you please give me a link to PeterT's
code?

"NickHK" wrote:

In VB, you would use GetObject on an Excel.Application
Then use its ActiveWorkbook/ActiveSheet

However, there may be more than one instance of Excel running and you cannot
be sure which instance the system will return.
There are ways of looping through all instances (PeterT has posted some code
for this in this NG), but unless you have some marker to see which is the
correct instance, this will not help you.
Can you not just create you own instance to work with ?

NickHK

"vernington" wrote in message
...
The idea is to open the existing, open workbooks, i.e. those being used by
the user.

"NickHK" wrote:

If you do not know the filename, how will you know if you find it ?

NickHK

"vernington" wrote in message
...
I'm writing a windows forms app in .net. I want to export data to an

open
and
visible workbook, the filename of which I do not know. Is this

possible?
If
so, how?






 
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
Open workbook in existing Excel session mnehlig Excel Programming 5 June 5th 06 03:42 AM
Open an existing workbook and reference it TimT Excel Programming 1 October 12th 05 05:11 PM
Macro to export data from active .doc form to an existing .xls Jidings Excel Programming 0 July 29th 05 07:03 PM
Open existing workbook Daniel Van Eygen Excel Programming 4 August 25th 04 02:47 PM
vb code to export data into existing Access table desperate Excel Programming 2 November 19th 03 05:05 PM


All times are GMT +1. The time now is 06:32 PM.

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"