Plug Excel Values into Web

I have an excel worksheet with a list of invoices and I am trying to write a macro that will load an Invoice into a text box on a website then click the Insert Button to move the invoice over to a list box....Seems pretty simple... My code runs but now invoices get entered.. essentially nothing happens...

I am using ie.Document.all.Item to refer to the items but since the object name is hidden I used the object ID Example:

Set CognosInvoiceInput = ie.Document.all.Item("PRMT_TB_N1F5BDC50x141933C8_NS_").Value = Invoice

Could this be wrong? If so what is the proper code I should use to set the value of an object field if I only have the object id?

Please Login or Register  to view this content.