Save As Dialog to Save a Workbook in Excel VBA
Вставка
- Опубліковано 5 лип 2024
- In this video, we use the Save As dialog to save a workbook in Excel VBA. This is great because it provides a familiar environment to the user when saving a workbook.
Take our comprehensive Excel VBA course to learn it all - bit.ly/2CAscmA
In the video, we explain the key properties and methods of the Save As dialog. And use them in a real world example to effectively save a workbook.
The video will take you from start to finish of the process with full demonstration.
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/2JvnnRv
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1 - Навчання та стиль
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!!
Very high
Greetings to you.. .. You Solved My Problem....
Lot of Thanks Sir !
You are welcome
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
BRILLIANT!! THANK YOU SO MUCH!!!
You're welcome. Thank you.
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.
Thank u for this. Very helpful.
You're welcome Francis.
Love you bro, u saved me!
No problem 👍
i've been trying to figure out something like this for the longest time. still really learning VBA. definitely helped sooooo much!
You're welcome. Thank you.
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!
Thank you very much Wayne.
Excellent tutorial. Showed me exactly what I needed to know and made it very simple to do on my own. Thank you!
That is brilliant to hear. Thank you, Brett.
A very big thanks to you.. you dont know how big my problem you solved... Again thank you so much for share this ..
You are most welcome Tayyab.
Thank you so much !!
You're very welcome.
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
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?
Hi. Great video! How do I force a file format during the save? let's say, .csv?
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!
Thank you, Guillermo. Your comments are much appreciated!
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
Thank you Salim.
@@Computergaga No need to thank me. Thank you for your kindness and for these valuable efforts. I love your videos.
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!.
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.
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!
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 ?
thank you
You're welcome, Jo.
Hello, Thans for video, I want ask one. If i want save as a file containing a macro what i need do?
Super video , I was looking for this from long time. Can you help me with the code here
Great to hear, Pramith.
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.
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?
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
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?
Great video..I keep coming up with an error "object variable or with block variable not specified". Any way to fix that?
Thank you Mike. It may be that you are missing the word 'Set' before defining to an object variable.
can you do this to save web page ? if so please make a video on that
Sure this can be done. It is an option in the Save As Dialog.
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.
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
@@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.
@@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.
Thank you Salim.
Good work Salim.
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
The CLEAN function might help with the indent. Yes you can share worksheets via email with me.
May I know your email id
its working good but i want save it as macro enabled as deflate , how can do it ??
But can I keep the original file open and close the new file? thank you
i getting otherwise, the original file opened and the new file closed...
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!
I have this video - ua-cam.com/video/_leg5-FJ-yw/v-deo.html
@@Computergaga need something in vba.. I need, if it's possible, use your macro with InitialName.. can you help me? :)
What else to do if I want to save it as macro enabled ?
You can add a Filter Index. The following line will make it macro enabled.
.FilterIndex = 2
@@Computergaga You beaut!
I dont know what im doing wrong,
code is runing fine, but my folder is empty...
they dont save it anything.
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
Maybe there is a mistake in the file path you provided.
I don't get it :(
This video not good
My apologies.