Re: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

2012-10-18 Thread Vignesh S R
hi All, I have generated the html and saved in D:\user\test\tst_1.html Again i am using one macro to attach that file in mail, but cant able to attach the html file in mail.without attachment the mail program is working fine. kindly do the needful. On Wed, Oct 17, 2012 at 3:00 PM, Vignesh S R wr

Re: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

2012-10-17 Thread Vignesh S R
Hi All,, Thanks for the timely help.. Regards, Vignesh.S.R -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

RE: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

2012-10-16 Thread Rajan_Verma
R Sent: 15 October 2012 10:48 To: excel-macros Subject: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro hi, Anybody can help how to create the Excel macro for creation of HTML page. Sample html file like " This is my First HTML PAGE USING EXCEL MACRO" -- Vignesh .S.R

Re: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

2012-10-15 Thread Vignesh S R
HI ayush, Thanks its working but I need to like tables ,say 5x5 table size,can you please help me in this.! On Monday, October 15, 2012, Ayush Jain wrote: > Hey Vignesh > > This can simply be achieved by saving the excel file as html file by VBA code. > > Here is the code reference. > Activework

Re: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

2012-10-15 Thread Ayush Jain
Hey Vignesh This can simply be achieved by saving the excel file as html file by VBA code. Here is the code reference. Activeworkbook.Sheets(1).range("A1").value = "This is my First HTML PAGE USING EXCEL MACRO" Activeworkbook.saveas "C:\Scripts\Test.htm", xlHTML Hope it helps. Let us know if yo

$$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

2012-10-15 Thread Vignesh S R
hi, Anybody can help how to create the Excel macro for creation of HTML page. Sample html file like " This is my First HTML PAGE USING EXCEL MACRO" -- Vignesh .S.R -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED f