Mahendra S
Member
Greetings Q: How to read data from dat files and write in to excel worksheet using vba
Is it possible to read data from dat file/files and write in to excel worksheet with vba.
If Yes, the requirement I'm trying to make it is
User will have to enter a number in search field in user form (Search Records User Form in spreadsheet from atatchment)and click ok.
Need a macro to look/find for this entered number in dat files(this can be a single file or 10 files in same folder) and if finds a match in a comma delimited(semicolon is the end of record as given in example) then this record need to be copied in to worksheet.
Attaching the example data with this thread (DATtoWORKSHEETPrototype.zip)
Please let me know if any one has solution with a macro for above requirement.
Appreciate all the help.
Regards,
Mahindra
Is it possible to read data from dat file/files and write in to excel worksheet with vba.
If Yes, the requirement I'm trying to make it is
User will have to enter a number in search field in user form (Search Records User Form in spreadsheet from atatchment)and click ok.
Need a macro to look/find for this entered number in dat files(this can be a single file or 10 files in same folder) and if finds a match in a comma delimited(semicolon is the end of record as given in example) then this record need to be copied in to worksheet.
Attaching the example data with this thread (DATtoWORKSHEETPrototype.zip)
Please let me know if any one has solution with a macro for above requirement.
Appreciate all the help.
Regards,
Mahindra