1. 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...
  2. 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...
  3. 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?
  4. 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...
  5. 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...
  6. 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...
  7. 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("...
  8. 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()...
  9. 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...
  10. 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...
  11. 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 =...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. spencer_time

    Two numbers to left of * and two numbers to right of *

    Hello, I -had- part of my program working until I realized that the length of the filename wasn't always constant and I need help fixing that. In the following section of code it used to look for a sheet names *CEQ* and extract the two numbers before CEQ and the two numbers after CEQ. I then...
  17. C

    Multi Embedding - icons names & Sizes

    Hi all, I was in need of a macro that embedded multiple files and I eventually got it. However, I need to resize the icons and get their names (file name / source name), as none of the names are shown but only blank icons. Although I thought I had captured this pieace in the code below...
  18. H

    Copying AND pasting (transpose) from multiple workbooks to one master workbook

    Hi there I have several workbooks in one folder that I need to open and copy a number of cells (G2:O2) from the same sheet name ('Output Create') for all of the workbooks into a 'Master' spreadsheet. Within this Master spreadsheet Column A contains a name of a place, which partially matches the...
  19. E

    Code needed for MAC Excel (latest version)

    This is what I want to do. Can someone help with code please. Not sure of the correct MAC syntax for the path, used to Drive letters in Windows 10 Select RangeA2 to I44 Use the filename that’s in Cell H10 Save as PDF to Path DATA1\DATA\DROPBOX\\BUSINESS\PDFINVOICE (Filename as in Cell H10)...
  20. C

    Use IF THEN ELSE to deal with file already open

    Hi. I can open a file remotely but am trying to create an error handling routine where, if the file is closed, open and update the links. If the file is already open it gives a FileInUse error and gives you the option to open it as read only I have been messing around with some code and ended...

Watch MrExcel Video

This Week's Hot Topics

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