Browse for Folder from Chip Pearson

[Barb Reinhardt]

I've been using this code for about a year

http://www.cpearson.com/excel/BrowseFolder.aspx

and I'm now in the process of converting my macros to Office 2007. I'm
trying to test them on another machine, so I can't say if everything is
consistent. As far as I know, the only difference is that Office 2007 is
loaded instead of Office 2003.

I'm trying to select a mapped sharepoint drive using this code and this code
is no longer able to see it.

Does anyone have any ideas?

 

[Gary''s Student]

Are you using the API version or the Shell Object version?

 

[Barb Reinhardt]

Yes. I guess I didn't mention that before.

Barb Reinhardt

 

[Gary''s Student]

Which one??
--
Gary''s Student - gsnu200802

Yes. I guess I didn't mention that before.

Barb Reinhardt

 

[Barb Reinhardt]

LOL I'm so sorry. I misread your question. I shouldn't be multitasking
right now. I'm using the API version.

Barb Reinhardt

 

[Barb Reinhardt]

Chip,

It looks for a folder, but nothing is listed. I'm guessing that it is
another problem and I'm not even sure where to look for the answer.

Thanks for your help.
Barb Reinhardt