data file

Hello, I'm trying to build a dialog box where will ask me to load a .data file extension file which later on i will edit few things and save as .xlsx. Problem is that whenever the file is selected and supposed to be loaded, there is no outcome... it simply ends macro as if nothing happened...

I'm working in another program which creates mounds of data in text OUTPUT file that I use excel to crunch. Currently I open the text OUTPUT file and copy/past into a new worksheet and everything is neatly pasted into column A. Is there a way to have the data in column A be linked directly to...

BACKGROUND: I’ve been developing an excel file that would take 2 years of historic data. Each line of data includes a “Zone/Room”, “Date”, “Case Type”(4 types) and 24 cells of binary data depicting each hour of a day either “1” (occupied) or “0” (unoccupied). I have to SUM each ROW of 24...

I have begun to chase my tail on this one, so help me out. I need to summarize some data from multiple files but I can't seem to have the user select the file and import it. It's a ERA(electronic remittance advice) 835 file that will import with the "Import Text File" routine. I've added...