How to Open Folder in Excel Using VBA

[johntrentham]

This is so great! With the newest version of Excel the native Open command shows a dialogue box that requires you to click Browse before seeing file directories. All those extra clicks add up to a lot of wasted time. Thank you so much for sharing your wisdom :)

[narendrangananathar]

As always, thank you for sharing this video clip.

[calussabroson]

Hi! Amazing content! I would appreciate it if you could teach us how to close the folder we just opened with VBA.

[manin]

Very good sir... Small question.. How to save excel file in desktop folder//or any folder of wish.. through command button???

[ladyprintboss]

awesome but how can i open a folder in the same location as the workbook using the path? that will allow the user to not specify the path . this would be helpful for distributing the worksheet

[banwarifageriaexcelclasses]

it is nice tutorial...Dinesh jee could you make a complete video on VBA ..IT is strong desire to learn vba from initial level ..
also please make a lesson on VLOKKUP WITH INDIRECT..THANKS A LOT .

[aliyasir]

Hi Dinesh Sir,

Thank you for sharing this video. I have one question i have prepared one file compiler earlier i have provided the coding of a particular folder from where excel pick the files and compiles now i want to change the pattern and i want to browse the folder with the help of VBA and compile the files after browsing. I am able to browse files with the help of Application. folder picker but after that it is showing object error i think due to path can you please help how i cak fix that it is really important for me

[anandparthiban]

Sir I have a textbox in userform and in that textbox I have some folder path which is maintained in excel I will pull that link through search command Now can I open that folder by click button, is there any codings available

[slain]

Hi Dinesh, thanks for sharing all your knowledge, and love it all. I have a troublesome calculation that I cant solve and hopefully you have an answer. I have 2 columns( column A has auto increment and column B have numbers that increase with every cell). My conundrum is I want the auto increment to restart after 15 or if a cell in column B "say for instance reach a value of 300" (whichever comes first) and then restart the auto increment. Is there a solution to this problem? If possible without vba...

[prashanthyelde]

Please let me know how to work with web browsers using VBA

[kodurkarthik]

Hi sir, I want text box that displays day ex:Thursday (Thu) in userform , so please help me ..
Thanks in advance

[confidential]

the first one seems much straightforward then the second. but is in some cases the second option preferred?

[salsabilzaghdoudi]

Hello,




How can I specify a directory when adding files on excel worksheets using VBA by clicking on a button? I have the below code that I've written to add files but I want to specify to the user that the file is in some directory, for example, so when he adds a file he will be directed to a folder named "Doc" where he can add the file he wants.


Private Sub CommandButton1_Click()

repertoire = Application.GetOpenFilename()

End Sub

[xguyzerx]

how do you open a file using this network file path? ?

[seemoon]

Sir how can we put password for folder and how can sign in so to make information secure... thanx

[brunoFranco-bh]

YOU JUST HELPED ME THANKS \(", )/

[ignaciot.guaciniii]

Hi Sir, I am grateful on how you simplify the excel vba codes for us (newbie) can easily to be understood and thank you for your way of sharing your skills and knowledge... At his point I am making a database with 2 separate excel-workbook, the other one with user user form while the other is just a database just to receive and save imported data from the userform... and I am curious enough if is it posible to import the increment number from excel-database to userform? and also can you please help me as well to create a three-digit increment number from 000 up to 999... thanks in advance...[Ignacio Guacin III of Philippines]