caspermurphy Posted December 4, 2003 Share 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 Link to comment Share on other sites More sharing options...
Dan Posted December 4, 2003 Share Posted December 4, 2003 Try this: FileCopy, \\\\sdolco2\\UI - EAAS\\Excel Rating Worksheets\\*.*, %USERPROFILE%\\Desktop\\*.*, 1 Link to comment Share on other sites More sharing options...
caspermurphy Posted December 5, 2003 Author Share Posted December 5, 2003 Dan, that workes just great. Thank you. Link to comment Share on other sites More sharing options...
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