ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Exporting data from Excel into Internet Explorer (https://www.excelbanter.com/excel-programming/293200-exporting-data-excel-into-internet-explorer.html)

green78[_3_]

Exporting data from Excel into Internet Explorer
 
Hi

I asked this question before but there was no answer, so I afford t
ask it again as it becomes a very important issue to me :(.

In my work we're migrating to a new accounting system which is we
based (Flexcube). It looks like a web form (just like when you need t
enter your name, email, date of birth etc.). So I need to press TA
each time I want to jump to the next field.

My question is: I have some excel files with certain data. Is i
possible in some way that I can copy a range from Excel and by pastin
it on the first field in the web form the information to sprea
respectively on the next consecutive fields? i.e.

If we have: in the browser

Field 1: Name (by pressing TAB move to the next field)
Field 2: Age
Field 3: City

If I have the following information in Excel:

Cell A1 = "Andy Smith"
Cell A2 = "25"
Cell A3 = "Newcastle"

I want to copy the array A1:A3 and by pasting it on "Field 1" the res
of the information to spread automatically on fields 2 and 3. Is i
possible such a thing at all?

Thank you for your patience....

--
Message posted from http://www.ExcelForum.com


onedaywhen

Exporting data from Excel into Internet Explorer
 
You are thinking in terms of key strokes and mouse clicks rather than
their underlying processes. Perhaps this thread from the Usenet
archives will change your perspective:

http://groups.google.com/groups?thre...TNGP09.phx.gbl

--

green78 wrote in message ...
Hi

I asked this question before but there was no answer, so I afford to
ask it again as it becomes a very important issue to me :(.

In my work we're migrating to a new accounting system which is web
based (Flexcube). It looks like a web form (just like when you need to
enter your name, email, date of birth etc.). So I need to press TAB
each time I want to jump to the next field.

My question is: I have some excel files with certain data. Is it
possible in some way that I can copy a range from Excel and by pasting
it on the first field in the web form the information to spread
respectively on the next consecutive fields? i.e.

If we have: in the browser

Field 1: Name (by pressing TAB move to the next field)
Field 2: Age
Field 3: City

If I have the following information in Excel:

Cell A1 = "Andy Smith"
Cell A2 = "25"
Cell A3 = "Newcastle"

I want to copy the array A1:A3 and by pasting it on "Field 1" the rest
of the information to spread automatically on fields 2 and 3. Is it
possible such a thing at all?

Thank you for your patience.....


---
Message posted from http://www.ExcelForum.com/



All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com