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 AAATom Your Own Question

AAATom
AAATom, Consultant
Category: Microsoft Office
Satisfied Customers: 468
Experience:  Master's Degree in Computer Science, 20+ years of experience
66411959
Type Your Microsoft Office Question Here...
AAATom is online now

Hi,I am working on a simulation software, and which has some

Customer Question

Hi, I am working on a simulation software, and which has some excel macros files which used to view the results and the output of the simulation processes. Unfortunately, after a few processes the macros files started not working at all, and it seems corrupted. I contacted the provider company, and unfortunately, their responses were not professional and don't help resolving the problems. They claimed that the problem was because of Microsoft office and windows updates which broke the macros, and therefore, they gave me insufficient alternative solutions, since it doesn't give the same results. I also tried to uninstall all the Microsoft and windows updates that may cause the problem, but without relief. So, I would really appreciate if someone can help me to restore and fix the corrupted excel macro files, and help me to avoid that happen again in the future. Many thanks

Submitted: 2 years ago.
Category: Microsoft Office
Expert:  AAATom replied 2 years ago.

Customer:

Hello and welcome to JustAnswer!

I would like to help you get these macros to work again.

Can you, please, tell me a bit more about the macros and simulation software you mentioned?
Are the macros part of the simulation software?
What is the name of the simulation software?

Also, it would be good if you could send me the Excel file with the macros.
You can upload the file to www.wikisend.com service and post here the File ID number you get there.


Customer:

Thank you,
Tom

Customer :

Hi Tom,

Customer:

Hello!

Customer :

The name of the simulation software is Thermal Analysis Software (TAS). To start this software, you need to open the manager window from which you can open the macros files. I tried to upload a file as an example but I couldn't because it's in (xlt) form and the website doesn't allow me to upload it.

Customer:

Thank you for the information.
Can you, please, try to upload the file to www.wikisend.com service and post here the File ID number you get there?
The Wikisend service will take any file type.

Customer :

Full Size Image

Customer :

This is the manager window in which you can see the macros files that are corrupted.

Customer :

I'll try to upload some files on the link that you sent.

Customer :

Thanks

Customer:

OK, thank you.

Customer :

File ID: 694720

Customer :

The other file is File ID: 195248

Customer :

Thanks

Customer:

OK, thank you.
Please give me few minutes to check it out.

Customer :

No problem, take your time. Thank you

Customer:

You are welcome!

Customer:

Can you, please, tell me what happens when you try to run the macros on your machine?
Do you get "Compile error", perhaps?

Customer :

When I open any macro file, it should automatically open a window inside the excel file asking me to apply the file that I need to view my results in. What happened after being corrupted instead it gave me these messages that I attached

Full Size Image
Full Size Image

Customer:

Ah, yes, I found the same file is missing from references.

Customer:

And another one: TSD

Customer:

It seems that the files were moved or deleted.

Customer:

Can you, please, look for the file in the path given by the first message?

Customer :

All the files (projects) are in its places. I did not move any of them

Customer :

yeah

Customer :

what about it?

Customer:

OK, it is possible that the tlb files are missing or corrupt. Let me check ...

Customer :

OK, Thanks

Customer:

Excel gives me only the "DOS path" to the tlb files which are like this:
C:\PROGRA~1\ENVIRO~1\Tas\TBD.tlb

The above path is valid when entered but might be hard to follow in Windows Explorer - can you try to locate the file using it?

Customer :

Hi, I'll try. Thank you

Customer :

Hi Tom, I tried to relocate the project using the above path, but I couldn't, as TBD is not a folder. It's a system file as you can see from the attached image.

Full Size Image

Customer :

Can you show me how to do it please.

Customer:

OK, yes, that is what I wanted to check.

Customer:

It is possible that the tlb files will have to be registered again.

Customer:

Can you, please, tell me have you tried to reinstall the simulation software?

Customer :

Yes, I did try 2 times, but didn't work.

Customer :

I forgot to tell you something

Customer :

The software has a dongle stick, and it did work unless the dongle is attached on mu pc.

Customer :

Sorry, I meant the software didn't work unless the dongle is attached

Customer:

Yes, I supposed that there is a way the software is protected.

Customer:

But that does not appera to be the problem.

Customer:

*appear

Customer:

Do you know how to work with VBA code (writing macros)?

Customer :

Well, actually I tried some idea found them in the internet in order to fix those files via VBA, but it didn't work as well. But, I don't know if I did right or not.

Customer:

What I meant was do you know how to open the VBA editor in Word?

Customer :

Yeah (alt + f11)

Customer :

in word or excel

Customer:

OK, do that please.

Customer:

Go to menu Tools / References and look for an reference having "MISSING" in it.

Customer :

do you mean in the same file or in a blank excel file?

Customer:

In the same file.

Customer:

The one that should work with these macros.

Customer:

Or one of the macro files, that would be the best.

Customer :

OK, I got this

Full Size Image

Customer:

Hm, the files are there and seem to be OK.

Customer:

Strange.

Customer:

Let us try something else.

Customer :

OK, Thank you

Customer:

When you get the error message, please press Ctrl+Break key - that will get you to the VBA code that caused it.

Customer:

Please make a screen shot an post it here.

Customer:

*and

Customer :

OK, let me try.

Customer :

Sorry what do you mean Break key please?

Customer:

It is a key on keyboard. Usually it says "Pause" with "Break" written on the side.

Customer:

It is usually above Insert, Home, PgUp, PgDown etc keys.

Customer :

ok you mean shift

Customer:

No.

Customer:

Combination of Ctrl (control) and Pause (Break) - just like Alt + F11.

Customer :

OK, Sorry

Customer :

let me try

Customer:

OK

Customer :

