I have a program that downloads files in .xlsx that come from multiple vehicles. I save the files off manually with a file name that I want to use as my tab name for the purpose of combining the sheets into a workbook for further processing. I use a macro to configure teh sheets already but have not figured out how to name the tabs in VBA.
My current file name is "article-01 20130422.xlsx" and I only want to use the "article-01" portion of the file name on the tab. So I currently have ten articles and I combine them into one workbook and then have formulas to populate an additional sheet for rapid access.
Thanks for any help you can provide in this endeavor. I have EXCEL 2007 available.
My current file name is "article-01 20130422.xlsx" and I only want to use the "article-01" portion of the file name on the tab. So I currently have ten articles and I combine them into one workbook and then have formulas to populate an additional sheet for rapid access.
Thanks for any help you can provide in this endeavor. I have EXCEL 2007 available.
