variables file name

To minimise the amount of changes I need to make when this bit of code is duplicated for other filenames, ALPHA-L4L.xlsm changing to BRAVO-L4L.xlsm and so on, I assigned the .xlsm file and its path to a variable so that I only need to make the change once (see black and bolded). Which is...

I am trying to copy worksheets within a workbook to new workbooks based on the value of the sheet name. So there could be any number of worksheets in the file, say 5 sheets start with the name Allegiance, 2 start with Express, and 3 start with McCollum. I want to copy, either a sheet at a time...

I want to save an excel file. -The file’s name and folders’s names will change each time a file is saved. -I recorded a macro to save the current file, then added variables defined by InputBoxes so a user could name and save each file to the correct folder.</SPAN> I get the error message...

Hi all, In order to assign a macro to an object, I need to specify an Integer variable as part of the file path. How do I do this? I've tried different combinations of quote types/positioning with no luck. When clicked, I need to run macro "DatabaseScan" from workbook...