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

Popular posts from this blog

javascript - oscilloscope of speaker input stops rendering after a few seconds -

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -