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.
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, 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
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?
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!
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.
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.
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?
Hi TanteHela, Dropbox has betrayed me. . . sort of. Apparently, since I have soooo many people from UA-cam downloading my workbooks, Dropbox decided to suspend my links for a period. Not sure how long. I'm going to have to put them up on my website to ensure this doesn't happen again. Sorry about that! Thanks Dan
Thanks for the response. Not a problem at all. Please let me know when/where to download. I just keep replaying your posts on UA-cam till then. Loving every bit of code!
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 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!
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.
perfect! Thanks for the help
Very welcome, Didleeios88
I agree with krn14242, it is great to see your post!!! : )
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 if I need to select multiples file and want to open file one by one can please explain this.....
Hi, Dan. It's ben awhile. Good to see you again. Thanks for the video.
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
Thank you so much! This helped me a lot
Thanks for share
Thank you very much its a great help
You are so welcome!! Thanks for the comment!
Great video, many thanks. Quick question - Is it possible to browse for a folder rather than a file?
Thank you for this option. But what if I want to open the workbook in same excel file as sheet? Could you please help?
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 !!
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?
Hi, if we have specific question like this video did, what is the best way to reach you? Thanks!
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!
Hi Ben,
I'm not at a PC rn, but try
ChDir "c:\work" 'change directory to work folder
Hope that helps
Thanks
Dan
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.
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.
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?
Hi TanteHela,
Dropbox has betrayed me. . . sort of. Apparently, since I have soooo many people from UA-cam downloading my workbooks, Dropbox decided to suspend my links for a period. Not sure how long. I'm going to have to put them up on my website to ensure this doesn't happen again. Sorry about that!
Thanks
Dan
Thanks for the response. Not a problem at all. Please let me know when/where to download. I just keep replaying your posts on UA-cam till then. Loving every bit of code!
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!!
I need to work on the rows between two yellow raws, there I need to concatenate two columns into second column please help
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!
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.
How to edit the opened file? I'm trying to filter the opened file and send automatic email notice
it is giving Compile Error??????????????