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
I can help you to Convert a Table into HTML Format Visit here.. http://excelpoweruser.wordpress.com/2012/08/13/html-body-of-a-table/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of 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