I am trying to create a macro to schedule appointments / meeting requests in Outlook via Excel. I looked up a few threads here and copied codes. However, the first line of the code "Set objOL = GetObject(, "Outlook.Application")" gives me following error.
Run-time error '429':
ActivX component can't create object
I found following suggestion on one of the forums.
Creating objects requires that the object's class be registered in the system registry and that any associated dynamic-link libraries (DLL) be available.
Can someone help me resolve this issue? I am not familiar with process to install DLL libraries or how to register object's class.
Thanks for any help or if someone has an excel file with the VBA installed as an example, I can modify it to suit my needs.
I have gotten lots of help here before.
I am hoping I get some responses soon.
Thanks,
mody
Bookmarks