How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 32133
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have a VBA project that will no longer open correctly, because

Customer Question

I have a VBA project that will no longer open correctly, because it says error in loading DLL file.. It does not say which one is not loading. Please help
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Richard replied 4 years ago.

RichieMe :

Hi there and welcome

RichieMe :

can you click start

RichieMe :

type in CMD and wait for command prompt to appear

RichieMe :

right click on command prompt and select run as administrator

RichieMe :

type in the black window

RichieMe :

sfc /scannow

RichieMe :

press enter and let it run

RichieMe :

once it finishes

RichieMe :

test the VBA project please

Customer :

9%

Customer :

10%

Customer :

How can i become a member to anser questions about Office and visual studio

Customer :

19%

RichieMe :

you need to email

RichieMe :

[email protected]

Customer :

I have been programming VBA for a very long time

Customer :

tks

Customer :

32%

Customer :

what is sfc?

Customer :

35%

Customer :

40%

RichieMe :

System File Scan

RichieMe :

to make sure DLL's are ok

Customer :

oic

Customer :

tks

RichieMe :

while waiting

RichieMe :

what project is this?

RichieMe :

excel, word?

Customer :

excel + access datastore

RichieMe :

ok, whats being used outside of excel in the project/

Customer :

i have many things happening and i am able to run things after that error

RichieMe :

what controls?

Customer :

but

Customer :

the login screen does not come up from the workbook.opn procedure

Customer :

many

Customer :

many controls including the listview

Customer :

textboxes

Customer :

labels

Customer :

forms

Customer :

listboxes

Customer :

combo boxes

Customer :

very many

Customer :

very BIG project

RichieMe :

these are things inside excel

Customer :

yes sir

RichieMe :

what things does it use outside of excel?

Customer :

on the developer tab

Customer :

access

Customer :

for a datastore

RichieMe :

what in access via dlls?

Customer :

vba calls access to get data and bring data

Customer :

not sure which ones

Customer :

i am sure there are very many

Customer :

that is why i am very surpraised that the error does not say which one

Customer :

81%

Customer :

i have had a similer error

Customer :

but, the others have said which one(s)

Customer :

91%

Customer :

Windows Resource Protection did not find any integrity violations

Customer :

is the messsage after the scan completed

Customer :

i will need to go to an appointment

Customer :

i hope you can help

Customer :

its like a needle in a haystack

RichieMe :

your leaving?

Customer :

I have to but i will be back

Customer :

Is it ok?

RichieMe :

ok

Customer :

i know this will be a tuff one

Customer :

i have worked with office for 20 years

Customer :

please dont give up....

RichieMe :

im not, but you need to tell me when you are back

Customer :

ok for sure

Customer :

i think it will take me about 2.5 hours at the doctor

RichieMe :

ok

Customer :

so if we need to talk later it is ok as well

RichieMe :

it is ok

RichieMe :

just post a message here please

Customer :

i know you have a life as well LOL

RichieMe :

:)

Customer :

here (by leaving this window open

Customer :

or

Customer :

at justanswer.com

RichieMe :

here, you can bookmark it if you like

Customer :

ok, thanks

Customer :

i be back

RichieMe :

your welcome

Customer :

Hello, I am finally back

Customer :

I have already been charged for this un answered question. I still get the same error... Its like finding a needle in a haystack thanks

Customer :

I also notice the status as 'closed' i do not believe it is closed myself. I guess i misunderstood how this works.

RichieMe :

It was closed as its over 20 days since you replied, but it is open now

RichieMe :

can you open office

RichieMe :

click Help, Detect and Repair and run this please

Customer :

I found Microsoft Diagnostics under the office button and excel options then resources, and it is running the last test now

RichieMe :

ok thanks

Customer :

It said it repaired 1 item. After opening the vba project that had the problem, it still has the problem loading the DLL.... bummer

RichieMe :

how big is the project?

RichieMe :

maybe I can look at it?

Customer :

Yea, I could zip up the excel workbook and the database that it gets its data from.

RichieMe :

ok, upload it to www.wikisend.com and give me the download link please

Customer :

wikisend had a problem. here is a link for mine... http://www.Customer.com/Richie/Richie.html

RichieMe :

I get a 404 error (page not found?)