Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All......
I am trying to open a second Excel file and retrieve a copy of one of the worksheets. I've done this many times successfully, with other files, but this one has automatic macros attached to the sheet and workbook modules which are messing things up by trying to engage. How might I be able to open this book and copy a sheet from it to another workbook, and in so doing, disable all the sheet and workbook macros?.....and circumvent the "workbook is in use, do you want to open read-only" message. TIA Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Shared Workbook" seems to deactivate features like macros | Excel Discussion (Misc queries) | |||
How to deactivate the external queries that are used to import dat | Excel Programming | |||
automatic import from excel | Excel Discussion (Misc queries) | |||
Automatic Data Import | Excel Discussion (Misc queries) |