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

  • @balance1772
    @balance1772Ай бұрын

    Thanks a lot Dada

  • @janitziolazcano2226
    @janitziolazcano22262 жыл бұрын

    thank you so much, great video perfectly explained

  • @ExcelDestination

    @ExcelDestination

    2 жыл бұрын

    Welcome

  • @krishnananda9466
    @krishnananda9466 Жыл бұрын

    Fantastic code Thank you very much

  • @raymondryanmeneses3001
    @raymondryanmeneses3001 Жыл бұрын

    Thank you. Please do more code samples

  • @manishagrawal417
    @manishagrawal4173 жыл бұрын

    How to save a file on a folder in Sharepoint?

  • @TrianandaTjan
    @TrianandaTjan3 жыл бұрын

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

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

    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

    @bonibiswas9466

    2 жыл бұрын

    e

  • @Preeti.sardana
    @Preeti.sardana2 жыл бұрын

    Thanks

  • @ExcelDestination

    @ExcelDestination

    2 жыл бұрын

    Welcome

  • @fajarindra4002
    @fajarindra40022 жыл бұрын

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

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

    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

    @tonio909

    2 жыл бұрын

    Click design mode, then right click properties then uncheck print

  • @ornpiseth7846
    @ornpiseth78463 жыл бұрын

    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

    @ExcelDestination

    3 жыл бұрын

    you need to write additional code to prevent this.

  • @kidslearning2987
    @kidslearning29872 жыл бұрын

    Good

  • @ExcelDestination

    @ExcelDestination

    2 жыл бұрын

    Thanks

  • @mukeshjani2778
    @mukeshjani27783 жыл бұрын

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

  • @ExcelDestination

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

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

  • @suyashprakash7657
    @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

    @husseinkavak

    Жыл бұрын

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

  • @suyashprakash7657

    @suyashprakash7657

    Жыл бұрын

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

  • @husseinkavak

    @husseinkavak

    Жыл бұрын

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

  • @rickswineberg
    @rickswineberg3 жыл бұрын

    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

    @ExcelDestination

    3 жыл бұрын

    Great suggestion!

  • @computerlab7388

    @computerlab7388

    3 жыл бұрын

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

  • @computerknowledge4821

    @computerknowledge4821

    3 жыл бұрын

    Please give me the code for auto save

  • @wilbermarlotubaypillasagua6966

    @wilbermarlotubaypillasagua6966

    2 жыл бұрын

    0j

  • @kylegurney8610

    @kylegurney8610

    Жыл бұрын

    @@computerknowledge4821 were you able to figure it out?

  • @matthewanacleto7885
    @matthewanacleto7885 Жыл бұрын

    is this Mac OS compatible?

  • @kannanmassey5783
    @kannanmassey57832 жыл бұрын

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

  • @jahnvijairaj8414
    @jahnvijairaj84142 жыл бұрын

    How to save file as pdf ?

  • @husseinkavak

    @husseinkavak

    Жыл бұрын

    really really need this

  • @ryannolaan
    @ryannolaan2 жыл бұрын

    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

    @husseinkavak

    Жыл бұрын

    would be great

  • @ganiurrahman8515
    @ganiurrahman8515 Жыл бұрын

    How to save a userform as pdf

  • @user-fh7gn8ge8m
    @user-fh7gn8ge8m2 жыл бұрын

    خه

  • @goyaltraders3265
    @goyaltraders32653 жыл бұрын

    Sir demo file provide kariya every description ma

  • @ExcelDestination

    @ExcelDestination

    3 жыл бұрын

    ok. Let me.