Browse for Folder from Chip Pearson
 

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?
--
HTH,
Barb Reinhardt

Browse for Folder from Chip Pearson
 

Are you using the API version or the Shell Object version?
--
Gary''s Student - gsnu200802


"Barb Reinhardt" wrote:

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?
--
HTH,
Barb Reinhardt

Browse for Folder from Chip Pearson
 

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

Barb Reinhardt



"Gary''s Student" wrote:

Are you using the API version or the Shell Object version?
--
Gary''s Student - gsnu200802


"Barb Reinhardt" wrote:

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?
--
HTH,
Barb Reinhardt

Browse for Folder from Chip Pearson
 

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


"Barb Reinhardt" wrote:

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

Barb Reinhardt



"Gary''s Student" wrote:

Are you using the API version or the Shell Object version?
--
Gary''s Student - gsnu200802


"Barb Reinhardt" wrote:

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?
--
HTH,
Barb Reinhardt

Browse for Folder from Chip Pearson
 

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

Barb Reinhardt



"Gary''s Student" wrote:

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


"Barb Reinhardt" wrote:

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

Barb Reinhardt



"Gary''s Student" wrote:

Are you using the API version or the Shell Object version?
--
Gary''s Student - gsnu200802


"Barb Reinhardt" wrote:

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?
--
HTH,
Barb Reinhardt

Browse for Folder from Chip Pearson
 

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



"Chip Pearson" wrote:

The code should work fine in Excel 2007. I don't have a SharePoint site
working on this server to test with, but a quick test of the code (on both a
Vista box and a Windows Server 2008 box) shows that it will display mapped
drives and network locations. I don't know enough about SharePoint to know
if the behavior you experience is expected for SharePoint shares. You might
ask down the hall in the SharePoint group.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)





"Barb Reinhardt" wrote in message
...
LOL I'm so sorry. I misread your question. I shouldn't be multitasking
right now. I'm using the API version.

Barb Reinhardt



"Gary''s Student" wrote:

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


"Barb Reinhardt" wrote:

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

Barb Reinhardt



"Gary''s Student" wrote:

Are you using the API version or the Shell Object version?
--
Gary''s Student - gsnu200802


"Barb Reinhardt" wrote:

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?
--
HTH,
Barb Reinhardt