cuddling101
New Member
- Joined
- Feb 10, 2009
- Messages
- 34
Office Version:Office 2010 Operating System:Windows 7 Program:Excel
I have opened my xlsm spreadsheet and then proceeded via the View Code link to edit code in my loaded xlam, which I have previously written.
Though I can edit the code, I cannot then save it.
I get the message
Microsoft Office Excel cannot access the file 'C\Program Files (x86)\MyExcelAdd-Ins\94ED8D40'. There are several possible reasons:
This is the first time I have tried to edit the macro since transferring the workbook and add-in to Windows 7, from my previous XP machine. The transferred spreadsheet and add-in functionality has been working perfectly. It is just that now I have to make some edits to the macro, and it won't let me.
Maybe my approach to doing the edits is wrong. It happily saved the edits that were done in the module1 area of the spreadsheet itself. It just wouldn't accept the edits of the xlam.
I learn from another board that I am not alone with this problem, somebody else is experiencing the same thing.
Any ideas please.
I have opened my xlsm spreadsheet and then proceeded via the View Code link to edit code in my loaded xlam, which I have previously written.
Though I can edit the code, I cannot then save it.
I get the message
Microsoft Office Excel cannot access the file 'C\Program Files (x86)\MyExcelAdd-Ins\94ED8D40'. There are several possible reasons:
- The file name or path does not exist.
- The file is being used by another program.
- The workbook you are trying to save has the same name as a currently open workbook.
This is the first time I have tried to edit the macro since transferring the workbook and add-in to Windows 7, from my previous XP machine. The transferred spreadsheet and add-in functionality has been working perfectly. It is just that now I have to make some edits to the macro, and it won't let me.
Maybe my approach to doing the edits is wrong. It happily saved the edits that were done in the module1 area of the spreadsheet itself. It just wouldn't accept the edits of the xlam.
I learn from another board that I am not alone with this problem, somebody else is experiencing the same thing.
Any ideas please.