I have a workbook that has a simple macro to open two other workbooks, both these others have auto_open macros in them, that work fine when opened normally, but when I open them using the macro from the first sheet the auto_open(s) do not run, hoe can I get around this please?
either use Workbook_Open events instead or call the workbook's runautomacros method-for instance
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
ah, found it, need to run the auto_open from the original macro, weird
if anyone else needs it -
Run macro:="filename.xls!macroname"
or Run macro:="'file name.xls'!macroname" (single quotes around file names with spaces) this was my downfall
you replied as I was typing, thanks for another solution
you're welcome-and thanks for posting your alternative :-)
please don't forget to mark the thread solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks