Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Formula

Status
Not open for further replies.
shavon

shavon

Programmer
Jun 18, 2001
102
CA
How do i insert a formula into an Excel spreadsheet from VB6 please?

Thank you
 
Sort by date Sort by votes
well if you're referencing the excel spreadsheet through the excel object library....

i.e.
Code: 
Dim oExcel As New Excel.Application

Then all you need to do is set the cell's contents to the formula.

Code: 
oExcel.Range("A1") = "=SUM(A1:A35)"


Hope that helps! :)
--NiPSMG
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
244
Swi
Swi
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
559
strongm
strongm
Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
872
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
217
Niki_S
Niki_S
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
357
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top