I have viewed 4 different tutorial videos today including this one and 3 others related to handling ADO recordsets which were helpful and gave me extremely useful knowledge today. As always, your tutorials are thorough, structured and sequenced to cover minute details of a topic being discussed. The least I can do is say "Thank you Mr. Gould" and the WiseOwl Team.
Andrew, you are a wonderful human being. I recently got hired as an IT Analyst and your videos have been the most helpful thing since I've started. Thank you so much!
Once again simple and wonderful way of explanation ...breaking the big codes to small pieces .I am learning so much and now have enough confidence to work with file dialogues. Many tahnk again Andrew and WiseowlTutorials team.
Simply, Excellent!!. Or..should I say Bravissimo in my own language. Great job Andrew. I have never found such a clear explanation of all subjects in VBA you kindly shared with all of your followers. Cheers.
These are wonderful!! I found that if you end the fd.InitialFileName with a backslash then it won't have the folder name in the dialog box fd.InitialFileName = Environ("UserProfile") & "\Desktop\"
I've been following your videos. They've been just perfect, clear and easy to follow. I'm using a Macintosh system and trying to apply Excel VBA to work on both Mac and Win. I'm actually surprised of how much can be done even with the limitations Office for Mac has. I was wondering though, do you know of any alternative Library for the FileSystemObjects functions or do you have any advise on how to work around these limitations?
Hey Andrew, thanks to u....Learning a lot from ut videos got stuck with one code.... Want to compare multiple cell values that these are same or not....Not able to find a generic code which will work for any range of cells....Have recorded a code with macro but using and(exact....) But this wasn't worked....Can u help me out here
Hello Andrew, Thanks for your videos, I really learned a lot from them. However, in this video I got a problem where no files showing when I execute the codes from your last module. Thanks for the help.
I want to thank you for your amazing videos. But I have a question, how can write a code in VBA to attach a report in Access Database into Outlook without using DoCmd function. I was hoping to use like a path link for this. Is it possible?
Hello andrew, im stuck with something. I need to make a macro where i chose a file, then copy cells from the chosen file to the current one where the macro is executed. But I dont know what to do when trying to pass it into Workbooks().Worksheets() and so on
Hi Wise Owl, From your video -24 on File Dialogues, I have figured how to prompt the user where to save a particular excel sheet and in which format. Thanks! But now, Could you tell me how to select a few excel sheets and paste them all in one single workbook one below the other? I know how to use the file dialogue box to open the excel files but they are all opening into separate worksheets. I want all of them in a single worksheet and one below the other. Please help! Thanks Vaidehi
Thank you for the great video and also I wonder why will statement like "if not FileWasChosen then" work? Shouldn't it be something like "if not FileWasChosen = 0 then" or "if not FileWasChosen 0 then"?
I get this error while using the exact code for FileDialog(msoFileDialogSaveAs) as you showed in the video: "method execute of object file dialog failed" Please Help
Hi Wise Owl, Is there any way to copy multiple .csv files into one single workbook. Also the copied sheets should all be - one below the other - in the 1st sheet of the workbook.
Thank you for another great, wonderful tutorial. (It is ME again. Sorry about that.). I have a question. Would you provide a code for DELETING. In other word, instead of SAVE or OPEN a file, I would like to be able to DELETE it or send it to recycle bin. Thank you for your help.
Why does the button name only change after you have selected the file you want to open. I would have thought that was like the title property of the FD box.
when showing or prompting file dialog fldr picker on excel 2013 . it takes very long time for me to pick the folder . it looks like the file dialog freezes , it functions and responds quickly on 2016, 2010 and 2007. what is the reason ?
I'm wondering how this test which button clicked works, it is working perfectly Sub savefile() Dim fs As FileDialog Dim chosen As Boolean Set fs = Application.FileDialog(msoFileDialogSaveAs) fs.Show If chosen = False Then MsgBox "hello" Exit Sub Else fs.Execute End If
hi andrew i resolved it declaring as office.FileDialog. thank you however. Your tuts here are very useful and well done. But just a few note: you talk tooooo speed. I know that video can become too long but try to decelerate a bit ahah. Have a good weekend.
Hi Wise Owl, I have used a file Dialogue box .. to prompt the user for a folder (where all my files are present). I have created a Dim ButtonClicked As Boolean. If Not Button Clicked Then MsgBox "You Didnt Choose!" Exit Sub End If But when I clicked 'Cancel' it is storing the default value of ButtonClicked as False. So, when I run the macro the next time and Select a folder and Click 'OK' it is saying "You didnt choose!" Which is an error. So please tell me if there is any way to set the ButtonClicked Boolean value to nothing at the end of the macro. Technically VBA shouldnt store any local variable's value after the macro ends. So, Why am I getting this error ? I would appreciate if you could reply! Regards Vaidehi
Hey I got it! I made a simple mistake. I found this when I watched your above video again. I forgot to assign the Boolean to the fd.Show ButtonClicked = fd.Show Thanks & Regards Vaidehi
thanks, thats why i start hating OOP, you can never expect what they do have and they dont have for you to use, the most programming language i liked really is C, it is so clear, you feel that you are really programming instead of just filling out parameters, thank you Andrew, really you are so helpful
![ปฏิเสธไม่ไหว (Crush on you) - LIPTA feat. No One Else [Official MV]](http://i.ytimg.com/vi/NBw1jF342vw/mqdefault.jpg)
![[LIVE] : ONE ลุมพินี 86 | คู่เอก "คมเพชร vs ชาติพยัคฆ์"](http://i.ytimg.com/vi/m3q_dRYDuU8/mqdefault.jpg)
This lesson is very very amazing, you covered almost everything we need to understand FileDialog, thanks Andy! You're so brillant!
You're so welcome! Thank you for watching and for the kind comments!
I have viewed 4 different tutorial videos today including this one and 3 others related to handling ADO recordsets which were helpful and gave me extremely useful knowledge today. As always, your tutorials are thorough, structured and sequenced to cover minute details of a topic being discussed. The least I can do is say "Thank you Mr. Gould" and the WiseOwl Team.
Thank you for the kind words!
After 4 years, still fresh and very useful tutorial, Thank you
Thank you for watching and commenting Janez!
WiseOwl is the Best VBA Tutorials on the youtube.
Andrew, you are a wonderful human being. I recently got hired as an IT Analyst and your videos have been the most helpful thing since I've started. Thank you so much!
Clear and to the point.
Not only a good example of vba file dialogs, but also a good example of how to video tutorials should be.
You explain things like no one else. You're helping me immensely for almost everything I need to get done lately. Keep being awesome!
Once again simple and wonderful way of explanation ...breaking the big codes to small pieces .I am learning so much and now have enough confidence to work with file dialogues.
Many tahnk again Andrew and WiseowlTutorials team.
Simply, Excellent!!. Or..should I say Bravissimo in my own language. Great job Andrew. I have never found such a clear explanation of all subjects in VBA you kindly shared with all of your followers. Cheers.
This is the best tutorial ever.
Brilliant work Andrew! Thank you.
And thank you for watching!
This was an excellent tutorial! By far the best I've seen! I hope that you cover pivot tables in a future video!!!
hi andrew! thank you for creating these amazing tutorials! I've learned alot from watching these!
THANK YOU SO MUCH... OMG... IT WAS SUCH A SEARCH AND FINALLY I FOUND YOU.. OMG... THANKS.
he really is the best.
Andrew, you're the best! thanks for this amazing tutorial, i learnt a lot
Thank you so much sir, for this beautiful tutorial 💯
Happy to hear that you enjoyed it Manoj!
you videos are very useful, they are very benefique for me, thenk you very match ( excuse my english i am from Algeria)
最好的关于vba的视频
Thank you!
Excellent Stuff..Andrew
Many thanks to you, Andrew :)
These are wonderful!! I found that if you end the fd.InitialFileName with a backslash then it won't have the folder name in the dialog box
fd.InitialFileName = Environ("UserProfile") & "\Desktop\"
Fantastic. Thank you so much. Really helpful
Perfect Again. I have learned so much from you Andrew (:
Thank you for an interesting lecture.
I've been following your videos. They've been just perfect, clear and easy to follow.
I'm using a Macintosh system and trying to apply Excel VBA to work on both Mac and Win. I'm actually surprised of how much can be done even with the limitations Office for Mac has. I was wondering though, do you know of any alternative Library for the FileSystemObjects functions or do you have any advise on how to work around these limitations?
Hey Andrew, thanks to u....Learning a lot from ut videos got stuck with one code.... Want to compare multiple cell values that these are same or not....Not able to find a generic code which will work for any range of cells....Have recorded a code with macro but using and(exact....) But this wasn't worked....Can u help me out here
Hello Andrew,
Thanks for your videos, I really learned a lot from them. However, in this video I got a problem where no files showing when I execute the codes from your last module. Thanks for the help.
Many thanks, very insightful
How to automatically click on the save button in the Save as dialogue box?
I want to thank you for your amazing videos. But I have a question, how can write a code in VBA to attach a report in Access Database into Outlook without using DoCmd function. I was hoping to use like a path link for this. Is it possible?
Hello andrew, im stuck with something. I need to make a macro where i chose a file, then copy cells from the chosen file to the current one where the macro is executed. But I dont know what to do when trying to pass it into Workbooks().Worksheets() and so on
very clear
Thanks!
Hi Wise Owl,
From your video -24 on File Dialogues, I have figured how to prompt the user where to save a particular excel sheet and in which format. Thanks!
But now, Could you tell me how to select a few excel sheets and paste them all in one single workbook one below the other? I know how to use the file dialogue box to open the excel files but they are all opening into separate worksheets. I want all of them in a single worksheet and one below the other. Please help!
Thanks
Vaidehi
excellent! i've learned a lot. tnx.
Thank you for the great video and also I wonder why will statement like "if not FileWasChosen then" work? Shouldn't it be something like "if not FileWasChosen = 0 then" or "if not FileWasChosen 0 then"?
***** I see. Thanks for your patient reply.
I get this error while using the exact code for FileDialog(msoFileDialogSaveAs) as you showed in the video:
"method execute of object file dialog failed"
Please Help
Hi Wise Owl,
I figured it out. Thanks anyways.
Regards
Vaidehi
Hi Wise Owl,
Is there any way to copy multiple .csv files into one single workbook. Also the copied sheets should all be - one below the other - in the 1st sheet of the workbook.
Thank you for another great, wonderful tutorial. (It is ME again. Sorry about that.). I have a question. Would you provide a code for DELETING. In other word, instead of SAVE or OPEN a file, I would like to be able to DELETE it or send it to recycle bin. Thank you for your help.
Why does the button name only change after you have selected the file you want to open. I would have thought that was like the title property of the FD box.
when showing or prompting file dialog fldr picker on excel 2013 . it takes very long time for me to pick the folder . it looks like the file dialog freezes , it functions and responds quickly on 2016, 2010 and 2007. what is the reason ?
Thanks for your reply . i will try to find a solution .by the way thanks for your tuts again. they really helped me a lot.
can we open multi workbooks at a time with code ?
I had an error that said "Path not found"
I copied everything you typed and checked for typos but didn't see any
I'm wondering how this test which button clicked works, it is working perfectly
Sub savefile()
Dim fs As FileDialog
Dim chosen As Boolean
Set fs = Application.FileDialog(msoFileDialogSaveAs)
fs.Show
If chosen = False Then
MsgBox "hello"
Exit Sub
Else
fs.Execute
End If
thank, this helps a lot, thank you again
hi
When i declare a fd as filedialog type it run a warning:" module is not a valide type
Why?
hi andrew i resolved it declaring as office.FileDialog. thank you however. Your tuts here are very useful and well done. But just a few note: you talk tooooo speed. I know that video can become too long but try to decelerate a bit ahah. Have a good weekend.
Hi Wise Owl,
I have used a file Dialogue box .. to prompt the user for a folder (where all my files are present). I have created a Dim ButtonClicked As Boolean.
If Not Button Clicked Then
MsgBox "You Didnt Choose!"
Exit Sub
End If
But when I clicked 'Cancel' it is storing the default value of ButtonClicked as False. So, when I run the macro the next time and Select a folder and Click 'OK' it is saying "You didnt choose!" Which is an error. So please tell me if there is any way to set the ButtonClicked Boolean value to nothing at the end of the macro. Technically VBA shouldnt store any local variable's value after the macro ends. So, Why am I getting this error ?
I would appreciate if you could reply!
Regards
Vaidehi
FYI, I have not used any static variables in my code.
Hey I got it! I made a simple mistake. I found this when I watched your above video again. I forgot to assign the Boolean to the fd.Show
ButtonClicked = fd.Show
Thanks & Regards
Vaidehi
thank you!!!!!
just wondering why didn't you use the ‘buttons’ parameter : Cancel to check if it was clicked, this what you teach us to get the result
thanks, thats why i start hating OOP, you can never expect what they do have and they dont have for you to use, the most programming language i liked really is C, it is so clear, you feel that you are really programming instead of just filling out parameters, thank you Andrew, really you are so helpful