What code do I need in VB6 to take numbers from boxes in my display and append them to the end of a excel sheet , i would like to do it once per day and have it just added onto the end, so that I can graph the data later.
Thanks
Export data to excel
Hot Topic
- Reload parent form
- Some Questions
- VB 2005 Express Beta 2 Install
- Debugging error - Operation Could not be completed
- Need help with saving URL Code
- ASPX Error message : Server Error in '/' Application.
- How to Read, Write, Modify & Remove Application Settings From Config File Using VB 2005?
- Using a Stored procedure to Update or insert
- ExplorerBar Control
- Troubles trying to create a window with the Win32 API
Visual Basic
- Help on Mod Code in VBA
- Reading and Comparing REG_BINARY
- A rebuilt VB.NET assembly DLL (deployment inquiry)
- Newbie Question
- passing events to different classes
- Remove items from My namespace
- Getting rid of the VB6 MAPI controls in .NET
- DataTable is not defined
- Populating per like statement
- Need Help with WebService
Export data to excel
tushka
Ryan,
you can create a CSV file (Comma delimited) and append your number in this file. Excel and open CSV file.
fahimaamir
Ryan,
from http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21195163.html
Write (appends data to an existing file):
Dim intFileHandle As Integer
Dim strRETP As String
strRETP = "Hi There"
intFileHandle = FreeFile
Open "path to file" For Append As #intFileHandle
Print #intFileHandle, "---------------------------"
Print #intFileHandle, strRETP
Print #intFileHandle, "---------------------------"
Close #intFileHandle
RamyaRamakrishnan