Save As Dialog to Save a Workbook in Excel VBA

[@smithvasanthakumar136]

Spent a long time trying to figure out how to stop the macro if the user hit cancel on the save dialog, and this video finally helped me figure it out. Thanks!!

[@billmiller6312]

I found myself needing exactly what you demonstrated here. Not only did it work for me as advertised, I found your instructional approach to be extremely easy to follow without teaching me VBA (a novice). Thank you for this.

[@TheAtticusFinch3]

Excellent tutorial. Showed me exactly what I needed to know and made it very simple to do on my own. Thank you!

[@Computergaga]

That is brilliant to hear. Thank you, Brett.

[@sasavienne]

Let me tell you something; your way of explaining things is simply perfect. After watching your videos I feel motivated to learn more and more. Here is a big like for your extraordinary work. Thanks indeed. Best regards. Salim

[@Computergaga]

Thank you Salim.

[@sasavienne]

@@Computergaga No need to thank me. Thank you for your kindness and for these valuable efforts. I love your videos.

[@moodkn]

Very high Greetings to you.. .. You Solved My Problem.... Lot of Thanks Sir !

[@Computergaga]

You are welcome

[@stront]

Hi there! Thanks for the great tutorial. I was wondering if it'd be posible to save it as a .pdf file and also get rid of the second page showing the buttons?

[@jagrutikumavat393]

Hii, thanks for sharing small and working code now I'm going to subscribe your channel coz I'm VBA developer and joint my 1st job and currently doing my very 1st project your code helps me alot thank u so much

[@lord_of_house]

Magnificent guide, thank you, followed it without sound and still I was able to make it, besides for begginers I would recommend to create the macro by Right Click in the Excel File (once inside the IDE on the left panel) and then Insert and Finally Module to start a Blank Module, the Option Explicit doesn't matter, greetings from Bolivia!

[@Computergaga]

Thank you, Guillermo. Your comments are much appreciated!

[@that1guynamedalex]

i've been trying to figure out something like this for the longest time. still really learning VBA. definitely helped sooooo much!

[@Computergaga]

You're welcome. Thank you.

[@erdemcorbac9052]

Hello, Thans for video, I want ask one. If i want save as a file containing a macro what i need do?

[@pedromoura1356]

Love you bro, u saved me!

[@Computergaga]

No problem 👍

[@chuckpeterson5882]

This is very helpful. I'm a newbee to VBA. I have a form to fill in, and it needs to be saved as xlsx and in the original folder where the xlsm file is. Any hints? I've copied the code and it works, I just need it tweeked. I've been struggling for a week on this.

[@wayneedmondson1065]

Hi Alan.. another excellent training. Also, since I've taken your VBA course which I highly recommend.. it makes perfect sense and I was able to follow along and learn this functionality. Thanks and thumbs up! PS - I agree 100% with the comment below by Salim Saba. Your presentations are engaging and motivating.. makes me want to dig in and learn more with each one I view. Keep them coming!

[@Computergaga]

Thank you very much Wayne.

[@heberalanis6190]

Braaaavooooo, you are amazing I was trying to do the same and looking in many places, but this is the easiest way to do it, just perfect I made a small modification, grabbing the path from a cell which is using the next formula =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1) . Thank you

[@gauravvadehra]

Superb. Just what i was looking for. I want to save the file name picked up from B7 & D7 and file name should be a combination of B7 & D7 cells in my excel sheet. Is this possible ?

[@ladyprintboss]

this is a good tutorial but is there away to save a copy and and not change the file name? I am looking to save a copy of the file only. I guess Ill go back to the thisworkbook.savecopyas function to save the workbook.

[@rayl1043]

Ray An excellent tutorial, but is there a way to save a copy and open a new invoice after using the same invoice on the different jobs with a unique invoice number and file name? I am looking to save a copy of the file only. Thank You!.

[@AndrijaTrojanovic]

Hey, this looks like a great little tool but I have an issue when trying to execute: Run time error '91': Object variable or With block variable not set Do you have any input on this?

[@anshurang]

A very big thanks to you.. you dont know how big my problem you solved... Again thank you so much for share this ..

[@Computergaga]

You are most welcome Tayyab.

[@H2000.2]

Hi, great vid. Helps alot, just one thing I have a question on. When I use the button and then save as PDF, and then go to open the PDF, it is corrupted. Do you know why this is? Thanks!

[@lolke-louisclaassen3443]

