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 Chriss Miller 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
Joined
Jun 18, 2001
Messages
102
Location
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 Question
Read Excel Sharepoint File
Replies
0
Views
390
Swi
Swi
Niki_S
  • Locked
  • Question Question
How to read an excel file using VB 6?
Replies
17
Views
1K
strongm
strongm
Niki_S
  • Locked
  • Question Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
2K
strongm
strongm
Niki_S
  • Locked
  • Question Question
How to read excel with a gap in vb 6?
Replies
2
Views
440
Niki_S
Niki_S
Niki_S
  • Locked
  • Question Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
749
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top