I have written Excel VBA code within access. It works fine. The event is created using => x = cm.CreateEventProc("Activate", "Worksheet"). The problem is that I need it to be launched when the worksheet is opened. I have tried => x = cm.CreateEventProc("Open", "Worksheet"). That does not work.
Any ideas?
Thanks in advance for the help.
JesseH
Any ideas?
Thanks in advance for the help.
JesseH