Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open workbook in existing Excel session | Excel Programming | |||
Open an existing workbook and reference it | Excel Programming | |||
Macro to export data from active .doc form to an existing .xls | Excel Programming | |||
Open existing workbook | Excel Programming | |||
vb code to export data into existing Access table | Excel Programming |