file name change

Hello Folks, I've developed a workbook to be used by employees with access to a certain folder. At the end of the month, a macro is run to reformat for a new month. I'd like to save the completed file to a new filename (which can then be protected), or save the old filename to another file...

Hello I have a an excel file with column "A" with old file name and Column "B" with new file names. Column "A" gives me full filename plus the extension e.g. "Sales.xlsm" but Column "B" only give me filename i.e. "Sales" I used the following code to replace old file names with new. It worked...

Hello :) I am trying to get data from 30+ workbooks into a new workbook. The 30+ are created daily, generated via e-mail; those e-mails are pasted into a new folder each day with the date and time. I need to pull the data from each workbook into a tab titled "Raw Data" in another daily...

i have inherited an access tool that imports a file into its database, makes a series of changes, then in its final stages exports the file back into the folder it originally came from with changes. this all works fine. however, what i want it to do, is export the file, but rename it to reflect...

OK...I have been a long time lurker, have done a forum search and can't seem to find the solution to my VBA issue. Crux of what I am trying to accomplish - I have a workbook template I am distributing via SharePoint, once opened by the user I am firing the save code from a button. When this...