Solved: how to open a folder?

[next]

i would like my macro to open a folder, how?
For example: "S:\ACCTS. INVOICES" <- this.

Thanks.

[grichey]

Change your directory?
[VBA]ChDir "S:\Accts.Invoices\"[/VBA] or to open the file [VBA]
Workbooks.Open Filename:= _
"S:\ACCTS.INVOICES\Myfile.xls"[/VBA]

[next]

no, i was wondering if it's possible to open a directory, no change it.
I'm not even sure if this is possible, just a shot in the dark.

Thanks.

[Bob Phillips]

What do you mean by open a directory?

[Zack Barresse]

Yes, take a look here...


http://www.vbaexpress.com/kb/getarticle.php?kb_id=905


HTH

[next]

Great! Works perfectly, thanks firefytr!

[Zack Barresse]

You're very welcome. Don't forget you can mark your thread as SOLVED by going through the THREAD TOOLS drop down at the top of your post.

[next]

I was wondering how to do that, lol. Why not add a big button "mark as solved" next to "quote" ???

[Zack Barresse]

Because it would put it next to every button on every post. The way the php software is designed, it's easier to keep it in Thread Tools, which is exactly what it is, a tool. Thanks for the suggestion/feedback though.