PDA

View Full Version : Solved: how to open a folder?



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

Thanks.

grichey
03-17-2008, 03:15 PM
Change your directory?
ChDir "S:\ (file://\\Budget)Accts.Invoices\" or to open the file
Workbooks.Open Filename:= _
"S:\ACCTS.INVOICES\Myfile.xls"

next
03-17-2008, 04:18 PM
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
03-17-2008, 04:43 PM
What do you mean by open a directory?

Zack Barresse
03-17-2008, 04:45 PM
Yes, take a look here...


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


HTH

next
03-18-2008, 06:55 AM
Great! Works perfectly, thanks firefytr (http://www.vbaexpress.com/forum/member.php?u=11)!

Zack Barresse
03-18-2008, 02:40 PM
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
03-19-2008, 04:27 PM
I was wondering how to do that, lol. Why not add a big button "mark as solved" next to "quote" ???

Zack Barresse
03-20-2008, 09:07 AM
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. :yes