Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Macro cannot see hidden workbook
I have developed an VBA macro for MS Excel that uses a hidden Excel workbook
as a database. To check that the database is present, I use a routine the iterates through the workbooks contained in command word Application, i.e.: Dim wkb As Workbook For Each wkb In Application.Workbooks {Check whether workbook is database workbook} Next wkb The routine works fine on my machine. However, for some reason the routine will not work properly on a colleagues machine. It seems to fail due to the fact that the database workbook is hidden. In the visual basic editor edit mode setting a watch to the command word; Applications.Workbooks it seems to recognise that the workbook is present within the application. However, whenever I try to access the workbook entry via the watch the Excel application crashes. Why should this happen on one machine and not others? Does anyone have any suggestions to overcome this problem? Can I perhaps use some alternative routine? Regards Andy B -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200607/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
copy text from 1 workbook to another by macro | Excel Worksheet Functions | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |