Click here to Skip to main content
15,929,430 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Publish OR install project Pin
Paul Conrad23-Nov-07 14:17
professionalPaul Conrad23-Nov-07 14:17 
QuestionWriting a Plugin With Dependencies Pin
TheFarsider23-Nov-07 2:48
TheFarsider23-Nov-07 2:48 
QuestionCalling Windows App from command line prompt? Pin
barney_197223-Nov-07 2:15
barney_197223-Nov-07 2:15 
AnswerRe: Calling Windows App from command line prompt? Pin
Dave Kreskowiak23-Nov-07 4:55
mveDave Kreskowiak23-Nov-07 4:55 
GeneralRe: Calling Windows App from command line prompt? Pin
barney_197223-Nov-07 5:48
barney_197223-Nov-07 5:48 
GeneralRe: Calling Windows App from command line prompt? Pin
Dave Kreskowiak23-Nov-07 6:39
mveDave Kreskowiak23-Nov-07 6:39 
QuestionProblems in implementing WebBrowser control Pin
Abhishek Joshi23-Nov-07 2:04
Abhishek Joshi23-Nov-07 2:04 
QuestionDynamically build excel worksheet with VSTO2005 problem Pin
epetri23-Nov-07 0:56
epetri23-Nov-07 0:56 
Hi,

First code clears worksheet from previous data and excel formulas. Then retrieves data from database to excelworksheet. So far so good.

To reduse calculation from excel formulas. The formulas are created after database retreaval. Due the nature of dynamic. I can't create formulas before data is retrieved because data is not static nor goes to known place.

Excel SUM-formulas goes nice, but when inserting IF-formula exceptions begin.

Globals.Sheet3.Cells(10, 10).Value = "=IF(B28=""X"";C8/C29*D29;(B8+1)*C8)"
or
Globals.Sheet3.Cells(10, 10).Formula = "=IF(B28=""X"";C8/C29*D29;(B8+1)*C8)"

Above statement produce underlying error message.

A first chance exception of type 'System.Runtime.InteropServices.COMException' occurred in Microsoft.VisualBasic.dll

I think this is some kind of bug, but does enybody know a way to go around it?

Actually Cells(10, 10) and B28, C8 and D29 values are from variables that are calculated from data. I tried to insert any If formula to excel using VSTO2005 but result was same exception.




Pete

AnswerRe: Dynamically build excel worksheet with VSTO2005 problem Pin
Dave Kreskowiak23-Nov-07 4:50
mveDave Kreskowiak23-Nov-07 4:50 
GeneralRe: Dynamically build excel worksheet with VSTO2005 problem Pin
epetri23-Nov-07 9:04
epetri23-Nov-07 9:04 
QuestionRichTextBox Lines(0) Remove does not work Pin
ESTAN22-Nov-07 22:52
ESTAN22-Nov-07 22:52 
AnswerRe: RichTextBox Lines(0) Remove does not work Pin
Luc Pattyn23-Nov-07 1:30
sitebuilderLuc Pattyn23-Nov-07 1:30 
QuestionProblem in Integer array in VB.net Pin
kokilaB22-Nov-07 22:46
kokilaB22-Nov-07 22:46 
AnswerRe: Problem in Integer array in VB.net Pin
SHatchard22-Nov-07 23:32
SHatchard22-Nov-07 23:32 
AnswerRe: Problem in Integer array in VB.net Pin
Dave Kreskowiak23-Nov-07 4:46
mveDave Kreskowiak23-Nov-07 4:46 
QuestionObject reference not set to an instance of an object.+ Sourabh Pin
Dot Net Jantu22-Nov-07 22:03
Dot Net Jantu22-Nov-07 22:03 
AnswerRe: Object reference not set to an instance of an object.+ Sourabh Pin
Mustafa Ismail Mustafa23-Nov-07 0:09
Mustafa Ismail Mustafa23-Nov-07 0:09 
AnswerRe: Object reference not set to an instance of an object.+ Sourabh Pin
Dave Kreskowiak23-Nov-07 4:37
mveDave Kreskowiak23-Nov-07 4:37 
Questionhow to get the DateTime value of a remote mahine Pin
georgegarvasis22-Nov-07 21:07
georgegarvasis22-Nov-07 21:07 
AnswerRe: how to get the DateTime value of a remote mahine Pin
epetri23-Nov-07 3:43
epetri23-Nov-07 3:43 
Questionan unhandled exception of type 'System.ExecutionEngineException' occured in crdb_adoplus.dll Pin
jhyn22-Nov-07 20:23
jhyn22-Nov-07 20:23 
AnswerRe: an unhandled exception of type 'System.ExecutionEngineException' occured in crdb_adoplus.dll Pin
Dave Kreskowiak23-Nov-07 4:33
mveDave Kreskowiak23-Nov-07 4:33 
QuestionHow to open a word file from a web site folder? Pin
arslanjatt22-Nov-07 20:05
arslanjatt22-Nov-07 20:05 
AnswerRe: How to open a word file from a web site folder? Pin
Vasudevan Deepak Kumar23-Nov-07 1:51
Vasudevan Deepak Kumar23-Nov-07 1:51 
Questionhow to trace the control key in datagridview Pin
eyes200722-Nov-07 19:25
eyes200722-Nov-07 19:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.