![]() Mark the text, copy with CTRL C and insert (CTRL V) into a VBA module - or download a zipped example. It allows the user to select a file without actually opening it, and we store the file name and path in a variable, which we use instead of "C:\textexample.txt". To get a file name selected by the user we use the function "Application.GetOpenFilename". ![]() To use the macro for other files we need to replace "C:\textexample.txt" with the path to a file selected by the user, and we don't need the file specific "FieldInfo. ![]() Tab:=False, Semicolon:=True, Comma:=False, Space:=False, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, _ Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, _ ![]() Workbooks.OpenText Filename:="C:\textexample.txt", _ ' Makro indspillet 13-07-2013 af Eric Bentzen ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |