caspermurphy Posted December 4, 2003 Posted December 4, 2003 I am trying to copy a number files from a folder that is on a network shared drive and paste them on a user’s desktop. Everyone's desktop file location is different. C:\Documents and Settings\userid\Desktop Where the userid is different for everyone I have tried this: FileCopy, \\sdolco2\UI - EAAS\Excel Rating Worksheets\*.*, Current Users desktop path:,%USERPROFILE%\\Desktop, 1 Appears nothing happens when I try to run that. I did get the below to work. BUT it is possible for the user to have some of these files on their desktop already so it will ask them if they want to replace the existing files? How would I make it so they have to replace them? Send, {LWIN}r ;clear run window Send, {DEL} SetWinDelay, 10 Send, {\\ 2}sdolco2\\ui{SPACE}-{SPACE}e{a 2}s\\Excel{SPACE}Rating{SPACE}Worksheets Send, {ENTER} SetKeyDelay, 5000 ; wait fof folder window Send, {CTRLDOWN}a{CTRLUP} SetKeyDelay, 10 Send, {ALTDOWN}e{ALTUP} SetKeyDelay, 10 Send, f Send, {SHIFTDOWN}{TAB}{SHIFTUP}{UP}{ENTER} Exit Thank you in advance for any help. John
Dan Posted December 4, 2003 Posted December 4, 2003 Try this: FileCopy, \\\\sdolco2\\UI - EAAS\\Excel Rating Worksheets\\*.*, %USERPROFILE%\\Desktop\\*.*, 1
caspermurphy Posted December 5, 2003 Author Posted December 5, 2003 Dan, that workes just great. Thank you.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now