RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Guys,
I want to share a workbook which has VBA protected codes with many people. It has a macro which converts the excel to XMLand saves it on the desktop. It works fine in my system.
When I share the file the other user is not able to save the file on his desktop. But gets an error. Is there a common code to save the macro on desktop in different systems.??
This is my code to save the file on my desktop.
strTempFile = "C:\Users\Admin\Desktop\importSales.xml"
I want to share a workbook which has VBA protected codes with many people. It has a macro which converts the excel to XMLand saves it on the desktop. It works fine in my system.
When I share the file the other user is not able to save the file on his desktop. But gets an error. Is there a common code to save the macro on desktop in different systems.??
This is my code to save the file on my desktop.
strTempFile = "C:\Users\Admin\Desktop\importSales.xml"