Open folder

[renrut_5]

I have gone through the steps and have a program running somewhat flawlessly but am having some issues with the following and would like some assistance.

This code will open the previously created folder as it should, however it opens it as it is looking for the user to select as (XL) program to open and will only show (XL) files. I need it to just open the blank folder so that I can see that my pictures have been copied into it without the user have to the "Show files" drop down menu. Trying to keep it simple for all that will be using it. I have looked at all that pops up after Application.dialogs( and all that is there is XL integrated commands.

ChDrive "C:\"
ChDir HideForm1.txtinbound.Text
Application.Dialogs(xlDialogOpen).Show

Please find attached a screenshot of what does open at this command. Any suggestions would be greatly appreciated.

 

[John_w]

Replace the 3 lines with:

    Shell "C:\Windows\explorer.exe """ & HideForm1.txtinbound.Text & """", vbNormalFocus

 

[renrut_5]

Perfect, that worked just how I need it to.

Thanks