How to do the folliowing copying fast?

[cyberdude]

Hi,

I need to copy three values on an Excel spreadsheet to three boxes
separately of a dialogue box generated by an external program which is
believed written in Visual Basic. I have to do that copying many
times. May I ask how to do it quickly? I have tried to automate it
by Macro but I didn't succeed. I'll be glad if anybody can give me
the solution. Thanks

David

 

[Bob Phillips]

David,

If the dialog supports writing to those textboxes, it should be documented
as to how, if it doesn't, you have a problem (although you might be able to
do it with Sendkeys).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)