Excel 2002 to 2003 problem

[GB_Ronin]

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

 

[Bob Phillips]

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]

Hi Bob,

Thanks for your time.

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

I then checked to see if I had anything selected in my version tha
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 o
there too !!

Ti

 

[keepITcool]

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.dicks-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

 

[GB_Ronin]

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