method saveas of object _workbook failed
Hello Excel Expert
I am trying to create a macro, which will do some task and save a new excel file.
but in line
I am getting an error method saveas of object _workbook failed
Please Login or Register to view this content.
Note: This code is working fine someone else PC but not working for me whereas windows and excel version is same (Windows 10 and Excel 2016).
Here is the code I am using:
Please Login or Register to view this content.
Using Date will cause the file name to include the date written as 3/9/2018. It is illegal to have slashes in a Windows file name, and that is why you are getting the error.
Try something like this:
By the way you also have to ensure that itm does not contain illegal characters.Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thank you sir,
It works perfectly.
Thanks a lot.....!
You're welcome! Thanks for the rep, and thanks for marking your thread Solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks