LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.windows.inetexplorer.ie6.browser,microsoft.public.excel.misc,microsoft.public.internetexplorer.general,microsoft.public.access.macros
external usenet poster
 
Posts: 1
Default Is this a "macroable" operation? What's the best solution?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd error - "This operation requires merged cells..." Maury Markowitz New Users to Excel 3 September 14th 06 01:54 AM
Using a Cell Operation for insertion into a Formula JCary Excel Discussion (Misc queries) 1 March 4th 06 12:22 AM
i forget my Microsoft Excel files password tell me the solution danish Excel Worksheet Functions 1 November 28th 05 02:13 PM
Show trial solution lui78 Excel Worksheet Functions 1 November 16th 05 10:35 AM
Generating excel combinations mark4006 Excel Discussion (Misc queries) 2 March 6th 05 04:40 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"