?
Solved

Farpoint Spread Formula in VB App

Posted on 2003-12-12
6
Medium Priority
?
2,240 Views
Last Modified: 2012-10-24
Hi,

I  need to write custom formula for spread in my application, but so far i have tried using only normal formulas even which arent working.

with vaSpread1
       .row = 1
       .col = 1
       .value = 1

       .row = 1
       .col = 2
       .value = 2

       .recalc = true
       .row = 1
       .col = 3
       .formula = "SUM(A1,B1)"
       
end with


But i dont find the value reflected in that cell when i run the code. Plez help.. this is urgent and its driving me nuts..

would have loved to assign lots of points but dont have that many.. so plez bear..

thanks in advance,
RS.
0
Comment
Question by:rekhasri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:Tommy Kinard
ID: 9930418
Hi rekhasri,

The below code should help

set vaSpread1 = ActiveWorkbook.Sheets("NameOfWorkSheet")
With vaSpread1
       .Cells(1, 1).Value = 1
       .Cells(1, 2).Value = 2
       .Cells(1, 3).Formula = "=SUM($A$1:$B$1)"
       .Calculate
End With

dragontooth

0
 
LVL 2

Author Comment

by:rekhasri
ID: 9939863
Hi dragontooth..

what is ActiveWorkBook? i want to avoid using excel here..

is there any way of simply using formulae in spread?

thanks,
RS.
0
 
LVL 14

Expert Comment

by:Tommy Kinard
ID: 9941693
Sorry misread the question, don't think I will be any help here.

dragontooth

0
 
LVL 2

Accepted Solution

by:
rekhasri earned 0 total points
ID: 9946992
hi folks,

i have decided to use excel here instead of  spread, and just populated it using ado..

there is something called.

CopyFromRecordset.. which was really cool..

so, there goes.. i think i will close this question.
0
 
LVL 14

Expert Comment

by:Tommy Kinard
ID: 9949394
rekhasri,

Go here to ask for this question to be deleted and your points refunded.

http://www.experts-exchange.com/Community_Support/

dragontooth
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question