Can someone please help
I am looking for a code that will:
1) Bring up save-as popup
2) Worksheet to be saved as name in cell (A1)
and either
path to be chosen (preferable)
or
to desktop.
thanks in advance
Can someone please help
I am looking for a code that will:
1) Bring up save-as popup
2) Worksheet to be saved as name in cell (A1)
and either
path to be chosen (preferable)
or
to desktop.
thanks in advance
Try
Please Login or Register to view this content.
i have tried this and it doesn't work
it shows only the option for folder name and no where to name the filef and when you try to save it goes has pop up of method 'save as' of object_'workbook' failed
Did you select the folder where the file should be saved in and click on OK at the bottom?
When I tried it here it saved the workbook in the folder I selected in the pop-up with the saved file name as in cell A1 and an .xlsm extension.
That is what I understand you wish from Post #1 to be. If it is not, please explain further.
when I select location eg: desktop and then save, it shows the error message.
i have a code that i use for save to pdf see code.
which is perfect but instead of save to pdf i just want to worksheet saved.
Please Login or Register to view this content.
My bad. I read your first post to save current workbook instead of active sheet. My apologies.
Save sheet as PDF to desktop.
Save sheet as xlsm file to desktop.Please Login or Register to view this content.
Save sheet as xlsm file in selected folder.Please Login or Register to view this content.
Please Login or Register to view this content.
Love it.... Perfect!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks