Excel VBA Macro: Save As Dialog (Allow User to Select Saved File Location)

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 ต.ค. 2024

ความคิดเห็น • 15

  • @francinepowell9296
    @francinepowell9296 2 ปีที่แล้ว +1

    Good Video! Appreciated the slower pace by typing out the code and them demo the results; then making changes and demo the changes. This is what I was looking for allow the user to get a copy of the sheet, but he can select the filename and path.

    • @greggowaffles
      @greggowaffles  2 ปีที่แล้ว

      Thanks! Glad it was what you were looking for

  • @lorielange6777
    @lorielange6777 10 หลายเดือนก่อน

    Huge help, exactly what I was looking for and needed!

    • @greggowaffles
      @greggowaffles  10 หลายเดือนก่อน

      So glad to hear that!!

  • @russf62
    @russf62 5 หลายเดือนก่อน

    Fantastic, so helpful, thanks. Had created code to clear a weekly timesheet at start of new week but wanted to add the option to save a copy before doing so. Just a few minor tweaks and voila... 😊

  • @yosef-yosef9414
    @yosef-yosef9414 9 หลายเดือนก่อน +1

    God bless and thank you Bro'

  • @yosef-yosef9414
    @yosef-yosef9414 9 หลายเดือนก่อน

    This is Very Helpful. great help

  • @makubexho
    @makubexho 2 ปีที่แล้ว

    @greggowaffles fantastic video as usual - just a question though - I used your codes and everything seems working until i receive a prompt, immediately after i select a location and hit Save, saying " a file named 'FALSE.xlsx' already exists in this location. Do you want to replace it". My feeling it has something to do with the if-statement or i could be wrong. Any suggestion?

  • @mandysookdeo721
    @mandysookdeo721 ปีที่แล้ว

    Thank you!!

  • @dlee1224
    @dlee1224 2 ปีที่แล้ว

    Greg, That was awesome, you went at a good pace and it was very clear. Can you do the same thing but create a folder rather than a workbook?

  • @pugu404
    @pugu404 2 ปีที่แล้ว

    Excuse me sir..
    i want to ask about the Formulas..
    how to prevent formulas from being carried over to the workbook, or not link to master workbook..
    thank you before ..

  • @mizanranawat5940
    @mizanranawat5940 3 หลายเดือนก่อน

    File not found in the path where I have saved... please help

  • @arulmozhikarunanidhi1948
    @arulmozhikarunanidhi1948 3 ปีที่แล้ว

    Vba will have scope in future bcoz I want to switch my career towards vba

  • @PlayfulPranksters
    @PlayfulPranksters 2 ปีที่แล้ว

    the file is not found after saving huhu