hi expert ,
below code take different execution time on Excel 2007 and Excel 2010
Excel2007 =20 Sec
Excel2010 =1 sec
can any one suggest what may be reason
Thanks
Regards,
Sub ImportXMLtoList(shtTemp As Worksheet, strTargetFile As String)
Dim wb As Workbook
shtTemp.UsedRange.Clear
Debug.Prin
Hi Hukam Chand,
PFA...!!!
Regards
Ashish
On 2 July 2014 17:36, Hukam Chand <
hukamchand0...@gmail.com> wrote:
> Can anybody help to me to the same as mentioned in subject line
>
> I am done with it but not able to do proper formatting.
>
> Thanks in advance..!!
>
>
> Regards-
> Hukam Chand
>
Dear Bé Trần Văn
Thanks very much for this & noe it open in excel 2003 version also work it.
But small issue that VBA code would be copy & paste in sheet module
for each column & change column numbers in code & attached button that
code every time.IF there are more than 30 cloumn then 30 times VB