Text file opening with macro

[AlexHall]

I'm trying to create a macro that will open a text file with the settings I choose. I have a dialog that pops up that allows the user to choose the appropriate file, but it always imports with the default settings, which leaves my data unseperated. Would it be easier to tell it the name of the file based on the date? The text file is always named like this "LaserSch20121221" using todays date. Could I use that to tell it which file to open, and how would I do that? Or would the dialog box be easier, and how would I make sure it imported with those specific settings? I tried this: "

Please Login or Register  to view this content.

"
But that gave me an error. Any help would be greatly appreciated

[patel45]

need to see the file for writing the correct code

[AlexHall]

I can't upload it because it is 991 kb.

[tigeravatar]

AlexHall,

Welcome to the forum!
I just answered a very similar question, see here: http://www.excelforum.com/excel-prog...er-export.html

[EDIT]:
Note that in your case, it would be called with "," instead of vbTab because your file is comma delimited:

Please Login or Register  to view this content.

[AlexHall]

Please Login or Register  to view this content.

Where do I put this? I'm probably just overlooking something silly but I can't figure it out.

[tigeravatar]

That goes in a standard module. The other code, ImportDelimitedTextFiles, also goes in a standard module. Then just run the tgr macro (you can rename it from tgr to whatever you want)

[AlexHall]

I figured it out. Thank you very much. One more question, how would I get it to skip a column? For instance, column 15 has nothing but "inc" in it and I don't want to import that because for some reason it messes with the calculations excel does throught the rest of my macro

[tigeravatar]

Unfortunately there is no way to skip columns via VBA, that has to be done manually
You could put in the macro to delete that column (if that is a feasible with your current macro/calcs)

Please Login or Register  to view this content.

[AlexHall]

That works beautifully. One more question and I should be done. Is there any way to give it a specific folder to open the text file from? Thank you for all your help

[tigeravatar]

Application.FileDialog has a variety of properties that can be manipulated. The one you're looking for is .InitialFileName:

Please Login or Register  to view this content.

[AlexHall]

Thank you very much. I'm new to coding this stuff and you've been a great help