VBA Save As File to Specific Location - Workbook Save as VBA Code Examples

This Excel VBA Save As Tutorial explains real example of VBA Code to save a file to specific location or save a file in a specific folder.
You can also learn how to use save as dialog box to save a workbook using vba code.

[@balance1772]

Thanks a lot Dada

[@manishagrawal417]

How to save a file on a folder in Sharepoint?

[@krishnananda9466]

Fantastic code
Thank you very much

[@janitziolazcano2226]

thank you so much, great video perfectly explained

[@ExcelDestination]

Welcome

[@TrianandaTjan]

How if I only want to save specific range on that worksheet?

[@raymondryanmeneses3001]

Thank you. Please do more code samples

[@m.n.953]

hi
thaks for the excellent expelation. i have a question pleas: i made a form in word with some fields to fill by the students . the fields are in vba type " plain text content control", and i added to the form a command control to save aoutomatically the document as the content of the sudent name field .
i wrote exactly the code you give in this vedio :
ActiveDocument.SaveAs2 FileName:="C:\Users\Nashat\Desktop\my new docs\abc"
but insted the "abc" name i need to refference the file name to be as wreten in the field sudent name /// how can i do this pleas ? waiting for your answer and thank you again.
best regards nashat

[@bonibiswas9466]

e

[@fajarindra4002]

how to export as video file. from any row on excel? thk

[@ornpiseth7846]

what if we press the button 2 times, it's been saved once already, one more pressing , the file name will be duplicate, how to prevent this?

[@ExcelDestination]

you need to write additional code to prevent this.

[@m.n.953]

another question pleas /// how can i avoid that the command botton for be printed with the document ? how can i make it unprinted and only show it in the screen only?

[@tonio909]

Click design mode, then right click properties then uncheck print

[@akshaythakur2395]

how to add range for export to xlsx file format???

[@matthewanacleto7885]

is this Mac OS compatible?

[@mukeshjani2778]

Sir my excel VBA file take more time to open. There are only 50 records. Pl guide me.

[@ExcelDestination]

sometimes computer\laptop performance also impact in this. May be you can remove some files, that are saved on your desktop and try cleaning your system. Then try.

[@Preeti.sardana]

Thanks

[@ExcelDestination]

Welcome

[@kannanmassey5783]

Kindly post an example to prompt for a range to copy and prompt for destination where to copy the range.
Thanks.

[@ganiurrahman8515]

How to save a userform as pdf

[@rickswineberg]

Good video, can i make a suggestion, the file name should be dynamic . Set it to gather the name dynamically from the worksheet. ie, file=range("a1") this is concatenated into the part where you have "abc".

[@ExcelDestination]

Great suggestion!

[@computerlab7388]

@@ExcelDestination please give a suggestion auto file generator from excel sheet file holder name

[@computerknowledge4821]

Please give me the code for auto save

[@wilbermarlotubaypillasagua6966]

0j

[@kylegurney8610]

@@computerknowledge4821 were you able to figure it out?

[@suyashprakash7657]

Sir I have 1 doubt.
I have created a time tracker for my team.
With your save as option - I was able to save my macro excel to the path I want.
But when I click on Command button again, it is replacing the previous excel which is saved.
I need different excel file to be saved.

[@husseinkavak]

Yes, that's what I've been looking for for days

[@suyashprakash7657]

Looks like the admin does not reply or see the comments.

[@husseinkavak]

@@suyashprakash7657 yeah, ı just typed in vade admin gets Albert and sees the comments

[@kidslearning2987]

Good

[@ExcelDestination]

Thanks

[@jahnvijairaj8414]

How to save file as pdf ?

[@husseinkavak]

really really need this

[@ryannolaan]

Could you save the file name with the data in a specific cell
For example 1
Cell A3 had “12345”
File name saved as 12345
Change data in A3 to be “6789”
File name saved as 6789
What would be the code needed

[@husseinkavak]

would be great

[@user-fh7gn8ge8m]

خه

[@goyaltraders3265]

Sir demo file provide kariya every description ma

[@ExcelDestination]

ok. Let me.