| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know cell's address from Excel Query
Hi
You can do a query if it is reading and the file is closed. You cannot change the excel file without opening it though. The memory leak thing might only happen if you don't release objects in the code (e. Set myworkbook = Nothing) when you are done. It has nothing to do with opening the file. regards Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to refer to a cell's address, not it's content... | Excel Discussion (Misc queries) | |||
| Repeat: Active Cell's Address | Excel Programming | |||
| cell's address of the largest number | Excel Discussion (Misc queries) | |||
| How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
| How do I programmatically know the current cell's address | Excel Programming | |||
Threaded Mode
