I have a workbook called Steve Simons which I would like help building a macro that would help the agent fill out an online form. With this workbook, I would to have the ability to put in the date, the SP# & CID then if column H has a 1 in it (only the last row that has the 1 in column H), I want this script to run.
Public Sub OpenIE()
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.navigate "http://projects/PWA/ERP%20Project/Team%20Portal/Lists/New%20Triage/NewForm.aspx?RootFolder=%2FPWA%2FERP%20Project%2FTeam%20Portal%2FLists%2FNew%20Triage&Source=http%3A%2F%2Fprojects%2FPWA%2FERP%2520Project%2FTeam%2520Portal%2FLists%2FNew%2520Triage%2FAllItems%2Easpx"
This code opens an internal webpage which I would like for the information that is on the spreadsheet to relay over to that online form.
Status of Case = "Triage - OE"
Owning Business = "Kill / Rebook"
Status Date / Time Change = Current date & time
Status Changed By = "Steve Simons"
(The next 6 input fields would be blank"
Agent Reporting Issue = "Steve Simons"
Super User Reporting Issue = "Steve Simons"
Customer # = cell value of column C
Date Resolution Needed = Current date & Time
Number of Customer Calls = "1"
Then everything else can be blank.
For some reason I can not submit the HTML code to show you the code however I did add a picture of my site. Please send me a message if you are able to assist & I will be more than happy to send you the HTML code that has this webpage. I have attached the workbook for any assistance that you can provide along with the picture from the internal website to help understand what it looks like & your help is always greatly appreciated!
Bookmarks