Sign in to follow this  
Followers 0
caspermurphy

copying files

3 posts in this topic

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

Share this post


Link to post
Share on other sites



Try this:

FileCopy, \\\\sdolco2\\UI - EAAS\\Excel Rating Worksheets\\*.*, %USERPROFILE%\\Desktop\\*.*, 1

Share this post


Link to post
Share on other sites

Dan, that workes just great.

Thank you. :whistle:

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0