Aug 29 2018 10:25 PM
I have a excel macro sheet which works in one pc and doesn't work in another. It gives module not found error and doesn't list any macros.
Document contains 3 sheets( output,data,res).Macro calling sheet is the data sheet. But when I open the document - it says module not found. And after going in the sheet- I couldn't find the macros listed under macros tab in developer section. I have enabled macros from trust center settings.
Please help. Need it very urgently.
Aug 30 2018 12:42 AM
Aug 30 2018 12:42 AM
No. I am downloading the excel file and double clicking.
Aug 30 2018 12:49 AM
Hello Jan,
update-
I get module not found when I open the document. And when I click ok on it, a pop up says - we found a problem in some content. Do you want us to recover as much as we can. When I click yes on this pop up - another pop up says - lost visual basic project. For info - This excel document was created in 97-2003 and I am opening it in Excel 2016.
Steps I took now-
1. Mailed the same file from the machine where it was working to my machine.
2. Downloaded and opened the file - now it says - VBA macros have are corrupted and have been deleted.Macro corruption mostly likely exists in the current file.
3. I clicked ok on it.
4. Closed the previous doc and opened it again - now the same module not found problem occurs .
Aug 30 2018 01:18 AM
Aug 30 2018 06:27 PM
Hello Jan,
Sorry but these approaches didn't work.
Aug 31 2018 03:03 AM
Sep 02 2018 06:31 PM
Hello Jan,
I can mail the file to you. Can I please have your email id? Or please let me know where would you want the file?
Sep 03 2018 01:18 AM