I am trying to create folder then open it & then save as excel file using below code, but enable to save excel file in folder
Thanks in advancePlease Login or Register to view this content.
Sagar
I am trying to create folder then open it & then save as excel file using below code, but enable to save excel file in folder
Thanks in advancePlease Login or Register to view this content.
Sagar
Sagar
Arise awake & stop not till d goal reached
explain better, please, attach your file.
Why do you open explorer ?
If solved remember to mark Thread as solved
Hi, Patel
Simply i would like to create new folder with range (specified in code) & saveAs excel file in that folder.
sample workbook attached for reference.
Regards
Sagar
Last edited by sagar007; 06-20-2013 at 03:19 AM.
Hi,
NewBook.SaveAs (FilePath & "\" & FileName)
Ovidiu
Hi ovidiu
Working perfect
Thank you so much
Reputation added
Sagar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks