Question xlApp = GetObject line error

Herry Markowitz

Well-known member
Joined
Oct 22, 2015
Messages
46
Programming Experience
1-3
1.Ended all EXCEL.EXE processes from Windows Task Manager
2.
Run following code.
VB.NET:
[COLOR=#303336][FONT=Consolas]Process[/FONT][/COLOR][COLOR=#303336][FONT=Consolas].[/FONT][/COLOR][COLOR=#303336][FONT=Consolas]Start[/FONT][/COLOR][COLOR=#303336][FONT=Consolas]([/FONT][/COLOR][COLOR=#7D2727][FONT=Consolas]"Excel.exe"[/FONT][/COLOR][COLOR=#303336][FONT=Consolas],[/FONT][/COLOR][COLOR=#7D2727][FONT=Consolas]"/embedded ""C:\Book1.xlsx"""[/FONT][/COLOR][COLOR=#303336][FONT=Consolas])[/FONT][/COLOR]
[COLOR=#303336]Threading[/COLOR][COLOR=#303336].[/COLOR][COLOR=#303336]Thread[/COLOR][COLOR=#303336].[/COLOR][COLOR=#303336]Sleep[/COLOR][COLOR=#303336]([/COLOR][COLOR=#7D2727]5000[/COLOR][COLOR=#303336])[/COLOR][COLOR=#303336]
[/COLOR][COLOR=#101094]Dim[/COLOR][COLOR=#303336] xlApp [/COLOR][COLOR=#101094]As[/COLOR][COLOR=#303336] Excel[/COLOR][COLOR=#303336].[/COLOR][COLOR=#303336]Application [/COLOR][COLOR=#303336]=[/COLOR][COLOR=#7D2727]Nothing
[/COLOR][COLOR=#303336][FONT=Consolas]xlApp [/FONT][/COLOR][COLOR=#303336][FONT=Consolas]=[/FONT][/COLOR][COLOR=#101094][FONT=Consolas]CType[/FONT][/COLOR][COLOR=#303336][FONT=Consolas]([/FONT][/COLOR][COLOR=#303336][FONT=Consolas]GetObject[/FONT][/COLOR][COLOR=#303336][FONT=Consolas]([/FONT][/COLOR][COLOR=#7D2727][FONT=Consolas]"Excel.Application"[/FONT][/COLOR][COLOR=#303336][FONT=Consolas]),[/FONT][/COLOR][COLOR=#303336][FONT=Consolas] Excel[/FONT][/COLOR][COLOR=#303336][FONT=Consolas].[/FONT][/COLOR][COLOR=#303336][FONT=Consolas]Application[/FONT][/COLOR][COLOR=#303336][FONT=Consolas])[/FONT][/COLOR]

3.
See following error.
VB.NET:
[COLOR=#303336][FONT=Consolas]Cannot create ActiveX component [/FONT][/COLOR]


Any idea?
Supported links:
https://support.microsoft.com/en-us/kb/291288
https://support.office.com/en-us/ar...=en-US&rs=en-US&ad=US&ocmsassetID=HA102919739
 
Back
Top