Solved

Farpoint Spread Formula in VB App

Posted on 2003-12-12
6
2,099 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
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This is about my first experience with programming Arduino.
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 …

820 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