Cetin
This code always puts the paste into worsheet1 - fantastic
this._webBrowser41.Navigate2('file://j:\global\mertest.xls')
*Once you do this you've access to excel's object model too. ie:
oXLS = thisform._webbrowser41.object.document
oExcel = oXLS.Application
*oExcel.Application.ActiveWorkbook.Save()
lcTempFile = sys(2015)+".txt"
copy to (lcTempFile) delimited with TAB
_cliptext = filetostr(lcTempFile)
erase (lcTempFile)
oExcel.ActiveWorkBook.ActiveSheet.Range("g8:g19").PasteSpecial()
_Cliptext = "" && Empty clipboard
oExcel.Application.ActiveWorkbook.Save()
How do I make the active worksheet worksheet 2 (its name is LON Per)?
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing