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.
Пікірлер: 42
Thanks a lot Dada
thank you so much, great video perfectly explained
@ExcelDestination
2 жыл бұрын
Welcome
Fantastic code Thank you very much
Thank you. Please do more code samples
How to save a file on a folder in Sharepoint?
How if I only want to save specific range on that worksheet?
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 жыл бұрын
e
Thanks
@ExcelDestination
2 жыл бұрын
Welcome
how to export as video file. from any row on excel? thk
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
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.
Good
@ExcelDestination
2 жыл бұрын
Thanks
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.
how to add range for export to xlsx file format???
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
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
3 жыл бұрын
@@ExcelDestination please give a suggestion auto file generator from excel sheet file holder name
@computerknowledge4821
3 жыл бұрын
Please give me the code for auto save
@wilbermarlotubaypillasagua6966
2 жыл бұрын
0j
@kylegurney8610
Жыл бұрын
@@computerknowledge4821 were you able to figure it out?
is this Mac OS compatible?
Kindly post an example to prompt for a range to copy and prompt for destination where to copy the range. Thanks.
How to save file as pdf ?
@husseinkavak
Жыл бұрын
really really need this
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
How to save a userform as pdf
خه
Sir demo file provide kariya every description ma
@ExcelDestination
3 жыл бұрын
ok. Let me.