View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Excel 2002 to 2003 problem

Tim,

The first thing I would check is whether there are any reference problem. Go
to the VBIDE (Alt-F11), and then menu ToolsReferences 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" wrote in
message ...

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