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 chidurala.sh...@gmail.com wrote: Thanks Vasant Its working fine, Please can you also advise coding for only converting HTML file into Excel... On Jul 6, 8:57 

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 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 chidurala.sh...@gmail.com

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 vasant...@gmail.com 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()

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

2011-07-08 Thread Chidurala, Shrinivas
@googlegroups.commailto: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 Dim Path As String

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-07 Thread Vasant
-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 See if it Help. Sub Compile

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-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 =

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

2011-07-06 Thread Rajan_Verma
Subject: $$Excel-Macros$$ Convert HTML file to Excel Dear Excel Gurus, I have some HTML files which are saved in same folder and I want to convert them into Excel and merger the all files into 1 workbook. Please help me to create the macro for the same. Find attached 2 HTML files and required

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-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

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

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

2011-03-19 Thread ashish koul
, 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, Shrinivas shrinivas.chidur...@citi.com wrote: Dear All, We received some HTML files from System and we save

$$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, #