rodrigofrb
New Member
- Joined
- Dec 4, 2011
- Messages
- 4
Hi there Excel Masters,
My file contains a function to Delete & replace itself for its latest version.
This function can be accessed by a button on one of the sheets; or everytime I open the workbook.
This function works perfectly if I trigger it from the button on the sheets, but if it is triggered by the Workbook_Open event I get a Permission Denied error.
This same function has been working fine on Excel 2003 for a very long time, but my company recently started using a virtual client that has Excel 2010 in it. Since this change, the code started to give me headaches.
Even the simplest version of the code will still throw the same error, and I noticed it also happens for the FileCopy command.
Kill "Full Path"; or
FileCopy "OriginFolder/FileName", "DestFolder/FileName"
HAs anyone experienced this problem before? Any help would be much appreciated.
Thanks in advance and kind regards,
Rodrigo
My file contains a function to Delete & replace itself for its latest version.
This function can be accessed by a button on one of the sheets; or everytime I open the workbook.
This function works perfectly if I trigger it from the button on the sheets, but if it is triggered by the Workbook_Open event I get a Permission Denied error.
This same function has been working fine on Excel 2003 for a very long time, but my company recently started using a virtual client that has Excel 2010 in it. Since this change, the code started to give me headaches.
Even the simplest version of the code will still throw the same error, and I noticed it also happens for the FileCopy command.
Kill "Full Path"; or
FileCopy "OriginFolder/FileName", "DestFolder/FileName"
HAs anyone experienced this problem before? Any help would be much appreciated.
Thanks in advance and kind regards,
Rodrigo
