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 Kamil Anwar Your Own Question

Kamil Anwar
Kamil Anwar, Office Specialist
Category: Microsoft Office
Satisfied Customers: 4539
Experience:  8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
69350257
Type Your Microsoft Office Question Here...
Kamil Anwar is online now
A new question is answered every 9 seconds

I am trying to run "reconciliation on fire" version 2.22 (it

This answer was rated:

I am trying to run "reconciliation on fire" version 2.22 (it is a free downloaded .xlsm) on excel 2010. I have windows 7, 64 bit. I keep getting a "Microsoft Visual Basic for Applications Error".

Compile error in hidden module instructions. The error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click "help" for information on how top correct.

Kamil Anwar :

Hello & Welcome to JustAnswer. My name is XXXXX XXXXX i will do my best to assist you.

Kamil Anwar :

Can you please do the following:

Kamil Anwar :

Hold the Windows Key and Press R

Kamil Anwar :

Then, type C:\users and hit enter.

Kamil Anwar :

After that, C:\users folder will open. There will be another folder there which should be your username.

Kamil Anwar :

Please reply me with those usernames here.

Customer:

NTS

Customer:

Office

Customer:

Public

Customer:

scottmorgan

Kamil Anwar :

Which user are you logged in as?

Customer:

scottmorgan

Kamil Anwar :

Okay.

Kamil Anwar :

Hold the Windows key and press R

Kamil Anwar :

Then type:

Kamil Anwar :

C:\Users\scottmorgan\AppData\Roaming\Microsoft\Forms

Kamil Anwar :

and Hit Enter.

Customer:

Folder is empty

Kamil Anwar :

Can you upload reconciliation on fire to www.wikisend.com and provide me the links to download it.

Customer:

Download link is http://dw.cbsi.com/redir?edId=3&siteId=4&oId=3000-2077_4-75629770&ontId=2077_4&spi=&lop=link&pid=13292063&mfgId=1(NNN) NNN-NNNNamp;merId=10198243&ttag=dl_dldirect&ctype=language&cval=en&destUrl=http%3A%2F%2Fdownload.cnet.com%2F3001-2077_4-75629770.html%3Fpart%3Ddl-%26dlm%3D0

Customer:

I have uploaded the file to wikisend

Kamil Anwar :

I have got the file now.

Kamil Anwar :

Can you tell me if the scottmorgan user account is the computer administrator?

Customer:

I hate to say I am not sure as this is my fourth day with this PC on a new job. How can I tell?

Kamil Anwar :

Click Start and you should see a picture (profile picture), click on that picture.

Kamil Anwar :

It will take you to user account settings, there you will see it say (Standard / Administrator) just below the profile picture

Customer:

It has nothing under the picture

Kamil Anwar :

Click Start -> type User Accounts and hit Enter

Kamil Anwar :

On the right side of the window that opens, you will see the username (scottmorgan).

Kamil Anwar :

What is written just below the username?

Customer:

Nothing. See previous screen print sent.

Kamil Anwar :

I have not received any screen print.

Kamil Anwar :

Can you close excel.

Kamil Anwar :

While holding the Ctrl key. Click on the file reconciliation on fire to see if opens

Customer:

Here is another screen. The file would not open. We have a colocated system that is outsourced. This amy be the problem. My IT guy just got back with me with this answer on admin rights "



NTS has the local corporate PC’s on the domain so they have control of administrative tasks locally as well. This may change when we move to CGS…we haven’t discussed this as of yet."


Customer:

Suggestions?

Kamil Anwar :

I understand now. Since we do not have access to modify the files as it is co-located, probably the server controlling / managing polices for workstations we are not allowed to access the directories from where we can fix the issue.

Kamil Anwar :

However, please try this:

Hold the Ctrl key then while holding the ctrl key open that file again.

Customer:

It starts to open and then ask to enable macros. When i click "enable macros" it gives me the same error message.

Kamil Anwar :

Do you have Nitro PDF on this system?

Customer:

I did a search for nitro pdf. nothing came up. Not listed under programs either.

Kamil Anwar :

Okay.

Kamil Anwar :

Hold the Windows key and press R

Kamil Anwar :

then type:

Kamil Anwar :

C:\Users\NTS\AppData\Roaming\Microsoft\Forms

Kamil Anwar :

and hit Enter

Kamil Anwar :

Are there any files in this folder?

Customer:

Access denied

Kamil Anwar :

Can you ask the Network Guy to log in as administrator?

Customer:

He is on the road. That is why it took a while for him to get back with me on the administrator question.

Kamil Anwar :

We need to locate the two files below:

ComctlLib.exd
MSComctlLib.exd

In the forms folder, and delete them.

Customer:

I did a search for these files and got no results.

Kamil Anwar :

You do not have the administrator access.

Customer:

Ok. I will work with my IT guy to get access. Thanks for your help though.

Kamil Anwar :

Great. Your IT guy should login as administrator, search for those files delete them and the file should run.

Kamil Anwar and other Microsoft Office Specialists are ready to help you