CHALLENGE: Importing a txt file with a macro!!!!
Posted by Conor on October 26, 2001 2:39 AM
while i automatically open a spreadsheet with a macro is it possible to import a txt file (csv) that needs to have a few fields formatted(ie set to txt,gen,date) and the first line of data at line 12 always.
Can a macro handle this? ie can i insantiate the process of file, import txt file, setting the field types, choosing comma as a delimiter, starting @ line 12.
what i am trying to do is on pressing a button - import the txt file to avoid the user having to do this!!!
thanks all for any help!!