filename2

I have a script that creates a folder (if non already exists) then saves an excel file in this folder and it works great but a new request had come up where I need to create 2 sub folders with in this new folder... 1 called "drawings" and one called "Obsolete" this is my present code: Private...

Hi, I am trying to set up a 'master' workbook that collates worksheets from a variety of different workbook. It appears to work fine for the first run and it appears to run through everything ok within the second loop, until it gets to this section within the code...

I have two spreadsheets stored in the same folder on OneDrive. Values in Tab1 on Filename1 is referenced by Filename2. Filename2 contains formulae like: =IF(ISBLANK('[Filename1.xlsx]Tab1'!A1),"",('[Filename1.xlsx]Tab1'!A1)) and this produces the desired result. However, when I close and reopen...

Hi Friends! I'm making my first attempt at VBA, trying to save a file using cell data to a file location. Here's what I have: Private Sub CommandButton1_Click()Dim Path As String Dim FileName1 As String Dim FileName2 As String Path = “H:\Audit Vendor Resources\Quality Review...

Hi, I currently use the below code for some of our workbooks to auto save with a filename made up of cell values and automatically saves to a predetermined location. Private Sub CommandButton1_Click() Dim Path As String Dim FileName1 As String Dim Filename2 As String Path = "C:\Users\desired...

Using Excel 2016, I am trying to create a "save as" button and pull data from 3 cells to save the file. The problem is that cell S2 contains a date (which I need in the file name) but I can't seem to get it to work. When I test it and replace the date with text, it works. Can anyone help. Below...

I want to have a button in a workbook that will allow me to save a file name from values in C3 and D3 + add the date and save it to a network drive (eg. o:\customer drawings\ "value B3" \) so to resume 1 I need to check to see if the folder exists, if not create it from value B3... then same...

hi, i want to apply vlookup only on blank cell through VBA. I am using below code, but it gives me all column value instead of only blank cell. Private Sub CommandButton2_Click() Dim FileName2 As String FileName2 = "D:\1.0 Projects\[First.xlsx]"...