ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MoveFile problems (https://www.excelbanter.com/excel-programming/319671-movefile-problems.html)

[email protected]

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 & "\"


Ray Costanzo [MVP]

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 & "\"





All times are GMT +1. The time now is 01:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com