Dear Muddan
What changes in file? Not working file as per my requirment
Regards
amar
On Fri, Apr 11, 2014 at 8:55 AM, Muddan Madhu wrote:
> find the attached file
>
>
> On Thursday, April 10, 2014 2:30:10 PM UTC+5:30, amar takale wrote:
>>
>> Dear Muddan
>>
>> Pls help me on this small issue.
Dear Sir
Thank very much...
Regards
Amar
On Wed, Apr 9, 2014 at 5:12 PM, Muddan Madhu wrote:
> replace
>
> For I = 0 To TbleID.Rows.Length - 1
> For X = 1 To 8
> ActiveSheet.Cells(I + 1, X).Value =
> TbleID.Rows(I).Cells(X).innertext
> Next X
> Next I
>
>
> you have
replace
For I = 0 To TbleID.Rows.Length - 1
For X = 1 To 8
ActiveSheet.Cells(I + 1, X).Value =
TbleID.Rows(I).Cells(X).innertext
Next X
Next I
you have to use shell control to work on selected data to populate
On Wednesday, April 9, 2014 10:39:05 AM UTC+5:30, amar takale wr
Dear Muddan
Thanks alot.its perfect.
Can we extract data with heading name & as per my selection cell point
where I select cell then data extract from that cell.
Regards
Amar
On Wed, Apr 9, 2014 at 8:17 AM, Muddan Madhu wrote:
> Try this
>
> Option Explicit
> Sub GetDataFromWeb()
> Dim STR As S
Try this
Option Explicit
Sub GetDataFromWeb()
Dim STR As String
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
STR = "http://www.investing.com/indices/major-indices";
Dim I As Integer, X As Integer
IE.Visible = True
IE.Navigate STR
While (IE.Busy Or IE.ReadyState <> 4)
Hi Mahesh,
First "expat" means "expatriate", a foreigner living and working
abroad... you probable mean "expert"...
It would be nice if you could append a couple of those text files and
the intended excel workbook, so we can see what you mean exactly...
Waiting to help you out, with kind regard
Hi,
Don't your Excel 2003 has Data->XML->Import. Check Again.
Regards
Sandeep
On Tue, Oct 6, 2009 at 5:57 PM, Manoj Kukrej wrote:
> Hi,
>
> I want to know how I can add xml in it
>
> I have checked in tools > commands>xml is also missing
>
> Regards
>
>
>
> Manoj
>
> -
