shell sommand issues....

[GS7CLW]

My macro has this in it which works:
Dim RetVal
RetVal = Shell("I:\S3DATA~1\FLRCDR~1\FloorR~1.bat", 1)

My batch file has this in it which works:
ECHO OFF
C:
cd..
z: ' network mapped Sharepoint site
CD \Shared Documents
del FloorReport.xlsm
copy I:\S3DATA~1\FLRCDR~1\FloorReport.xlsm

I am trying to eliminate the need for a batch file; so, I have tried:
Dim RetVal
Dim RetVal = shell("DEL Z:\Shared Documents\2011Buckeye.xlsm")
Dim RetVal = shell("copy /Y I:\S3DATA~1\FLRCDR~1\2011Buckeye.xlsm Z:\Shared Documents\2011Buckeye.xlsm")

but VBA says "file not found" on the DEL line above.

ANY ideas appreciated!

Hope everyone had a great week end --
not sure I did -- spent it putting Windows 7 on my home PC - uuuuugghhhh

cliff

 

[John_w]

Try the VBA Kill and FileCopy statements instead.

 

[GS7CLW]

The rest of the week has got to be great -- MONDAY is over!!!


I have tried this:

KillFile = "Z:\Shared~1\FloorReport.xlsm"
Kill KillFile
FileCopy "I:\S3DATA~1\FLRCDR~1\FloorReport.xlsm", "Z:\Shared~1\FloorReport.xlsm"

but I believe the fact that Z: is a network (mapped) drive it will not work.
I get a file not found on the Kill Killfile line.