How can i program this:
If module2 exists then
run first_start
else
dont do anything
end if
thanks very much
How can i program this:
If module2 exists then
run first_start
else
dont do anything
end if
thanks very much
Hi
1) Go tools, references and select the "Microsoft Visual Basic For Applications Extensibility" library.
2) Then you could do something like
Credit to http://www.cpearson.com/excel/vbe.htm for their reference.Please Login or Register to view this content.
HTH
rylo
i tried that, but it just didnt run the macro in the module at all, even when there
Hi
Have a look at the attached file. The module macro1 contains the calling code. I've also got a module module3 that contains some dummy code.
If you run the code aaa then nothing happens as there is no module2.
However, if you select module3, view, Properties Window, change the name to module2, enter and then rerun the code aaa, then the message box should show.
hth
rylo
Last edited by rylo; 04-26-2007 at 08:39 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks