Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 to 2003 problem
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 -- GB_Roni ----------------------------------------------------------------------- GB_Ronin's Profile: http://www.excelforum.com/member.php...fo&userid=3014 View this thread: http://www.excelforum.com/showthread.php?threadid=51259 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 to 2003 problem
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 <news:<GB_Ronin.239o0n_1140000002.7489@excelforu m-nospam.com 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 to 2003 problem
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 -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |