I have this code in excel:
Heres the txt file:
Please Login or Register to view this content.
I intend to insert all values from txt file into Excel, but via VBA.Please Login or Register to view this content.
My error is:
Subscript out of range
But doe not highlight the code in VBA
Last edited by Eduards; 11-27-2019 at 09:13 AM.
Usually this error is received then there is some objects missing on the code.
Like in this case,the file / folder might not exist OR Sheet1 doesn't exist (It might have some other name.)
Check that out. Hope it will solve.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
I'd guess that at least one line doesn't have the same number of commas.
Rory
Hi both,
I was missing an extra line of code:
There was extra information on the CSV filePlease Login or Register to view this content.
That could not possibly cause a Subscript out of range error.
removed as I didn't look at the loop, should have been
Please Login or Register to view this content.
Last edited by nigelog; 11-27-2019 at 12:41 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks