filename

Hi i want to save all the excel output files in same folder ,i have a vba code but the files are not saving in the folder. The file should be saved in the format with first 5 digits in F column that is (example 1396A) format 01_03_1396A_yyyymmdd VBA CODE Sub...

I have a macro program where I save the name of the excel file with the values I get from certain cells. After this save, I have to say "Don't save" when asked if you want to save the sample file so that it is empty. Otherwise, it will come with the last values in the next opening. I want the...

Hi, I just created some macro that does a simply task. Asks to open a CSV file, and then in that file adds 2 formulas. Range("I10").Formula = "=MID(CELL(""filename""),SEARCH(""["",CELL(""filename""))+1, SEARCH(""]"",CELL(""filename""))-SEARCH(""["",CELL(""filename""))-1)" *I took this one...

Hi, I'm struggling to find the way in how to use xlookup function, to obtain data from another workbook, but without using the workbook name/path. I want to avoid using the name of the workbook and the path, because its going to be changing each day both name and location, earlier in the macro...

Hi all, I have this macro: Once I press the macro "Save file to folder", I get the error above, and debugging it leads me to this: I want to save my file as a PDF file in the path above. Any idea why it does not work and how I can fix it? Kind regards, Jyggalag

Hi All. I'm doing daily gathering of data from multiple sources to a master spreadsheet. Most of the daily data is emailed automatically each day. For 3 out of 4 of the sheets I need, I've simply created a macro button. I open the excel attachment on the email, go to my master sheet, click...

I'm looking for some help. I started trying to use excel for this project yesterday. I originally scripted a batch file to run this operation. The batch works in a small and limited environment. I tried the batch in a live folder and it was a complete failure with files being multiplied and...

Hi Everyone, Quite new to VBA and would really appreciate some help please ? I have a macro in a workbook that when ran, scans a drive that the user selects and looks for all files that contain the keyword provided. Is there anyway to: 1. Get it to scan also the subfolders within the folder...

Anyone know the formula to pull the filename only and pout it into a cell. Like just the files without the file name extension?

Hello guys, I written a code where it will open a file based on Prefix of a file name. But I need to open a file based on certain file name matches. Example: If file name is RSNOS_20200906_Summary and if RSNOS_Summary matches with the file name then macro should open the file. If file name is...

Hello All, I have a Macro, where it will open Previous file and Refresh the data. After Refresh it will Save the file. Now I want to add "_Refreshed" in the File name without changing existing file name. Example: File Name Before Macro Refresh "Markets_ 29 May'20.xlsb" and If i am doing...

Hello, I have a macro that consolidates all filenames that start with "BDRIDGE" and have a "DATAx" sheet.name from all containing subfolders. The path of the subolders being added in the 1st sheet of the macro file. My problem is that the macro does not retrieve anything as it only runs and...

Hi All Any help appreciated I am currently using this formula, to have the filename in a cell, works fine. However, when I upload into SharePoint, it doesn't work and returns a #Value! error =TRIM(LEFT(SUBSTITUTE(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),".xl",REPT("...

Hello, New to the forum. I've learned a lot just reading. Wondering if someone can help me with the VBA code below. It DOES save the whole worksheet to a text file, but I would like it to also Only save content in Column K Skip over blank cells in Column K Sub saveText()...

Hi all, back again with another ask. I have tried the below code (with a slight mod to try and pull the whole sheet rather than the range) to try and call up a workbook (name changes so need to be able to select from file explorer), copy sheets 1-4 and paste in the original workbook that the...

Hello brainiacks, (said with utmost respect). here is my problem: I have some code in a workbook named configureData.xlsm that creates a filename and stores to cell Q2 . I want to open a new workbook.xlsx and save it with the fileName created in Q2 The path would always be the same: UsersName...

Hello brainiacks, (said with utmost respect). Please help with my problem: I have some code in a workbook named configureData.xlsm that creates a filename in Q2 . I want to open a new workbook.xlsx and save it with the fileName created. The path would always be the same: UsersName =...

I don't really understand what this does as stepping through shows no code, it just "happens" Private Function MatchSpec( _ filename As String, _ FileSpec As String) As Boolean MatchSpec = PathMatchSpec(StrPtr(filename), StrPtr(FileSpec)) End Function In Excel 32bit filename is...

Good Evening Looking for some assist here. I am saving a workbook whichcontains several worksheets. When the new file is created there are two issues. 1. Message indicating to save the new file as an xlsx not amacro enabled file. 2. The new Worksheet the sheets have been grouped. How...

Hi I've got some code that imports multiple files into one single file. However, each file that is imported is put into a separate tab in the single file. I would prefer to have append the data from the multiple files, instead of having it on separate tabs. Does anyone know how to modify...