LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Browser Functions Problem

If code execution resumes at the second "End If" following the "If ID Then"
line, that means that the ID variable has a value of 0. According to MSDN,
this will occur only if the user click's Cancel on the dialog. Beyond that,
I have no idea why the function would fail. The Knowledge Base has nothing
relevant on the topic.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Jaemun" <x wrote in message ...
Hello Chip Pearson,

Thanks for the advice. I totally agree with you. Because I did tested
your
code using Office 97 - 2007 on Windows 98 - Vista Ultimate. And they works
great!

I don't know what cause the system on my computer cannot run the code.
Even
after I reformat my computer I still can't run the code.

Ok, now I've already diagnost the codes as you have advised me to do.
Please
examine the result below:-

If ID Then '<--------the "step into" cursor stop at this line.
Res = SHGetPathFromIDListA(ID, FolderName)
If Res Then
BrowseFolder = Left$(FolderName, InStr(FolderName, _
vbNullChar) - 1)
End If
End If '<---------then continue at this line

In addition, the message box displayed error as "0".

Thanks in advance,
Jaemun.








 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible problem with PMT and FV functions Keith Excel Worksheet Functions 2 March 13th 10 03:43 AM
Problem with Functions and Formulas Kris Excel Worksheet Functions 11 October 23rd 09 05:16 PM
Problem with functions working erajim New Users to Excel 2 January 5th 07 03:11 AM
formatting problem with functions Robin M. Excel Worksheet Functions 4 October 9th 05 04:49 AM
Problem using VBA functions.... Richard Latter New Users to Excel 3 February 28th 05 06:08 PM


All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"