Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a macro which has the following line:
set XlApp = CreateObject("Excel.Application")
The macro works fine when I tested on my local QV 32 bit. I'm able to copy and paste the object I wanted to Excel after clicking the button
However, when I deploy this to the server which uses 64 bit QV, I'm getting the following error when I access the report through AccessPoint:
Macro parse failed. Functionality was lost.
SendToXL_8_1_1
Error: ActiveX component can't create object: 'Excel.Application'
Please help... Is it because the QV in the server is 64 bit? Is this possible?
Before I added the CreateObject(Excel.Application) macro, in the file uses the following code:
CreateObject("WScript.Shell")
CreateObject("CDO.Message")
CreateObject("Scripting.FileSystemObject")
There is no issue executing the above functions. I didn't have to set macro override setting. Kinda confuse how the security works.
When accessing via IE-Plugin, the macro is being executed on the client (to be sure I tested it right now, also with Excel). Thus, the problem seems to be merely on the client (could have thought of that earlier, because if it were on the server, you wouldn't receive the error message, I suppose). So, maybe Excel is not installed properly, or the COM is not registered properly, or the access is not allowed. Perhaps this link helps a little:
http://markstechstuff.blogspot.com/2007/07/activex-component-cant-create-object.html
Rgds,
Joachim
Thanks Joachim.
Ive read and tried the steps that I can try but to no avail. I could not follow all the steps as the Excel version is not the same as the one that I'm using.
Excel is installed properly cos I can do a send-to-excel via macro.
I went in DCOMCNFG and set the properties that I can set accroding to the website. Btw, this may sound like a silly question, is Excel a COM or .NET ?
Thanks!
Hi,
your suggestion was really helpful, it worked for me.
Regards,
kingshuk
thank you so much... we struggled a lot and finally got it becoz of u
Hi
Have you by mistake choosen the wrong security level when opening the application in Plugin?
Try Ctrl+Shift+M This will bring upp the Macro security dialog, the top radiobutton should be selected.