stanl
02-24-2007, 09:22 AM
I have just started a new position as a rate analyst, and will inherit or be asked to 'look at' several humongous workbooks with data that is copied/paste, manually entered or failing with recorded macros. The horizon seems to include delimited files for parsing and export. I am used to scripting with access to C++ dll's that make file i/o simple... for example if I wanted to load a file in the current subdir into a memory variable and convert , into Tab I could
memvar = StrReplace(Fileget(curdir():"test.csv"),",",@TAB)
Since I do not have the capacity to use that language, I'm wondering if there is a generic set of VBA File i/o functions to handle
locating text files and opening them
writing output files. By generic, I mean callable from any sub in any given workbook?
TIA... Stan
memvar = StrReplace(Fileget(curdir():"test.csv"),",",@TAB)
Since I do not have the capacity to use that language, I'm wondering if there is a generic set of VBA File i/o functions to handle
locating text files and opening them
writing output files. By generic, I mean callable from any sub in any given workbook?
TIA... Stan