mohanakshi
13 years agoContributor
Install addins to Excel
Hi,
Upon opening Excel workbook "Microsoft Installer Window" should get open for installing Excel Com-addin. This is working fine manually. But when i ran the code below i could not see any installer window!. I want to know why it is so.. and what i can do for solving this issue as i have to install that addin for further testing operations.. Please help me.
Code is:
sub test()
set Excelobj=Sys.oleobject("excel.application")
objexcel.workbooks.open("C:\Documents and Settings\smohanakshi\My Documents\New Folder\New Microsoft Office Excel Worksheet.xlsx")
End Sub
(I am using Excel 2007 and windows xp sp3)
Upon opening Excel workbook "Microsoft Installer Window" should get open for installing Excel Com-addin. This is working fine manually. But when i ran the code below i could not see any installer window!. I want to know why it is so.. and what i can do for solving this issue as i have to install that addin for further testing operations.. Please help me.
Code is:
sub test()
set Excelobj=Sys.oleobject("excel.application")
objexcel.workbooks.open("C:\Documents and Settings\smohanakshi\My Documents\New Folder\New Microsoft Office Excel Worksheet.xlsx")
End Sub
(I am using Excel 2007 and windows xp sp3)