Solution to VBA error 430 Class does not support automation

sdk development
1

I got this error when I tried to use a macro which had run great on other machines. I searched BOB and found lots of other people who were having this problem, but no solution. My college intern finally found a solution. It’s a permissions problem.

My macro is in a Excel 2003 spreadsheet. Go as if you are going to run Excel (i.e. click Start -> Programs -> Microsoft Office), but right-click on “Microsoft Office Excel 2003” and select Properties. Click on the Security tab. Under the Groups, click on Users. I had Read & Execute permission, but I needed Full Control. Click on the Edit button. A new dialog box comes up. Click again on Users, then check Full Control. Click OK and OK and you should be good to go.

Dennis W. Disney :us: (BOB member since 2003-09-17)

2

Hello,
I tried the same, but still getting the error.
I have excel 2003, bo 6.5
regards

bhardwaj_rajesh (BOB member since 2009-07-17)

3

Navigate through the start menu to where Excel is located.
Hold Shift.
Right click on the Excel shortcut.
Choose “Run as Administrator”.

The approach Dennis suggested didn’t work for me either but this did.

4

Run as administrator solution worked for me.

Initially i used to get error on New Designer.Application in my macro. I have BO XIR3.1 & Windows Server 2003 OS with Office 2003.

VBA 430 error of VBobject disappeared after i got the admin access on the box that I am running this macro.

Thanks all for your help.

amitvjti :india: (BOB member since 2008-02-25)

5

Hi,

I cant believe my eyes to see the Class error 430 on the statement Set DesignerApp = New Designer.Application still continuing over many years.

I have even tried running the code as adminstartor but no luck. :frowning:

Can somone please help me on this !.

Kethy1 (BOB member since 2014-02-18)