$$Excel-Macros$$ Re: Import an HTML table into Excel sheet

2009-05-29 Thread ankit agarwal
Hi, Please find the macro below.Modify column name as per your requirement and also change the webpage link from the link given : Sub TEST() Dim CUSIP As String Dim ISSUEDATE As String Dim CUSIP_y As Long Dim CUSIP_x As Byte Dim ISSUEDATE_x As Byte With ActiveSheet.QueryTabl

$$Excel-Macros$$ Re: Import an HTML table into Excel sheet

2009-05-28 Thread norie
Where exactly is this HTML file coming from? Is it an actual file or are you trying to get data from a webpage/ site? On May 27, 9:39 am, joker197cinque wrote: > I'm trying to import into a sheet an HTML table. > > The problem is that parsing html string is not so easy .. can you > advice me a