Jump to content
Sign in to follow this  
lipster

Simulate TAB Key when Copying & Pasting multiple Values

Recommended Posts

lipster

Hi Everyone,

I have a longggg list of words in excel, 10,000 columns long. I need to copy/drag each word into a single text box/field in an external application and do that 10,000 times. Laborious!

Is there a way to simulate the TAB character between each word within excel (E.g. word1<TAB>word2<TAB>word3<TAB>) all in one cell of course, so that if I was to drag/copy this cell from excel and then drop/paste it into the first text box of the external application, the first box would contain word1, the second box word2 etc...

word1

word2

word3

Thanks in Advance,

Lipster

Share this post


Link to post
Share on other sites
monoceres

Hi and welcome to the forums.

Seems like you could do this much easier with the excel udf.

Take a look int help file under Excel Management in the UDF section.


Broken link? PM me and I'll send you the file!

Share this post


Link to post
Share on other sites
Juvigy

I guess you want to send the 10000 words with autoit with the external application? right?

It could be easily done. Just put each word from excel to array - _ExcelReadArray and then create a loop to send each word from the array to the external app and then send "tab" ...

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  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.