View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GB_Ronin GB_Ronin is offline
external usenet poster
 
Posts: 1
Default 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


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