View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
vernington vernington is offline
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?