Re: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-11 Thread Vasant
Hi Shree, Apologies for the delay .. Pls let me know what kind of HTML file would you like to convert ? Could you pls send me those html files ? btw You can also use third party tools what Ankur has mentioned in his mail. On Mon, Jul 11, 2011 at 5:11 PM, SHREE wrote: > Thanks Vasant Its w

Re: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-11 Thread ankur
*hi shree see below link to convert html to excel may this help u http://www.mrkent.com/tools/converter/ http://www.designdetector.com/archives/05/07/HTMLToExcelTheEasyWay.php *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~

Re: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-11 Thread SHREE
Thanks Vasant Its working fine, Please can you also advise coding for only converting HTML file into Excel... On Jul 8, 2:16 pm, SHREE wrote: > Thanks Vasant Its working fine, Please can you also advise coding for > only converting HTML file into Excel... > > On Jul 6, 8:57 pm, Vasant wrote: >

RE: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-08 Thread Chidurala, Shrinivas
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> Subject: RE: $$Excel-Macros$$ Convert HTML file to Excel See if it Help. Sub Compile() On Error GoTo Err_Clear: Application.ScreenUpdating = False Application.DisplayAlerts = False Dim Fso As New Scripting.FileSystemObject Di

Re: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-08 Thread SHREE
Thanks Vasant Its working fine, Please can you also advise coding for only converting HTML file into Excel... On Jul 6, 8:57 pm, Vasant wrote: > Hi > > Pls find the code and the file attached. > The html files stored in the folder 'Folder' will be used for the report. > > Sub Test() > Dim Fs As N

RE: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-07 Thread Rajan_Verma
Please Remove that Line From the Code. It will work fine.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vasant Sent: Thursday, July 07, 2011 11:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert HTML file to Excel

Re: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-07 Thread Vasant
/ 6340 > Email - shrinivas.chidur...@citi.com > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Rajan_Verma > Sent: Thursday, July 07, 2011 1:23 AM > To: excel-macros@googlegroups.com > Subject: RE: $$

RE: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-07 Thread Chidurala, Shrinivas
Email - shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Thursday, July 07, 2011 1:23 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Convert HTML file to Excel

RE: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-06 Thread Rajan_Verma
al Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chidurala, Shrinivas Sent: Wednesday, July 06, 2011 5:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert HTML file to Excel Dear Excel Gurus, I have some HTML files

Re: $$Excel-Macros$$ Convert HTML file to Excel

2011-07-06 Thread Vasant
Hi Pls find the code and the file attached. The html files stored in the folder 'Folder' will be used for the report. Sub Test() Dim Fs As New FileSystemObject, Fl As File Dim Fld As Folder, FolderPath As String Dim WkBk As Workbook, DtWkBk As Workbook Set WkBk = Workbooks.Add NoShts = WkBk.Works

Re: $$Excel-Macros$$ Convert HTML file to Excel

2011-03-19 Thread ashish koul
-macros@googlegroups.com] *On Behalf Of *ashish koul > *Sent:* Saturday, March 19, 2011 2:21 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Convert HTML file to Excel > > can u send the sample file > > On Thu, Mar 17, 2011 at 3:20 PM, Chidurala, Shri

RE: $$Excel-Macros$$ Convert HTML file to Excel

2011-03-19 Thread Chidurala, Shrinivas
: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, March 19, 2011 2:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert HTML file to Excel can u send the sample file On Thu, Mar 17, 2011 at 3:20 PM, Chidurala

$$Excel-Macros$$ Convert HTML file to Excel

2011-03-19 Thread Chidurala, Shrinivas
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chidurala, Shrinivas [ICG-GTS] Sent: Thursday, March 17, 2011 3:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert HTML file to Excel Dear All, We received some HTML files from System and we save as

Re: $$Excel-Macros$$ Convert HTML file to Excel

2011-03-19 Thread ashish koul
can u send the sample file On Thu, Mar 17, 2011 at 3:20 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: > Dear All, > > We received some HTML files from System and we save as them in Excel file > and do some formatting. Can we do this activity of converting HTML file to > Excel by

$$Excel-Macros$$ Convert HTML file to Excel

2011-03-17 Thread Chidurala, Shrinivas
Dear All, We received some HTML files from System and we save as them in Excel file and do some formatting. Can we do this activity of converting HTML file to Excel by Macro. Please adive on the somes. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24