amazon web services - I want to parse the Total monthly payment value to a cell in Excel spreadsheet -
i working on analytical problem information amazon ec2 calculator needed.
i have spreadsheet perform criteria analysis , each iteration need specific cost of services provided aws.
my solution invokes, in user form, aws simple calculator, allowing user specify type of services use aws, pressing button, placed on same user form value of total monthly payment must parsed cell in main workbook. operation should repeated each of test scenarios.
please, vba capture value website , parse cell within workbook appreciated.
thanks,
morph.
p.s. here code use:
private ie object, obj object private row integer, cell integer, table integer private elemcollection object private sub userform_initialize() set ie = createobject("internetexplorer.application") ie me.webbrowser1.navigate "http://calculator.s3.amazonaws.com/index.html" thisworkbook.sheets("sheet3").range("a1:z1000").clearcontents end end sub private sub bm_importdata_click() set elemcollection = ie.document.getelementsbytagname("table") table = 0 (elemcollection.length - 1) row = 0 (elemcollection(table).rows.length - 1) cell = 0 (elemcollection(table).rows(row).cells.length - 1) thisworkbook.sheets("sheet3").cells(row + 1, cell + 1) = elemcollection(table).rows(row).cells(cell).innertext next cell next row next table set ie = nothing end sub
Comments
Post a Comment