Macro to open a folder

[drsiaca]

I have tried this code it does not allow me to open a file from the folder

With filename
.InitialFileName = ("C:\Documents\bin\february")
.Show
End With

I will like to know if there is a code that will let me open a file from a folder that the macro opens.

Have also tried another code that gives me the error that the file is encrypted.

Is there such a code possible?

[ragavan.sridar1]

Do you want to open the excel file?

you can just use something like this.

Please Login or Register  to view this content.

[drsiaca]

Thanks for quick response

I want to open a folder and from that folder open the file
This because the variable (month) changes with input from a input box, and from there I can choose any file I need to open

[ragavan.sridar1]

Then try this..

Please Login or Register  to view this content.

[drsiaca]

Works like a Charm Thanks!!

[ragavan.sridar1]

Please,mark your thread [SOLVED] if you received your answer.

Click the little star * below, to give some Rep if you think an answer deserves it.