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
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.
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.
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.
This is the manager window in which you can see the macros files that are corrupted.
I'll try to upload some files on the link that you sent.
OK, thank you.
File ID: 694720
The other file is File ID: 195248
OK, thank you.Please give me few minutes to check it out.
No problem, take your time. Thank you
You are welcome!
Can you, please, tell me what happens when you try to run the macros on your machine?Do you get "Compile error", perhaps?
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
Ah, yes, I found the same file is missing from references.
And another one: TSD
It seems that the files were moved or deleted.
Can you, please, look for the file in the path given by the first message?
All the files (projects) are in its places. I did not move any of them
what about it?
OK, it is possible that the tlb files are missing or corrupt. Let me check ...
Excel gives me only the "DOS path" to the tlb files which are like this:C:\PROGRA~1\ENVIRO~1\Tas\TBD.tlbThe above path is valid when entered but might be hard to follow in Windows Explorer - can you try to locate the file using it?
Hi, I'll try. Thank you
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.
Can you show me how to do it please.
OK, yes, that is what I wanted to check.
It is possible that the tlb files will have to be registered again.
Can you, please, tell me have you tried to reinstall the simulation software?
Yes, I did try 2 times, but didn't work.
I forgot to tell you something
The software has a dongle stick, and it did work unless the dongle is attached on mu pc.
Sorry, I meant the software didn't work unless the dongle is attached
Yes, I supposed that there is a way the software is protected.
But that does not appera to be the problem.
Do you know how to work with VBA code (writing macros)?
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.
What I meant was do you know how to open the VBA editor in Word?
Yeah (alt + f11)
in word or excel
OK, do that please.
Go to menu Tools / References and look for an reference having "MISSING" in it.
do you mean in the same file or in a blank excel file?
In the same file.
The one that should work with these macros.
Or one of the macro files, that would be the best.
OK, I got this
Hm, the files are there and seem to be OK.
Let us try something else.
OK, Thank you
When you get the error message, please press Ctrl+Break key - that will get you to the VBA code that caused it.
Please make a screen shot an post it here.
OK, let me try.
Sorry what do you mean Break key please?
It is a key on keyboard. Usually it says "Pause" with "Break" written on the side.
It is usually above Insert, Home, PgUp, PgDown etc keys.
ok you mean shift
Combination of Ctrl (control) and Pause (Break) - just like Alt + F11.
let me try
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
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?
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.
The above window usually appeared when I press ENTER.
on the error message
OK, that does give me some information, thank you.
you are welcome
OK, I have found the place in the code where the message originates.
It actually is some problem with the file named in the message.
Can you, please, locate the .tbd file?
It is possible that there are access permissions problems.
Can you please tell me where do you want me to locate the tbd file?
Oh sorry.The path to the file is given by the message.
OK, let me try
Hi Tom, It's already located there.
Yes, please right-click on the file and select Properties.
First check if Read-only box is checked, please.
No it's not.
OK, click on the Security tab.
In "Group or user names" select your account and
look at "Permissions for your-acount-name"
Then shall I press on Edit
I apologize for a delay.
Do you think this happened because I upgraded the software from the version 22.214.171.124 to 9.2.17
no problem its OK
Security settings appear to be OK. No need to edit.
About upgrade, I do not know that software so I cannot tell. It is possible however.
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.
Since access permissions are OK, it is strange that macro behaves that way.
This would have to be debugged on the spot.
Although I cannot get into the code libraries of their software.
But the more precise errorcould be deteemined.
If you would like, I could remotely try to debug it on your machine.
That would, however, have to go as additional service.
OK, How much is going to cost?
Sorry for the delay
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.
The additional service will throw us out of chat, however. We will communicate in Q&A "mode".
We can chat via remote access program (TeamViewer).
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.
OK, of course, do go get your little one :)Just post here when you are back.
Hi Tom, I am back
sorry for the delay
OK, not a problem. Our children should always have priority :)
Of course, may God bless them
You are welcome!I will make the official offer now.
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.
let us make it
I have sent the offer.
Please let me know if you face any difficulty with that.
I did send the offer. A message with the offer should have popped up - did you get it?
No, I didn't
Hm, strange.I apologize for inconvenience.We can do this another way. The key is exchanging the contact info in a secure way.
OK, no problem
There is an option to give me a bonus when you rate my service (do not have to do that yet).
First I will give you instructions how do get TeamViewer.
Then you will send me the contact info using a "self-destruct" note sit.
It is important that you do not post the contact info here as this is public.
Please click on the following link to download the TeamViewer QuickSupport program.DANGEROUS URL REMOVEDPlease start it after download. It will pop a window with "Your ID" and "Password".
Sorry for misunderstanding, I didn't mean (OK) it works. I did mean to ask what is the next step. I apologize about that
Yes, I understood it as agreeing to the bonus part ... :)
The bonus is "replacing" the additional service offer which did not get trough to you.
Good.The next step is to download TeamViewer:Please click on the following link to download the TeamViewer QuickSupport program.DANGEROUS URL REMOVEDPlease start it after download. It will pop a window with "Your ID" and "Password".
The link doesn't work, and couldn't download teamviewer.
Hm, can you tell me what happened when you clicked it?
Hm, please try to copy the link as text and paste it in another browser window address bar.
OK, let me try it
It doesn't work as well. It seems a common problem as I found that some customers faced the same problem.
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.