I use Excel 2007 & 2010.
I have made an add-in which has several functionality. One of which replaces a set of words with their respective replacement.
I have given an option to update this list which contains data about What is to be placed with What.
Everytime the user hits Add/Edit Source Sheet, a new sheet is formed which contains the already saved data. The user can change this list and hit update. Now this update macro copies the new list to the add-in and saves the add-in (Thisworkbook.save)
Thisworkbook.save works fine sometimes but not always. Is there any better/safe way to achieve what I am trying to do?
On other user PC's it gives out an error that the toolbar is read-only. Othertimes it saves it as .xlsm instead of .xlam.
I have asked the same question on excelforum as well.
http://www.excelforum.com/excel-programming/782902-saving-add-in-through-vba.html
I actually needed a quick reply.
Thanks & Regards,
Vaibhav
I have made an add-in which has several functionality. One of which replaces a set of words with their respective replacement.
I have given an option to update this list which contains data about What is to be placed with What.
Everytime the user hits Add/Edit Source Sheet, a new sheet is formed which contains the already saved data. The user can change this list and hit update. Now this update macro copies the new list to the add-in and saves the add-in (Thisworkbook.save)
Thisworkbook.save works fine sometimes but not always. Is there any better/safe way to achieve what I am trying to do?
On other user PC's it gives out an error that the toolbar is read-only. Othertimes it saves it as .xlsm instead of .xlam.
I have asked the same question on excelforum as well.
http://www.excelforum.com/excel-programming/782902-saving-add-in-through-vba.html
I actually needed a quick reply.
Thanks & Regards,
Vaibhav
