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

Рет қаралды 88,155

3 жыл бұрын

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.

Пікірлер: 42

@balance1772 Ай бұрын

Thanks a lot Dada

@janitziolazcano2226 2 жыл бұрын

thank you so much, great video perfectly explained

@ExcelDestination 2 жыл бұрын

Welcome

@krishnananda9466 Жыл бұрын

Fantastic code Thank you very much

@TrianandaTjan 3 жыл бұрын

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

@manishagrawal417 3 жыл бұрын

How to save a file on a folder in Sharepoint?

@m.n.953 2 жыл бұрын

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 2 жыл бұрын

@raymondryanmeneses3001 Жыл бұрын

Thank you. Please do more code samples

@ornpiseth7846 3 жыл бұрын

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 3 жыл бұрын

you need to write additional code to prevent this.

@m.n.953 2 жыл бұрын

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 2 жыл бұрын

Click design mode, then right click properties then uncheck print

@fajarindra4002 2 жыл бұрын

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

@mukeshjani2778 3 жыл бұрын

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

@ExcelDestination 3 жыл бұрын

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.

@akshaythakur2395 3 жыл бұрын

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

@matthewanacleto7885 Жыл бұрын

is this Mac OS compatible?

@Preeti.sardana 2 жыл бұрын

Thanks

@ExcelDestination 2 жыл бұрын

Welcome

@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

@rickswineberg 3 жыл бұрын

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 3 жыл бұрын

Great suggestion!

@computerlab7388 2 жыл бұрын

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

@computerknowledge4821 2 жыл бұрын

Please give me the code for auto save

@wilbermarlotubaypillasagua6966 2 жыл бұрын

@kylegurney8610 Жыл бұрын

@@computerknowledge4821 were you able to figure it out?

@kannanmassey5783 2 жыл бұрын

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

@kidslearning2987 2 жыл бұрын

Good

@ExcelDestination 2 жыл бұрын

Thanks

@jahnvijairaj8414 2 жыл бұрын

How to save file as pdf ?

@husseinkavak Жыл бұрын

really really need this

@ganiurrahman8515 Жыл бұрын

How to save a userform as pdf

@ryannolaan 2 жыл бұрын

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