Transpose data in an automatic way

Asked

Viewed 115 times

0

I have the following problem, I need to create a "robot" that reads the data of a given cell in Excel and enter this data in another software (own software of the company in which I work), but it has to "type" exactly the data that was read from this cell in this SW, taking into account that this company program does not accept that data be pasted into it. I already have something in vba where I can position the mouse exactly in the place I need in this software and send a click for the data to be inserted in the software, the problem is because of "enter" the data read in the spreadsheet in Excel inside it (also respecting spaces), there is some way to do this?

excel vba

  • I don’t remember native forms of VBA to interact with other non-Windows software. Unless the company software is programmed in VBA... or maybe some other Windows programming. What I suggest is the use of other software 3rd party... One of them is the Autoit, which can be used in VBA, where an example of how to declare can also be seen here.

  • Thank you Daniel, I will check this alternative!

1 answer

0

Good afternoon. To "type" you must use the Sendkeys Instruction. This instruction only works with string variables.

The code would look like this:

Dim strvar as string
strvar=cells(1,1).value
(sua macro para clicar no campo certo)
SendKeys strvar

Browser other questions tagged excel vba

You are not signed in. Login or sign up in order to post.