Sorry Tom, I couldn't do it in the way you told me. Can you please, show me another way to get VBA code window that show me the error caused the problem. thatnks

Customer:

Hm, when a message is shown the code can be stopped only with Ctrl+Break. I'm afraid.
Can you tell me what problem are you facing, please?

Customer :

OK

Customer :

firstly, I am not sure if I pressed the correct (Break) key or not. When the message appeared, I pressed CTRL and the key stated (Pause) but it did nothing so I pressed CTRL + different keys to try, then it gave the other window that usually appears when it is working properly, but doesn't allow me to apply any project.

Full Size Image

Customer :

The above window usually appeared when I press ENTER.

Customer :

on the error message

Customer:

OK, that does give me some information, thank you.

Customer :

you are welcome

Customer:

OK, I have found the place in the code where the message originates.

Customer:

It actually is some problem with the file named in the message.

Customer:

Can you, please, locate the .tbd file?

Customer:

It is possible that there are access permissions problems.

Customer :

Can you please tell me where do you want me to locate the tbd file?

Customer:

Oh sorry.
The path to the file is given by the message.

Customer :

OK, let me try

Customer :

Hi Tom, It's already located there.

Customer:

Yes, please right-click on the file and select Properties.

Customer:

First check if Read-only box is checked, please.

Customer :

Full Size Image

Customer :

No it's not.

Customer:

OK, click on the Security tab.

Customer:

In "Group or user names" select your account and

Customer:

look at "Permissions for your-acount-name"

Customer :

Full Size Image

Customer :

Full Size Image

Customer :

Then shall I press on Edit

Customer:

I apologize for a delay.

Customer :

Do you think this happened because I upgraded the software from the version 9.2.1.6 to 9.2.17

Customer :

no problem its OK

Customer:

Security settings appear to be OK. No need to edit.

Customer :

OK

Customer:

About upgrade, I do not know that software so I cannot tell. It is possible however.

Customer :

But, as I said in my question that I contacted the EDSL explaining the case to hem and they claimed that the problem occurred because of Microsoft office updates.

Customer :

*them

Customer:

Since access permissions are OK, it is strange that macro behaves that way.

Customer:

This would have to be debugged on the spot.

Customer:

Although I cannot get into the code libraries of their software.

Customer:

But the more precise errorcould be deteemined.

Customer:

*determined

Customer:

If you would like, I could remotely try to debug it on your machine.

Customer:

That would, however, have to go as additional service.

Customer :

OK, How much is going to cost?

Customer :

Sorry for the delay

Customer:

I see the price in US$ and the current price of the question is $39 - I can make you and offer for $30.
I would remote to your computer and debug the macros. I would find the exact error number the libraries produce what may indicate the real source of the problem. I would also check some other things that might be causing the problem.

Customer:

The additional service will throw us out of chat, however. We will communicate in Q&A "mode".

Customer:

We can chat via remote access program (TeamViewer).

Customer :

OK, that would be no problem and hopefully you can resolve the problem. But, can you please let me first to go to collect my little daughter from the nursery and I'll be with you within 15 minutes.

Customer:

OK, of course, do go get your little one :)
Just post here when you are back.

Customer :

Hi Tom, I am back

Customer :

sorry for the delay

Customer:

OK, not a problem. Our children should always have priority :)

Customer :

Of course, may God bless them

Customer :

Thank you

Customer:

You are welcome!
I will make the official offer now.

Customer:

A message offering "extra help" will present itself to you.
Please click on the orange "Get extra help" button to accept it.
If you get prompted to leave the page, please do so (click on Leave Page).
After payment transaction is processed you will be taken to the Q&A page.
I'll then give you instructions how to download the TeamViewer client and how we will connect.

Customer :

Alright then

Customer :

let us make it

Customer:

I have sent the offer.

Customer :

I'm waiting

Customer:

Please let me know if you face any difficulty with that.

Customer:

I did send the offer. A message with the offer should have popped up - did you get it?

Customer :

No, I didn't

Customer:

Hm, strange.
I apologize for inconvenience.
We can do this another way. The key is exchanging the contact info in a secure way.

Customer :

OK, no problem

Customer:

There is an option to give me a bonus when you rate my service (do not have to do that yet).

Customer :

OK

Customer:

OK, thank you.

Customer:

First I will give you instructions how do get TeamViewer.

Customer:

Then you will send me the contact info using a "self-destruct" note sit.

Customer:

It is important that you do not post the contact info here as this is public.

Customer:

Please click on the following link to download the TeamViewer QuickSupport program.
DANGEROUS URL REMOVED

Please start it after download. It will pop a window with "Your ID" and "Password".

Customer :

Sorry for misunderstanding, I didn't mean (OK) it works. I did mean to ask what is the next step. I apologize about that

Customer:

Yes, I understood it as agreeing to the bonus part ... :)

Customer:

The bonus is "replacing" the additional service offer which did not get trough to you.

Customer :

Yeah

Customer:

Good.
The next step is to download TeamViewer:

Please click on the following link to download the TeamViewer QuickSupport program.
DANGEROUS URL REMOVED

Please start it after download. It will pop a window with "Your ID" and "Password".

Customer :

The link doesn't work, and couldn't download teamviewer.

Customer:

Hm, can you tell me what happened when you clicked it?

Customer :

nothing happened

Customer:

Hm, please try to copy the link as text and paste it in another browser window address bar.

Customer :

OK, let me try it

Customer :

It doesn't work as well. It seems a common problem as I found that some customers faced the same problem.

Customer:

That is strange. It is possible that your firewall is blocking it.
Please try to go to the main TeamViewer page http://www.teamviewer.com and click "Join RemoteControl Session" link below the big green button.

Customer :