ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is there a way to have an Excel Macro fill out a IE web form repeatedly? (https://www.excelbanter.com/excel-programming/358909-there-way-have-excel-macro-fill-out-ie-web-form-repeatedly.html)

ishiwata

Is there a way to have an Excel Macro fill out a IE web form repeatedly?
 

I'm trying to upload several hundred invoices onto an online billing
system. I'd like to figure out a way to do this automatically. The
website uses JavaScript, but can only load one file at a time. I've got
a spreadsheet with a list of all of our invoices - full paths to each
local file. I've figured out how to make Excel open up the browser,
but I have no idea how to make it fill out the form and submit it over
and over. Any suggestions? I've never programmed vba before but have
a little experience with perl and c. Is this something a beginner can
figure out or is it out of my league?

Thanks.


--
ishiwata
------------------------------------------------------------------------
ishiwata's Profile: http://www.excelforum.com/member.php...o&userid=33504
View this thread: http://www.excelforum.com/showthread...hreadid=532994


brettdj[_6_]

Is there a way to have an Excel Macro fill out a IE web form repea
 
Its doable

There is a useful thread on filling an IE form via VBA at
http://www.vbaexpress.com/forum/showthread.php?t=5978

Cheers

Dave


All times are GMT +1. The time now is 12:17 AM.

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