Upon clicking a button, columns A -D will be copied to notepad. In the notepad, there should be additional items added on top of the values copied from Excel.
Sample template of both excel and notepad as attached. Would greatly appreciate if anyone could set up the VBA codes or at least guide me on how I should start. Thanks.
Sample1.xlsxSample1.txt
Please Login or Register to view this content.
xace
The values in the text file don't appear to match those in the Excel worksheet.
This code will write the data to a text file using ;; as a delimiter.
Please Login or Register to view this content.
If posting code please use code tags, see here.
thanks everyone for the quick response, i'll try it out and see if everything is fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks