Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default MoveFile problems

Can anyone tell me what would be wrong with the following function?

I'm getting "Path not found."


fs.MoveFile "X:\Quotes 2004\" & Cust & " \ " & QuoteDir & "*.*",
"X:\Orders 2004\" & Cust & " \ " & OrderDir & "\"

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default MoveFile problems

Firstly, what's FS? An instance of a file system object?

You need to see what those paths are evaluating to. What if the
value of "Cust" is "kja9s0ej4509qj43p[ija;sofuasd." Debug.Print the
paths that you're using and verify they're correct.

'COMMENT OUT fs.MoveFile "X:\Quotes 2004\" & Cust & " \ " & QuoteDir
& "*.*", "X:\Orders 2004\" & Cust & " \ " & OrderDir & "\"


DEBUG.PRINT "X:\Quotes 2004\" & Cust & " \ " & QuoteDir & "*.*"
DEBUG.PRINT "X:\Orders 2004\" & Cust & " \ " & OrderDir & "\"

Ray at work

wrote in message
oups.com...
Can anyone tell me what would be wrong with the following function?

I'm getting "Path not found."


fs.MoveFile "X:\Quotes 2004\" & Cust & " \ " & QuoteDir & "*.*",
"X:\Orders 2004\" & Cust & " \ " & OrderDir & "\"



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
aauugghhh...#div/o problems & various average formula problems acbel40 Excel Worksheet Functions 5 October 19th 09 05:00 PM
Problems Kay Excel Worksheet Functions 2 May 22nd 09 02:37 AM
Problems merging an excel file due to code or file problems? Cindy M -WordMVP- Excel Programming 0 September 14th 04 02:58 PM
Problems with LN in VBA NooK[_34_] Excel Programming 1 July 2nd 04 02:19 PM
How to maintain the original date and time for the MoveFile command Wellie Excel Programming 0 March 3rd 04 03:33 AM


All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"