Hi Guys.
Just a quick question:
How to modify it into: continue marco if workbook.xls is open, or stop macro, if workbook.xls is not open.![]()
Please Login or Register to view this content.
Sorry for the noobity level of the question![]()
Hi Guys.
Just a quick question:
How to modify it into: continue marco if workbook.xls is open, or stop macro, if workbook.xls is not open.![]()
Please Login or Register to view this content.
Sorry for the noobity level of the question![]()
Try:
PS. Pana Łukasza oczywiście zapraszamy na polską wersję forum czyli z .pl na końcu. Ekipa z Wrocka jest dość licznie reprezentowana :-)HTML Code:
Best Regards,
Kaper
or
![]()
Please Login or Register to view this content.
Of course you don't have to remember "magic 64" - there is a constant vbInformation
Or I suppose, such situation shall trigger higher level of alert so vbCritical (16) will be more appropriate.
![]()
Please Login or Register to view this content.
And more basic question - May be instead of stopping macro it would be more appropriate to automaticaly open it (especially easy if we know the path).
Using my example (but could be also applied to one presented by nilem:
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks