View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
 
Posts: 459
Default 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/