Extracting Data From Microsoft Excel

[JMichaelTX]

@jayknowstheway

I would like to save the entire cell contents for every row to a variable, and use those variables to fill out a web form.

Did you review the solution I provided in the original thread:

How Do I Copy and Paste from Excel to Website?

Here is a largely UN-TESTED Macro that should provide an example of how this might be done. You MUST make several changes BEFORE running this macro. See below. MACRO: Use Excel to Fill Google (or Safari) Form Fields [Example] DOWNLOAD: Use Excel to Fill Google (or Safari) Form Fields [Example].kmmacros (8.8 KB) DESIGNED FOR GOOGLE CHROME -- WORKS WITH SAFARI This macro uses KM Actions Google Chrome Form Fields, but should work fine if you just replase the actions with the corresponding …

This looks very similar to your requirements. Of course you may need to edit the macro to fit your specific needs.

Questions?