1. B

    Excel Count to next number in cell when sample file opened even pressed dont save after changes

    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...
  2. D

    VBA filename into cell error

    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...
  3. D

    VBA Lookup value in another workbook

    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...
  4. Jyggalag

    Error in vba code (macro) that saves my file in folder?

    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
  5. M

    Get data from other open excel sheet without using filename

    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...
  6. D

    Macro move file to existing folder by name using filename first left7 digits with a space delimiter

    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...
  7. I

    Search for files that contain keywords in folder + subfolders

    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...
  8. T

    Formula help

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

    Open file based on Partial file name

    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...
  10. A

    Need to add Suffix in specific file name

    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...
  11. R

    Macro merger of filenames that start with a specific name

    Hello, I have a macro that consolidates all filenames that start with "BDRIDGE" and have a "DATAx" 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...
  12. Grizlore

    File name is a cell, not working when uploaded into SharePoint

    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("...
  13. N

    VBA for saving values in one column to text file

    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()...
  14. B

    Copy sheets from closed workbook

    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...
  15. A

    determine username computer name and save worksheet to filename in a cell

    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...
  16. A

    Save Workbook with name generated from excel data

    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 =...
  17. A

    Struck a snag converting 32bit to 64 bit

    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...
  18. B

    Format 51

    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...
  19. M

    Importing multiple files into one tab instead of separate tabs

    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...
  20. K

    Export Email Data from Outlook to Excel

    Hi, I have this below code which works perfectly fine. I need help to achieve 3 more tasks. 1. The number of attachments should not count if the file extension is png 2. The files with extension png should be shown or exported 3. Is there a way that the attachment(s) itself can be...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back