Hello,
I have a program that downloads 2 randomly named .csv files into my downloads folder. I am looking to add these files as new sheets in an existing workbook. The code below gets me very close by opening the 2 most recently downloaded .csv files as new workbooks, so I just need them to be added as new worksheets instead. I cannot reference the sheets directly due to the random naming.
Please Login or Register to view this content.
Last edited by cjohns; 01-09-2021 at 05:57 PM.
you said:
yes you can. more than likely, wherever you get them from has caused them to have some sort of consistency. thus, if the sheets you want are always on, say, the left side of the sheets that are at the bottom of the book when you open them (which *should* be the case, because CSV files shouldn't have more than one sheet in them anyway. they are not XL books, technically), just use the index. it's floor is ONE:I cannot reference the sheets directly due to the random naming.
so, open them, copy the sheets, paste them into your target book, and you're done. simple. to get the copy code, do it manually with the macro recorder and see what you get. that's how you learn from the wheel that was already invented by microsoft decades ago.Please Login or Register to view this content.
I have tired this and it does not seem to work. To clarify, the .csv file name is randomly generated by its source, so there is not a consistent book_name that I can use. When I record the macros it records the current bookname rather than referencing it by its file location (i.e., the most recent and 2nd most recent .csv files in my downloads folder).
Last edited by cjohns; 01-09-2021 at 03:48 PM.
OK, so can you upload the book that is in error? include all the code in it, and comment where the problem code is at. your description is not clear to me, still. the randomness of generation of *anything* is completely irrelevant in this case.
Thanks for your time. I have uploaded the workbook with comments in Module1
Last edited by cjohns; 01-09-2021 at 09:48 PM.
Never mind, I fixed it, I had misunderstood your explanation but was able to acheive the desired result by adding these lines at the end of my code:
Please Login or Register to view this content.
Doh, back to the drawing board. The code worked perfectly at first, but when I brought new files into the download folder it will open wb1 but gives error 1004 when trying to open wb2, saying it cannot find my download folder and it may have been moved/deleted...
I reuploaded the workbook with the code that was working before I added new files to the target folder (downloads).
Please Login or Register to view this content.
Last edited by cjohns; 01-09-2021 at 09:49 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks