Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appeding user data to the end of excel file
Hi friends,
I wrote a macro such that it will append some data at the end of th excel file(I opened the file in binary mode and wrote the content) The sample code will be like this Open filename For Binary Access Write As #1 If startpos = 0 Then startpos = LOF(1) End If Put #1, startpos, "my data" Close #1 After closing the file and opening it in Notepad the data is stil there. But if i reopened it in excel and closed the file, the data is gone. Excel overwrites the user defined data. Assist me in keeping my data persistent so that i will retrieve th contents and process it -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appeding user data to the end of excel file
You can't just write to Excel files using VBA's file write
procedures. Excel files are internally extremely complicated, and VBA doesn't support the data types required to manipulate them directly. You should use Excel itself to modify Excel files. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bharathi mohan " wrote in message ... Hi friends, I wrote a macro such that it will append some data at the end of the excel file(I opened the file in binary mode and wrote the content) The sample code will be like this Open filename For Binary Access Write As #1 If startpos = 0 Then startpos = LOF(1) End If Put #1, startpos, "my data" Close #1 After closing the file and opening it in Notepad the data is still there. But if i reopened it in excel and closed the file, the data is gone. Excel overwrites the user defined data. Assist me in keeping my data persistent so that i will retrieve the contents and process it. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appeding user data to the end of excel file
Some references:
http://support.microsoft.com/?id=253338 INFO: Office Developer Samples and Tools Available for Download http://support.microsoft.com/?id=260410 OFF2000: Microsoft Office 2000 Automation Help File Available -- Regards, Tom Ogilvy "Chip Pearson" wrote in message ... You can't just write to Excel files using VBA's file write procedures. Excel files are internally extremely complicated, and VBA doesn't support the data types required to manipulate them directly. You should use Excel itself to modify Excel files. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bharathi mohan " wrote in message ... Hi friends, I wrote a macro such that it will append some data at the end of the excel file(I opened the file in binary mode and wrote the content) The sample code will be like this Open filename For Binary Access Write As #1 If startpos = 0 Then startpos = LOF(1) End If Put #1, startpos, "my data" Close #1 After closing the file and opening it in Notepad the data is still there. But if i reopened it in excel and closed the file, the data is gone. Excel overwrites the user defined data. Assist me in keeping my data persistent so that i will retrieve the contents and process it. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appeding user data to the end of excel file
"Chip Pearson" wrote ...
You can't just write to Excel files using VBA's file write procedures. Excel files are internally extremely complicated, and VBA doesn't support the data types required to manipulate them directly. You should use Excel itself to modify Excel files. Another option is to use the Microsoft OLDB Provider for Jet i.e. ADO and SQL to write data to an Excel file. Using SQL's INSERT INTO syntax will append the new row to the bottom of the Excel range. Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing Excel file for multiple user | Excel Discussion (Misc queries) | |||
Multiple user excel file | New Users to Excel | |||
macro to save as a data input by user file name from a designated | Excel Discussion (Misc queries) | |||
Need to Query Excel File Opened by Another User | Excel Discussion (Misc queries) | |||
Excel allows access to more than one user to same file | Excel Discussion (Misc queries) |