Hi
I am trying to write a macro that will loop through my folder of txt files, import them that will use the import feature and delimit it, then save as an xls file.
So far, I have only been able to use the following, but it only allows me to import one file (and I know the folder path, I want to avoid choosing the folder).
It also adds many quotation marks ("") when I only want to import using tab delimiter and comma.
Can anyone help me with this?
Please Login or Register to view this content.
Bookmarks