- I have created a Spreadsheet with Macros, its purpose is for Agents to create quotes for their customers
- This spreadsheet need to used on Agent computers (no 2 computers are using the same OS nor version of Excel)
- Upon running macros, we keep on getting the error code of 32809, and some unexplainable syntax errors "Microsoft Visual Basic for applications, Compile error, Can't find project or library"
- It works some times and not others
- Note: if the Macros work "once" when the sheet is open, it will continue to run the same every time you open the same sheet
What we have done to try to solve the issues.
1. Assemble a Win 7 OS computer with Excel 2012
2. Export the macros and re-import them
3. Macro - copy to a txt file and bring them back in, one-at-a-time
Any guidance would be helpfull. Not sure where to turn
Bookmarks