Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
Dim htm As Object Dim IE As Object Dim Doc As Object Set IE = CreateObject("internetexplorer.application") IE.Visible = True IE.navigate "http://ec.europa.eu/environment/ets/exportEntry.do?form=transaction&destinationAccountHolder=&startDate=01%2F06%2F2009&destinationRegistry=-1&originatingAccountType=121&endDate=01%2F05%2F2010&transactionID=&suppTransactionType=-1&originatingAccountHolder=&transactionType=-1&languageCode=en&destinationAccountNumber=&destinationAccountType=121&toCompletionDate=&originatingRegistry=-1&destinationAccountIdentifier=&fromCompletionDate=&originatingAccountIdentifier=&transactionStatus=4&originatingAccountNumber=1973¤tSortSettings=" Do While IE.readystate <> 4: DoEvents: Loop Set Doc = CreateObject("htmlfile") Set Doc = IE.document Doc.getelementbyID("btnOK").Click[embed=file 884739] 'I need code here which clicks the save as button as save the file as C:\temp.xml Set IE = Nothing
|In Excel 2007, how do I need to correct this ampersand formula so it works?||2||16|
|Is there any risk my Excel 2007 workbook is corrupted when it suddenly begins being saved as xlsx when always earlier always being saved as xlsm?||2||18|
|Access db, trying to list the results of query (in a recordset) in a list box using VBA||4||21|
|Find missing excel values from Column A and B||4||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!