Jump to content
Sign in to follow this  
VBA_User

How to get the file path, which is copied to clipboard?

Recommended Posts

How to get the file path from clipboard, which has been copied recently and then to put it in ControlSend "File Path"? 

In VBA, I will copy the cell value (File Path - D:\PGTemp\Upload Successful.txt) from excel then I will run the au script.

The Script that requires modification:

Sleep (5000)

ControlFocus ( "Open","","Edit1" )
ControlSend("Open","","Edit1", "D:\PGTemp\Upload Successful.txt")
ControlClick ("Open","","Button1")

image.png.fcbacd197de8d0d384cd0da777c75b95.png

Share this post


Link to post
Share on other sites

Thanks Guys, Problem Solved.

Local $sdata = ClipGet()
ControlFocus ( "Open","","Edit1" )
ControlSend("Open","","Edit1", $sdata)
ControlClick ("Open","","Button1")

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...