Hello
I have a piece of VBA that pulls together data from various sources & formats them into a daily report & mails it out before I come in each morning. It's been running fine on my old PC (Windows 7 Pro, 32 bit), Office 2010 32 bit for a few months but I'm having problems with it on my new PC (64-bit Windows 7 Pro, Office 2010 32-bit).
The spreadsheet works fine if I open & run it interactively. When I run it as a scheduled task, though, I get 'error 429 ActiveX Component can't create an object'. This is at the point where it would be creating the email. Outlook is already open.
It seems like it must be a rights issue, but I'm running it with highest privileges and only when logged in. The machine never sleeps.
It's driving me mad, now. Has anyone got any ideas?
thanks
Mark
Bookmarks