- 0
Excel from VB Question
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Similar Content
-
- 5 answers
- 5,682 views
-
excel 2007 Excel 2007 Conditional Formatting Help
By cbrookhart,
- 2 answers
- 1,097 views
-
- 1 answer
- 8,936 views
-
- 2 answers
- 8,842 views
-
- 9 answers
- 9,512 views
-
Question
crashbeta
HI all ,
I've been working on this for a while now and Obviously i'm probably missing something really easy ,
i'm trying to get data to goto excel from my VB 6 app , now the requirements i want my program to perform are
i do not want to see excel open i just want my app to write to the excel file in C:\Data\excel-data.xls
if i re-run my app i do not want it to tell me that it already Exists, Just write to the excel file and save it to the same location by same filename C:\Data\excel-data.xls
each day my app runs it puts data on separate rows by the day of the month " already have this done"
here is my simple VB code to write to excel, if anyone can help me out would be great !!
'Here is the Simple Program from Me
'To Send the Data from Vb To Microsoft Excel
Dim BangXl As Excel.Application
Private Sub Command1_Click()
BangXl.Workbooks.Add
BangXl.Range(Text1.Text).Value = Text2.Text
BangXl.Visible = True
End Sub
Private Sub Form_Load()
Set BangXl = CreateObject("excel.application")
End Sub
Private Sub Form_Unload(Cancel As Integer)
BangXl.Quit
End Sub
Link to comment
Share on other sites
1 answer to this question
Recommended Posts