|
-
Nov 5th, 2010, 09:29 AM
#1
Thread Starter
Addicted Member
[RESOLVED] something wrong with Excel
I have been using Excel in vb.net for years and no problem but I have a new app and nothing is working. First I can't get Microsoft.office.interop referenced anywhere, which was weird.
Then I can't instantiate Excel App..
Dim pExcel_App as New Excel.Application -- this gives me error "New cannot be used on an interface??
But I can do this..
Dim pExcel_App As New Excel._ExcelApplication -- where did this come from?
Then I can't put anything into cells
Dim wkbSheet As Excel.Worksheet
wkbSheet.Cells(1,1) = "Title" --- this give me an error "Expression is a value and therefore cannot be the target of an assignment"
THe really weird thing is that I have an old app open at the same time that is just fine with all this code. AND the intellisense is different for each cell.
The good one sets is as a range, the bad one says it is an object???
I re-installed the MS PIA's but this didn't help.
I am totally stuck here??????
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|