User Form Facing Compile Error and Automation Error

**bala04msw** · 06-01-2018, 02:25 AM

Dear Forum,

Hope your expertise will help me for the following issues:

I have developed a user form based data entry tool and shared with my team for data entry. They are facing the following errors when they are opening, But i do not have any issue its works perfectly for me.

1. Compile Error: Can not find project or library

2. Automation Error: Run-time Error '-2146232576 (80131700)' Automation Error

I am using Microsoft Standard 2013 office product.

Could you please guide me for this issue? I am running out of my assignment and it should be implement before this end of the day.

Thanks in advance

**xlnitwit** · 06-01-2018, 03:09 AM

Hi,
It sounds as though you have a missing reference. What references do you have selected for the project, and are your team running the same version of Office and Windows as you are?

**bala04msw** · 06-01-2018, 03:32 AM

Dear xlnitwit,

Thanks for your mail. Since i am in a learning phase, i am not able to identify what i have selected as reference for this project. But after searching from web, i went to tool icon and select reference and remove "Microsoft Office Common Control 2.0 SPA" and then now its working for few of them. But the rest of the person, they are facing the automation error.

No, some of them they are using Microsoft Professional 2013 and 2016 also. How can i fix this issue? Please guide me.

Regards

**xlnitwit** · 06-01-2018, 05:05 AM

You have not given enough information to determine the problem, as we can't see your workbook or even the code in question, and you haven't said which code causes the error.

**bala04msw** · 06-14-2018, 06:31 AM

Dear Mr. Xlnitwit,

I am extremely sorry for the delay response. Debug shows "SVForm.Show"

Regards

Please Login or Register  to view this content.

**xlnitwit** · 06-14-2018, 06:34 AM

When the error occurs, choose Debug, then keep pressing f8 until the error occurs again. Which line is highlighted?

**bala04msw** · 06-14-2018, 06:43 AM

Dear sir,

The yellow color highlighted on "SVForm.Show" code, which i have given in "This Workbook"

Regards

**xlnitwit** · 06-14-2018, 07:15 AM

I know. What happens when you press f8 after that line is highlighted following the original error?

**bala04msw** · 06-14-2018, 07:31 AM

Dear Mr. Xlnitwit,

If i click debug first time, it will highlight "SVForm.Show" and if i keep on pressing F8, the yellow color highlighted line moving to the below given code. Even after if i press F8, the yellow color highlighted line moving only between "Me.cbfacilityname.AddItem ws.Cells(i, "B").Value and next i".

Please Login or Register  to view this content.

Kindly do the needful.

**xlnitwit** · 06-14-2018, 07:33 AM

Press f5 instead of f8 and then tell me which line is highlighted.

**bala04msw** · 06-14-2018, 07:52 AM

Sir,

If i press F5, again the message box shows, "Run-time Error '-2146232576 (80131700)' Automation Error" and i click debug, it will highlight "SVForm.Show" only. even after keep on pressing F5, yellow color highlights on "SVForm.Show" only.

Regards

**xlnitwit** · 06-14-2018, 08:13 AM

Open the VB editor. Click Tools- Options, then select the General tab and check the 'Break in class module' option under 'Error Trapping'. Then run the code again and tell me which line is causing the error.

**bala04msw** · 06-14-2018, 08:37 AM

Sir,

I just followed your guidance and instruction and found the error. I have enclosed the screenshot of that.

Regards

**xlnitwit** · 06-14-2018, 08:53 AM

Perhaps you don't have the relevant .Net framework installed. You might use a sorting algorithm (e.g. QuickSort) instead of a call to the ArrayList.

**bala04msw** · 06-14-2018, 09:59 AM

Sir,

How could i fix this issue? please guide me.. Really breaking my head...

Regards

**xlnitwit** · 06-14-2018, 10:00 AM

If you want the code to work as it is, installing the .Net framework should be enough.

**bala04msw** · 06-14-2018, 01:05 PM

Dear sir,

Thanks for your patience and guiding me. I found other way to fix this issue. I downloaded Microsoft .NET Framework 2.0 SP2 (which automatically also installed 3.5) at the same time, and the following code now works.

Regards

User Form Facing Compile Error and Automation Error

LinkBack

Thread Tools

Rate This Thread

Display

User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Re: User Form Facing Compile Error and Automation Error

Thread Information

Users Browsing this Thread

Similar Threads

Access 2007 Compile error in User login form VBA

Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA

User form compile error - Need urgent help

compile error - Using text box to display date in an user form

File Not Found error when opening User Form - need help tracing root of error

[SOLVED] Compile error automation error

[SOLVED] compile error automation error

Bookmarks

Bookmarks

Posting Permissions