Hello forum, I need help on something I can't figure out.
I have some *working* code that will open multiple specialized textfiles, delimited, as consecutive sheets in a NEW workbook. I need to make it open them as consecutive sheets within a workbook specified within a variable (variable currently being defined as active workbook, but have the flexibility to change that if needed as my spreadsheet/program grows). It feels like it should be a simple problem, but everything I try either gives me an error, or some unintended side effects (such as inserting two blank columns in the middle of the delimited data).
The following is the subroutine that opens them in a new file:
Any suggestions are appreciated, thanks ahead of time.Please Login or Register to view this content.
p.s. I've tried to understand line 19 of that code (that I found on the internet and, with the help of this forum, changed to make work in my situation) and am unsure if I'm correct. I've searched a bit and it *might* be better interpreted as (-1 or 0) instead of (1 or 0) -which of course are not equal to the filename- ...but I can't find anything concrete, and although getting this spreadsheet/program working is the current short term goal, I really want to learn in the process so that I am better equipped to do this again when the need arises. Is my comment in the following snippit a good representation of what is happening?
p.p.s. I have also posted this problem on mrexcel at the following link https://www.mrexcel.com/forum/excel-...-workbook.htmlPlease Login or Register to view this content.
Bookmarks