Excel 2002 to 2003 problem

Hi,

Sorry about the mulitple posts....I got an error message when I tried posting before....also the others seem to be empty.....still for the third time:

I have a macro installed on a user's PC in Germany that was working on an Excel 2002 platform with no problems.

The PC has been replaced, now the user has Excel 2003 and the marco no longer works.

The office SP1 has been applied.

The macro lines that seems to be causing problems are :

Path_ = ThisWorkbook.Path
ChDir Path_
x = 0
y = 0

File_ = Dir("N*")
Do Until File_ = Empty

other stuff done here.....

File_ = Dir
Loop

The variant File_ is coming back empty now so the loop is not happening; I've checked and the files are indeed in the folder.

I'd look at the Excel help but unfortunately my Excel is still 2002 and the user's Excel is in German (and I have enough problems with English )

Any ideas that shed a bit of light on this would be greatly appreciated.

Many thanks,

Tim

Tim,

The first thing I would check is whether there are any reference problem. Go
to the VBIDE (Alt-F11), and then menu Tools>References and see if any items
are preceded by MISSING. If so, uncheck them.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GB_Ronin" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> Sorry about the mulitple posts....I got an error message when I tried
> posting before....also the others seem to be empty.....still for the
> third time:
>
> I have a macro installed on a user's PC in Germany that was working on
> an Excel 2002 platform with no problems.
>
> The PC has been replaced, now the user has Excel 2003 and the marco no
> longer works.
>
> The office SP1 has been applied.
>
> The macro lines that seems to be causing problems are :
>
> Path_ = ThisWorkbook.Path
> ChDir Path_
> x = 0
> y = 0
>
> File_ = Dir("N*")
> Do Until File_ = Empty
>
> other stuff done here.....
>
> File_ = Dir
> Loop
>
> The variant File_ is coming back empty now so the loop is not
> happening; I've checked and the files are indeed in the folder.
>
> I'd look at the Excel help but unfortunately my Excel is still 2002 and
> the user's Excel is in German (and I have enough problems with English
> )
>
> Any ideas that shed a bit of light on this would be greatly
> appreciated.
>
> Many thanks,
>
> Tim
>
>
> --
> GB_Ronin
> ------------------------------------------------------------------------
> GB_Ronin's Profile:
http://www.excelforum.com/member.php...o&userid=30146
> View this thread: http://www.excelforum.com/showthread...hreadid=512597
>

Hi Bob,

Thanks for your time.

I tried your suggestion but there was nothing that was selected in the references with the mention "missing" preceeding it. In fact nothing at all seemed to be missing.

I then checked to see if I had anything selected in my version that wasn't selected on the user's version, no luck there either I'm afraid.

I've just tried hunting on Microsoft's site and found this post on there too !!

Tim

since the user changed PC's..

what's being returned by path_ on the client's PC?
(the DRIVE is most important..

is it a Mapped network or local drive?
as chdir will not work with UNC paths
see http://www.*****-blog.com/archives/2005/08/30/
changing-the-current-directory

for an alternative.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


GB_Ronin wrote in
<news:<[email protected]>

>
> Hi Bob,
>
> Thanks for your time.
>
> I tried your suggestion but there was nothing that was selected in the
> references with the mention "missing" preceeding it. In fact nothing
> at all seemed to be missing.
>
> I then checked to see if I had anything selected in my version that
> wasn't selected on the user's version, no luck there either I'm
> afraid.
>
>
> I've just tried hunting on Microsoft's site and found this post on
> there too !!
>
> Tim

Many thanks for your input, sorry I'm a bit late in replying but 101 things to do and the damned user has gone home until Friday now so I'll have to wait to try this.

Just a question though, I did notice this morning that although this was a network drive:

Path_ = ThisWorkBook.Path

did retrive the correct folder path with the correct drive, so even with this you're saying that the :

ChDir Path_

won't work? Sorry to repeat the question but I'm quick at understanding if something is explained very sloooowly...

Thanks again,

Tim