Hi everyone,
I need your help.
I have a worksheet called Contacts.
Column A is Contact Name
Column B is Contact Number
I would like to do a backup of the 2 columns and export it into a text file.
I would like to do a restore, import the textfile into the 2 columns.
Here is the code I currently have, it exports it into a textfile but when I import it back, it writes everyting in column A.
Also attached the actual workbook.
Thank you in advance.
Please Login or Register to view this content.
If you're going to write it with ADODB.Stream then perhaps you should read it using the same. See below:
Note I made a small change to the Backup routine to close the stream. I mostly re-wrote the restore routine.Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Sweet, I got an error however in the Restore routine at: .Type = adTypeText, I changed it to .Type = 2 and it works like magic now.
Thanks a lot, it's exactly what I was looking for. You are a star!
Oops. Yes. I had a reference to the ADODB library in my code - sorry about that. Glad it's working for youOriginally Posted by frankytheman
WBD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks