Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export only Modified Records
Hello,
I have a .txt file with 17,000 records. When I update/modify one or two records, I would like to export the updated/modified records into a new .txt file that i can upload to my online store. Is that possible? What I am trying to accomplish is keeping an offline database of inventory I have in my online store. There is no need to update the entire .txt file if I only need to change one or two records. Perhaps there is an easier way. I don't want to 'link' to the online file. I want the data I am working on completely off line. thank you. David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export only Modified Records
You could use a worksheet_change event that copies that row to a new sheet next available row and then save that sheet -- Don Guillett Microsoft MVP Excel SalesAid Software "yovation" wrote in message ... Hello, I have a .txt file with 17,000 records. When I update/modify one or two records, I would like to export the updated/modified records into a new .txt file that i can upload to my online store. Is that possible? What I am trying to accomplish is keeping an offline database of inventory I have in my online store. There is no need to update the entire .txt file if I only need to change one or two records. Perhaps there is an easier way. I don't want to 'link' to the online file. I want the data I am working on completely off line. thank you. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export to XML is not exporting all records | Excel Discussion (Misc queries) | |||
Export records into a text file based on criteria | Excel Programming | |||
how do I export excel records to csv file? | Excel Discussion (Misc queries) | |||
search and export multiple records | Excel Worksheet Functions | |||
How do I export an excel file as fixed length records | Excel Discussion (Misc queries) |