Browse For File and Open Workbook with Excel VBA 

Long time since I have seen your name pop-up in my subscription list. Good to see ya. Thanks for the video.

This match my requirement , i was searching this in the You tube and Google for a while but none of them are working and able to understand. I have tried this and it is good to go. Thank you so much bro, you made my work easy.

Hi, Dan. It's ben awhile. Good to see you again. Thanks for the video.

Thank you so much! This helped me a lot

I agree with krn14242, it is great to see your post!!! : )

Thanks for share

Thank You !!

perfect! Thanks for the help

Thank you very much its a great help

Hi, thank you so much for this video!!! It is super helpful. However, I am trying to write a macro which opens the file on a double click and puts that file name into that cell for the whole A column. Would this be an if statement? Thank you!!

Hi if I need to select multiples file and want to open file one by one can please explain this.....

this is very easy to understand video that explains it all in such short time. Thank you very much for that! I just have a question: if you want to select multiple files from the same file path, how do you do that? Many thanks, TD

Hi Daniel, i have a couple of questions and i was wondering if you could help me. the questions are regarding how to import data from textfiles in excel and what to do with it. I have watched a video of yours and find it very instructive and good. The video was about how to import txtfiles into word. If you are able to help it would be alot of help, is it possible to interact via mail or anything like that? Thanks!

good simple tutorial. now i have a question, how do you use that file path name in vlookup? how do I use c:\...\filename.xls in table array? by pointing to the cell directly?

Great video, many thanks. Quick question - Is it possible to browse for a folder rather than a file?

Hi, if we have specific question like this video did, what is the best way to reach you? Thanks!

Hi, I want to add the contents of the excel files one below the other into the single worksheet in the workbook. Could you tell me how to do it ? Thanks Vaidehi

Thank you for this option. But what if I want to open the workbook in same excel file as sheet? Could you please help?

I need to work on the rows between two yellow raws, there I need to concatenate two columns into second column please help

Hey how can i use this to browse any file from website or any sharepoint. Am working on a project where i need latest file to work on it. Please help on this.

How to edit the opened file? I'm trying to filter the opened file and send automatic email notice

The problem with this method is it doesn't seem to be available in a WITH statement. I get the infamous run-time error 438 when I use it in my procedure. In the procedure I create an Outlook email that will insert the file and send it to recipient(s). The code is below: Sub insertGTfile() Dim ol As Outlook.Application Dim mi As Outlook.MailItem Dim doc As Word.Document Dim gtfile As Object Set ol = New Outlook.Application Set mi = ol.CreateItem(olMailItem) mi.Display mi.To = "###########" mi.Subject = "Gas Turbine Data" Set doc = mi.GetInspector.WordEditor With mi .gtfile = Application.GetOpenFilename(, , "Select file to open") .Attachments.Add "C:\Downloads\GasTurbineDataTablePartGroupMatch.xlsx" End With End Sub Notice, I have the attachement property in the WITH and that works fine. That is, if I remove the gtfile variable and run this procedure to the mail recipient it goes thru without error. But, this means the procedure doesn't allow a user to select a file and insert it to the email and that's clearly not what I want. 438 indicates "the object doesn't support this property or method". This can be many things as you. Well, any help is appreciated.

Hi, Dan. Thanks for all the great tutorials, keeps me smiling to Excel! I would like to use some sample files from your Dropbox but keep getting the 429-error....(way to much traffic) and is temporarily disabled. Is there another way to get to those files?

Is there a way to set a default location for when the window pops up? For example, I want it to prop me to choose a file in my "work" folder and not just my general documents. Thanks!

Sir nice vedio sir i want four file differ field name store. Another one file four sheet with four sheet name exsit

can you write a vba code to save a open workbook , which was opened by a tool .I tried to write a code using activeworkbook save as method , but it doesn't work , please help me with this code , it will be really helpful.

it is giving Compile Error??????????????