I am attempting to create a new instance of Excel from Access (also 2010)
I have a reference set to "Microsoft Excel 14.0 Object Library" in my project.
I am using the following lines to open a new instance of excel:
Dim oXL As Excel.Application
Set oXL = New Excel.Application
Excel never opens, I just get an error that the excel application has stopped working...
Please help, I have done this many times before and not had a problem