.dat

Selecting only few fields 3 ( Has subject ID, Stimulus defines and %Change) rows out of 1500 ..(.Problem is they appear in different cell location for every excel file) is from the Excel file, copy and save them in Master Excel file. In my head it works perfectly: 1) drag .dat file into Excel...

Hi, I have long list of files in .dat format that I want to convert them into excel format. The files have bunch of data separated by delimiters and I need them to be separated by columns in excel. I know the excel trick where I can import the data in excel/or open with excel and use the...

Hello everyone... been some time since I last posted in this forum... Hope everyone is doing well... I have a question: I have a bit of code that will allow me to "point" to a folder where I have placed some .dat files to be processed and process each of the files until all have been done...

Hey, I've been struggling with this and I can't seem to figure it out. I'm trying to write a VBA code to export an excel worksheet named "Final" as a .prn file and then convert that into a .dat file. The file location needs to be the same as where the workbook is (dynamic), as the workbook is...