Hi. Great video! How do I force a file format during the save? let's say, .csv?

[@hhnnkw]

its working good but i want save it as macro enabled as deflate , how can do it ??

[@SplendidApeDiva]

BRILLIANT!! THANK YOU SO MUCH!!!

[@Computergaga]

You're welcome. Thank you.

[@pramithkk6102]

Super video , I was looking for this from long time. Can you help me with the code here

[@Computergaga]

Great to hear, Pramith.

[@rf8209]

Thank you so much !!

[@Computergaga]

You're very welcome.

[@joepvanmotman108]

Good tutorial!. Everything works fine but when the macro tries to Execute i get a warning saying Method 'Execute of object 'FileDialog" failed. Can anyone help?

[@thomasqueirozcosta1653]

Hi! Your video was incredible, and very easy to follow, thanks a lot. I'm having an error when I try to run this macro on some computers with excel2010, could you help me with that? It crashes at the ".execute" and gives me this msg: "Run-time error '-2147467259 (80004005)': Method 'Execute' of object 'FileDialog' failed I've searched for a explanation, since it works just fine on some computers, but I wasn't able to find anything that could solve this problem :( thanks a lot in advance

[@sasavienne]

Do you have a Website where I can get more information about learning VBA? I am curious. Are you Australian? I could not find out this from your accent? Thanks for your efforts.

[@Computergaga]

Hi Salim. I am British. I am information at my blog - www.computergaga.com/blog/ I also have an online course in VBA - bit.ly/2CAscmA

[@sasavienne]

@@Computergaga . Thanks for having provided me with these websites, so that I can learn more and more. The world of VBA is limitless and I am so thrilled when I see everything which can be done with VBA. I am trying to improve my Skills. Thanks again and best regards from the north of Germany.

[@sasavienne]

@@Computergaga Wow . You are on Udemy too. I am registered there and I bought some tutorials and now I am gonna buy yours as well. Please tell me if you have other tutorials which I can buy as well. I am gonna recommend you to my collegaues.

[@Computergaga]

Thank you Salim.

[@Computergaga]

Good work Salim.

[@francisthegeek]

Thank u for this. Very helpful.

[@Computergaga]

You're welcome Francis.

[@mikeejoh8993]

Great video..I keep coming up with an error "object variable or with block variable not specified". Any way to fix that?

[@Computergaga]

Thank you Mike. It may be that you are missing the word 'Set' before defining to an object variable.

[@jopcfarm]

thank you

[@Computergaga]

You're welcome, Jo.

[@improveeveryday6559]

Thank you so much ! I'm facing am issue with my excel sheet that I'm not able to perform multiplication from a column without removing initial indent , is there any formula to remove initial indent to avoid removing it manually. Also, trim formula is not working ! Can I share worksheet with you on email for better understanding ? Thank you in advance

[@Computergaga]

The CLEAN function might help with the indent. Yes you can share worksheets via email with me.

[@improveeveryday6559]

May I know your email id

[@TheAlienware89]

I dont know what im doing wrong, code is runing fine, but my folder is empty... they dont save it anything.

[@rf8209]

What else to do if I want to save it as macro enabled ?

[@Computergaga]

You can add a Filter Index. The following line will make it macro enabled. .FilterIndex = 2

[@wardydoes]

@@Computergaga You beaut!

[@santhosh370]

can you do this to save web page ? if so please make a video on that

[@Computergaga]

Sure this can be done. It is an option in the Save As Dialog.

[@antonioparadiso6975]

Hi! I want to know how can I save as PDF just one sheet of my entire project with your perferct macro. I not need to save all project, just the selected sheet.. Can you help me, please? Thank you!

[@Computergaga]

I have this video - kzbin.info/www/bejne/lZ3ImGhje69gr9k

[@antonioparadiso6975]

@@Computergaga need something in vba.. I need, if it's possible, use your macro with InitialName.. can you help me? :)

[@jamalrashdan7303]

But can I keep the original file open and close the new file? thank you

[@robertooaxaca]

i getting otherwise, the original file opened and the new file closed...

[@ginjaas]

I'm sorry but i wrote the code exactly the same and works all the way correctly but when i press save the file is not saved. The only difference is that i want to choose the file location instead of a predefined one. I'm using excel 2010

[@Computergaga]

Maybe there is a mistake in the file path you provided.

[@giggle_moves]

I don't get it :(

[@sitimariajulpah9082]

This video not good

[@Computergaga]

My apologies.