Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002/2003 problem | Excel Discussion (Misc queries) | |||
HELP - Excel 2003 VERY SLOW vs 2002 | Excel Discussion (Misc queries) | |||
UNC Path length problem opening a file in excel 2002 or 2003 | Excel Discussion (Misc queries) | |||
How do i download excel 2002/2003 | Excel Programming | |||
compatibility between excel 2002 and 2003 | Excel Programming |