file

  1. B

    Code converting xlsm to xls

    As you can probably tell by looking at the code below, I simply run the code when I have a xlsm file open and it saves it as a xls. A problem Im having is if i accidentally run the code on a xls I will get error at the Kill Filename. Is there something that could be added at the beginning where...
  2. D

    Color the cells based on notepad color code

    Dear All, My name is Dusan and this is my first post in the forum. I have been using it for quite some time now, and the reason I am boring you with this question is because I have not been able to find the answer anywhere... Here it goes: I have 50.000 lines in the .txt file (50.000 different...
  3. A

    Array not erasing

    Hi, I cobbled together some code from multiple sources that will process text files. Since we have multiple files in a folder that need to be read, I built the process to read all of the filenames in a folder into an array (DirectoryListArray()) that I use as a master list of files, then...
  4. R

    Power query not updating

    Hi - I have a problem with power query not updating all data from my source file. My query was created from file / from folder, and I currently only have a single file in that folder at the minute. I have imported that data into power query with no issues currently, however if I change some...
  5. Z

    VBA if ReadOnly Loop

    Hi All, Hoping someone can help me with this. I have some code that will open another Workbook, add data, save/close. I’m trying to create a loop that will check if the file is opened read only, if the file is opened read only, if like it to close the file and try to open it again, after 5...
  6. K

    Macro Help

    The following macro is designed to split several tabs within a sheet into individual files. What I would like to do is get this part of the macro: Format(Date, " BOB mm-yyyy" to prompt a dialog box once at the beginning of the macro to ask what is the additional name tag the files should use...
  7. B

    Run-Time error '1004' Method 'SaveAs' of object'_Wokkbook' failed

    Hello, I'm trying to save a newly created file in csv format. I am copying results from one open file, and pasting in a new workbook, and then trying to save the new workbook as a csv file. My code is below. See the "Save File as CSV" section below. Thanks! Sub Monthly_Device_Volume_Map()...
  8. S

    to see data on top

    Hi good evening I am working on a file which have lot of data, I daily update that file, now my question if I enter a date in date cell that row go automatically on top of the blank cell Thanks
  9. A

    Help adding loop

    hello all! i am learning to code, and have 7 books but still have such a hard time understanding loops. i'm desperate for help. My boss wants me to loop through a years worth of files and pull data. I tried for days, and am just not retaining the rules behind the action. I hope someone will just...
  10. L

    undo read only excel file

    Hi I saved a file as read only (save-->tools-->others--> checked [] read only). Now even for me, it open as read only. If I want to save it, it will create a copy of it and save the copy but original one is still read only. How can I undo Read only or that is not possible? Thank you. Thanks
  11. N

    Message Box Pop up twice while closing workbook event

    Hi All, I am using below code to save the current file in another location and also want a pop up message if user want to save a copy of file or not ? but every time I am closing the workbook the message box pop up twice. Can anybody help me out what mistake I am doing ? Private Sub...
  12. NicholasP

    Email sending with subject line in Chinese Characters

    I have some code that works fine on my machine, but when my coworker runs it, the subject line comes through as Chinese characters. The email still sends with the file attached, but the subject line has the Chinese characters. Has anyone seen this before or have any ideas as to why this is...
  13. K

    Stop column data from moving

    Hello, So i'm trying to build a macro-updating document register. So column A = the full URL of the file location (input via macro - see below) Column B uses the following formula =LEFT(A2, FIND(CHAR(1), SUBSTITUTE(A2, "\", CHAR(1), LEN(A2)-LEN(SUBSTITUTE(A2, "\", ""))))-1) to find the...
  14. M

    Hyperlink url changes - mass change

    <tbody> Hi I am having an issue performing a mass update on url addresses within excel. I have a macro embedded spreadsheet that contains a list of url links to file folders. The purpose of the macro is to select each folder individually and email out to the relevant person. The root file...
  15. C

    Missing menu

    Ok Something happened to my excel over the weekend while I was not at home. If I just double click any excel file the menus are missing but if I open Excel first and choose the file all the menus are there. I cannot figure out how to add the pictures I took of the screen so I can show you...
  16. S

    [VBA HELP] Save file prompt to overwrite, save as or cancel

    Hello, I need help on VBA for the following requirement. Pop up message with 3 button of choices 1. Overwrite file 2. Save as different file name 3. Cancel operation. Thank you so much for your help. Cheers..... Sasils
  17. kelly mort

    ENC file problem- don't know how to open it

    A friend sent me a file to open for him. The file extension has now become like this: Book1.docx.nakw From his end, he inserted a flash drive into his system and all his files got the new strange file extensions. I have come across such situations, mostly when I send an unzipped workbook...
  18. G

    ChDir path problem

    I have been using a macro successfully for sometime now, but I have just bought a new machine and I am running W10 and 365 E3 and now the macro will not see the path of the file The files are all stored in the cloud (Office 365, OneDrive for Business) but are also synced with File Explorer When...
  19. S

    Send different emails to different email ID"s from Excel

    Hi everyone, I know how to send emails to several emails ID's at a time using VBA... But, I am looking to send different emails to each email ID/ID's at once. Like we do in a mail merge. Currently I am using mail merge whereas, some sections of the email are fixed and are taken from an word...
  20. D

    On Excel File Closing - Receive Out of Memory Warning and Closing of Application

    I have a reasonably large file with VBA code and Userforms. Frequently, upon closing this file I receive the error "Microsoft Visual Basic for Applications - Out of memory". Once I have closed the error message the entire Excel application and all open workbooks are shutdown and Excel restarts...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top