Dear Ashish/Basole,
Thanks for quick response; I really appreciate your efforts,
I think how to copy web page to excel ( I tried via “Get External data from
web” excel
option but unable to fetch ActiveX control)
Basically I want go to web page then select all value (using ctrl +a) then
pa
try this
Sub Loopobjects()
Dim OleObj As OLEObject
Dim sel_d, val_s
Dim Arr
Dim ArrMatch
Dim lngSelected As Long
For Each OleObj In Sheet1.OLEObjects
If OleObj.progID = "Forms.HTML:Text.1" Then
Sheets(1).Cells(OleObj.TopLeftCell.Row, 12) =
OleObj.Object.
See if that is what needs:
http://www.homeandlearn.co.uk/excel2007/excel2007s8p4.html
Em quarta-feira, 10 de julho de 2013 09h51min06s UTC-3, Santy escreveu:
>
> Hi,
>
> I need help urgently
>
> how to copy value from an object (i have copy objects from web page)
>
>
>
>
> Thanks in advance
>
Hi,
I need help urgently
how to copy value from an object (i have copy objects from web page)
Thanks in advance
--
Regards,
Santy
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www