filename code

Hello all, I have done much digging in order to get this far but I'm still in little bit of a pickle. I am trying to make it so if a cell I have has a specific number form that it will save to a specific folder. In the Cell (L1) I have the date set as "mm-dd-yyyy hh-mm" and machine number ("11D...

Hi.. I needed some help..i just wanna copied just filenames (one or more) that i've selected to the cell that i wanted as a list..then adding a hyperlink to that filename so i can get to just open the folder of that file (not opening the file itself just the folder place of that file) while i...

Hi all, I have a macro that asks the user to select a file then with an input box they choose a range to copy. They will generally select (separately) up to 5 files across different locations to import data from. As a check process and to reduce errors I would like the ability for the user to...

Can anyone recommend VBA code that will loop through a directory file structure and list every Excel workbook, path, info to put into a database table? A nice Excel Template was used to record CO2 emissions as the regulation started. The template was really well thought out. Over the years...

I have several template files that I plan to add the following code to: Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim fname As String Dim MyDate Dim MyMonth MyDate = Date MyMonth = Month(MyDate) Sheet1.Protect "123" Sheet2.Protect "123"...