Get Treeview selected node into a string.

Hi All,

I have the below macro which downloads the attachments from a particular folder of outlook. It works perfectly but the only thing is that I need to hardcode the folder name in the below macro which I don't want to do. I thought use the inputbox method so that user can enter the folder name and then macro can download the attachments from that folder which user has entered in inputbox but the user may or may not enter the folder name correctly, so I thought to come up with a userform which will show the Treeview of all outlook folder on the userform and the user will the select the folder from the treeview but I am unsure that how do I use the treeview node selected by the users as a string and use the same in my code in such a way that the code downloads the file from the selected folder.

Please Login or Register  to view this content.

So far I have the below code which I got from a google search the below code loops through the treeview and checks which node is selected by user. Please help...

Please Login or Register  to view this content.

Thanks a lot for your help in advance.

Hi Andy,

Thanks a lot for your reply, But I am unable to incorporate the code line provided by you in my code. I tried the below things but it didn't work. Here is what I tried.

1)

Please Login or Register  to view this content.

. This didn't work.

2)

Please Login or Register  to view this content.

' Even this didn't work.

Thanks a lot for your reply in advance.

Hi Domski,

Thanks a lot for your reply, Can you please let me know how can I incorporate the code lines provided by you to get the user selected item as a string from treeview of my userform.


Thanks a lot for your help in advance.

Hi Andy,

Thanks a lot for your reply, I have tried to incorporate the below code posted by you but it's still not working. Please help..

Please Login or Register  to view this content.

Thanks a lot for your help in advance.

Hi romperstomper,

Thanks a lot for your reply, I will ensure the same going forward.

Hi Domski,

Thanks a lot for your reply, I tried to run the code provided but it doesn't work. It throws a error message. .i.e. variable not found. It gets stuck on the below line and highlights the ThisOutlookSession word. I have selected the references to Microsoft Outlook xx object library and Microsoft Outlook xx view control as well in my vba project. please help.

Please Login or Register  to view this content.

Thanks a lot for your help in advance.

Hi Andy,

Thanks a lot for your reply, Please find the attachment for my macro file.

Thanks a lot for your help in advance.

Hi Andy,


Thanks a lot for your reply, I have incorporated code posted by you in my main macro file but it's still not working can you please look into my file. I have attached it for your reference.

One more thing can we select the multiple folders and download the files from multiple folders at one go.

Thanks a lot for your help in advance

Hi Andy,

Thanks a lot for your reply, When I say that it's not working I mean to say it's not downloading the files as it use to do earlier. It just shows me a message box when I run the macro with the text .i.e. myfolder has 9 items folder. that's it and then it shows a error message. I have attached the error screenshot for your reference.

Thanks a lot for your help in advance.

Hi Andy,

Thanks a lot for your reply, the code posted by you shows the msgboxes and shows the attachments names but it doesn't download those file. Please help...

Thanks a lot for your help in advance.

Hi Andy,

Did you get the chance to look into my above post ?

Thanks a lot for your help in advance.

Hi All,

I was finally able to figure out the error issue from my end and here is the final code. The below code works absolutely fine. I can download the files from a selected outlook folder but I still have one more issue which I am unable to fix .i.e. if I select more then one subfolders in treeview it doesn't allow me to do that. I have changed the treeview properties so that it shows me the check boxes. Please help. I have attached my final macro file for your reference.

Code in my userform .i.e. frmdownloadattchmts :

Please Login or Register  to view this content.

Code in my module :

Please Login or Register  to view this content.

Thanks a lot for your help in advance.

Hi Andy,

Thanks a lot for your reply, I have incorporated the modified code posted by you in main macro but unfortunately still it's downloading the files from only one folder at a time. It doesn't download the files from multiple folders even though if I select them in the treeview using checkboxes. Please help..

Code in Commandbutton event :

Please Login or Register  to view this content.

Code in Module :

Please Login or Register  to view this content.

Thanks a lot for your help in advance.

Hi Andy,

Thanks a lot for your reply, It works fine now. You are just awesome. But still there is a small issue .i.e. after downloading the files from each folder it shows a msgbox that it has downloaded the files which is what I want to suppress I it to show the download completion message once. Here is the part of code which is creating this issue.

Please Login or Register  to view this content.

Thanks a lot for your help in advance.