Hello:
Please refer to attached file.
I am trying to use below code to create Blank Excel files with certain names as in the attached file.
It seems to error out, pls help identify the problem.
Let me know if you have any questions.
Please Login or Register to view this content.
Thanks.
Try adding the FileFormat argument to the SaveAs
As .xlsb is not usually the default try xlExcel12
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
HELLO:
It works but some how it is saving all files in C:\Dropbox\PersonalXLB\ folder.
Cell E1 has C:\GoogleDrive\1All DQ Monthly Reports\All-BankStatements\ as location
So all files should be saved at above location
Pls help
Thanks
Riz
Last edited by rizmomin; 03-01-2019 at 11:23 AM.
That's weird.
I've changed E1 to "D:\ForumFiles\" and all worksheets appeared there.
Remove all ".xlsb" from names in column C, then use this one.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks