Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't access to a WorkBook
I Open Excel from Start Menu, then I open again Excel form Start Menu, now I
have two Exels, opened. I've two workbooks opened, but each one in one different Excel's windows, how can I work with both by code? The sentence: ?Workbooks.count only returns one. I open one workbook, and then another aplications creates a new workbook, in the Window menu I only see the current window in each Excel, but I have two workbooks opened in two Excel. I'm using Excel 2002. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't access to a WorkBook
You have created completely separate instances of Excel. To see both
workbooks using one set of code you must open both in the one instance of Excel. I cannot think why you need two instances of Excel to be running concurrently, the memory overhead alone makes it very inefficient. Start Excel and the Open each workbook, you can switch between Windows and manipulate both (or more) workbooks in one set of code in VBA. Cheers Nigel "Jordi" wrote in message ... I Open Excel from Start Menu, then I open again Excel form Start Menu, now I have two Exels, opened. I've two workbooks opened, but each one in one different Excel's windows, how can I work with both by code? The sentence: ?Workbooks.count only returns one. I open one workbook, and then another aplications creates a new workbook, in the Window menu I only see the current window in each Excel, but I have two workbooks opened in two Excel. I'm using Excel 2002. ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
access cell in other workbook | Excel Discussion (Misc queries) | |||
how to access a cell value in a different workbook. HELP! | Excel Worksheet Functions | |||
Workbook with 20+ queries of Access is TOO BIG | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Can't access to a Workbook | Excel Programming |