Easy Open File Question

[aiden1983]

How can I get a macro to open up the openfile command to a specific folder ie "C:\Yellow\new folder"?

 

[GTO]

try:

Workbooks.Open Filename:="C\Yellow\New Folder\Your_Workbook_Name.xls"

 

[Diablo II]

or this

Sub open_file()
Dim bResponse As Boolean
bResponse = Application.Dialogs(xlDialogOpen).Show( _
    "c:\Yellow\new folder\")
If Not bResponse Then Exit Sub
End Sub

 

[aiden1983]

try:

Workbooks.Open Filename:="C\Yellow\New Folder\Your_Workbook_Name.xls"

I can't use this as the name of the file is always changing (this is why I am having an issue). The other suggestion doesn't work either.

 

[Diablo II]

did you put mine in as it was, all it will do is open the xlDialogOpen box to your folders. to let you pick a file. what excel you use?

 

[aiden1983]

did you put mine in as it was, all it will do is open the xlDialogOpen box to your folders. to let you pick a file. what excel you use?

Ya I tried yours and yes it opens the box up but not to the folder I would like. I might just be our server here that is the issue. If there is no simple solution they will just have to search foe the folder themselves.

 

[Diablo II]

it works on mine each time, check the file loc in the code i my have it with to much space in the names.

 

[aiden1983]

oh it works now, I needed the "\" thanks