Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.windows.inetexplorer.ie6.browser,microsoft.public.excel.misc,microsoft.public.internetexplorer.general,microsoft.public.access.macros
|
|||
|
|||
![]()
Running XP Pro, 3ghz machine, 512 ram.
At work I get this Excel spreadsheet sent to me with plain text values in it. Each row has maybe 25 values in it, each of which must be pasted into a form field in IE 6, submitted, then I start pasting from the next excel row into a new form. This form has your regular text fields, a few checkboxes, one radio button, and a few drop-down selectors, (such as choosing a U.S. state). What macro application would be best suited for automating this, after "teaching" it the exact keystrokes with the first row of data? Then I imagine I would let the macro rip on all the subsequent rows? All I do is use ctrl-c, ctrl-v, alt-tab to get between apps, the spacebar to select checkboxes, and the Left-Right arrow keys to select the radio button. I also use the first letter of the state to get within key repeat range of the U.S state I want in a dropdown, and sometimes use the up-down arrow keys for that. Been doing this by hand for awhile, but have been too busy to explore an automated solution. Thanks for all your input! Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Odd error - "This operation requires merged cells..." | New Users to Excel | |||
Using a Cell Operation for insertion into a Formula | Excel Discussion (Misc queries) | |||
i forget my Microsoft Excel files password tell me the solution | Excel Worksheet Functions | |||
Show trial solution | Excel Worksheet Functions | |||
Generating excel combinations | Excel Discussion (Misc queries) |