hi,
I have created an excel application as an object and excel sheet as an object.
Dim excel_app As Object
Dim excel_sheet As Object
and i am opening the sheet and inserting data. So i got to do two applications in excel through vba. So please help me in this regard.
1. How can i add an hyperlink to an excel cell through vba. (I have inserted some data into excel cell, for which i have to add an hyperlink to that cell).
2. How can i fill color in excel cells through vba. I have used the below code to fill color, but i am getting an error saying, this property will not be supported.
excel_sheet.Range(excel_sheet.cells(2, 1), excel_sheet.cells(2, 4)).Select
excel_app.excel_sheet.selection.Interior.ColorIndex = xlAutomatic
So please send me the code for the above questions and also please send a link, where i can found the code for various other applications(excel through vba).
thanks & regards,
Vinodh kumar
I have created an excel application as an object and excel sheet as an object.
Dim excel_app As Object
Dim excel_sheet As Object
and i am opening the sheet and inserting data. So i got to do two applications in excel through vba. So please help me in this regard.
1. How can i add an hyperlink to an excel cell through vba. (I have inserted some data into excel cell, for which i have to add an hyperlink to that cell).
2. How can i fill color in excel cells through vba. I have used the below code to fill color, but i am getting an error saying, this property will not be supported.
excel_sheet.Range(excel_sheet.cells(2, 1), excel_sheet.cells(2, 4)).Select
excel_app.excel_sheet.selection.Interior.ColorIndex = xlAutomatic
So please send me the code for the above questions and also please send a link, where i can found the code for various other applications(excel through vba).
thanks & regards,
Vinodh kumar