Hello all,
When I run the VBA script to import all .csv sheets from a directory into a new excel file as their own individual sheets, I need the sheet names to stay their default names (sheet1, sheet2, etc..). When I import them, the sheets have the files names. Is there any way to adjust this code so all sheets are imported as sheet1, sheet2, sheet3, or so they're imported as something standardized (customer1, customer2, customer3, etc...)?
Please Login or Register to view this content.
Hi,
Untested in the absence of your workbook but add a counter and use the counter to rename the sheets. i.e.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks