Forum Discussion
EXCEL VBA - Importing and formating a TXT file to a existing table
Hey Guys, I'm new to VBA and advanced Excel use. There is a little project I'd like to achieve and maybe some of you are able to help out with some tips 🙂 My goal is to extract data out a tx...
Thank you very much for the answer!
When I try running the script I get a runtime error 52 and the debugger does mark a line of the code in yellow:
txtData = Input(LOF(1), 1)
Do I need to define the file which is opened to be file number one?
Thanks 🙂
When I try running the script I get a runtime error 52 and the debugger does mark a line of the code in yellow:
txtData = Input(LOF(1), 1)
Do I need to define the file which is opened to be file number one?
Thanks 🙂
txtData = Input$(LOF(1), 1)