Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Problems | Excel Worksheet Functions | |||
Problems merging an excel file due to code or file problems? | Excel Programming | |||
Problems with LN in VBA | Excel Programming | |||
How to maintain the original date and time for the MoveFile command | Excel Programming |