1. M

    VBA to Open/Save/Close Multiple Excel Files

    Hi all, I need some code that will loop through a folder of 300 excel files.........I need the code to open each file (which enables some updates), then save it, and then close it. The format of the files is xlsm. Probably a simple one for some of you folk Can anyone help?
  2. 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...
  3. D

    VBA for File save-as XLSM with user folder selection

    Hi, I have a large macro that asks the user to save the file vbYes/vbNo File name is coming from combo of cells in the file I want the user to select a folder on the network. It should ask to overwrite if file exist. It must save as XLSM. I've been trying to get ActiveWorkbook.SaveAs going...
  4. W

    Why does FUNCRES.XLAM open in a seperate window when I open an xlsm workbook

    I know what the FUNCRESS.XLAM sheet does, I have used it for a long time. In the past when opening an xlsm workbook only the workbook opened. Recently with no changes by me, a second window for FUNCRES.XLAM opens. This is true for existing and new workbooks. If I close it the entire workbook...
  5. J

    Insert a sheet into workbook using the open dialog

    I would like to import an xlsm sheet with data into my workbook at the end of the last tab and have the new inserted sheet/tab name the xlsm filename being inserted less the path. below is my code but I cannot get it to work right. any thought to what i am missing or have wrong? I switched to...
  6. G

    Keep xlsx and delete xlsm version from folder

    First of all I’ve been lurking reading copy and pasting for past 3-4 months. Big Thanks Bill Jelen for the videos, ebooks and this forum. It’s gold when a question in google shows up with links to MrExcel I have a Work Order xlsm file that opens, grabs next number, saves and closes then opens a...
  7. H

    merge files including macro's

    I have a problem for some month now. I am not sure wether this can be solved. I have 2 files which both have macro's, knobs to activate these macro's and pictures which are manipulated by macro's Now I want to merge these two files including the micro features. Up to now I have copied all...
  8. L

    Asus computer corrupts xlsm file?

    Hi all, I have a 1 year old Asus laptop (gamer, so pretty high specs) a 3 year old MSI PC (also gamer, practically a mini nuclear power plant) and a 6 year old Lenovo (which barely lives and even 6 years ago was very poor specs.. I used it to take it to school to make notes, and thats about...
  9. M

    Selecting non-Macro enabled files

    When selecting xlsx files, the VBA project viewer is automatically launched. Can we prevent this knowing that I have one xlsm file in the same folder? Thanks
  10. E

    Calling xlsm functions from xlam

    Hi Long time lurker finally signed up as I can't figure this out. Test.xlam: contains a class TestIF (Test interface) -- PublicNotCreatable contains a function RunTests (starts execution--called from a menu) which is supposed to callback to the xlsm file to instantiate the class that...
  11. M

    How do I open a XLSM file

    I have this Excel file I created back in 2003 with various macros but I can't find the method of opening the actual macro file XLSM ! I am using 2010 version and would appreciate guidance on how to open it. I do have the developer tab in my ribbon. thanks Ron
  12. I

    VBA: Parsing String

    Hi, I currently have the following string in a cell: "09/17/2015 0715" I am exporting this to a .txt file. Is it possible to parse the string so that it gets rid of the date and only displays "0715" when exporting the .txt file?
  13. R

    Overwrite existing files and save as PDF XLSM and new sheet

    Hi I have this save button, that saves: 3 sheets into pdf 4 sheets into a new workbook (xlsm) 1 sheet into a new copy inside the workbook My problem is if i want to save the sheets again it dosn't overwrite the old one. So my question is how to change the code so it overwrite existing files...
  14. D

    vba excel - closing ActiveWorkbook while ThisWorkbook is invisible

    I'm running Excel 2016. I have xlsm file that hides the application window when its userforms are running. If I attempt to close another Excel workbook (Book1) that has no macros, the Excel window for the xlsm appears visible and becomes the active workbook, and Book1 still remains open. I've...
  15. T

    Macro Limiting Save As File Types

    I have spent the majority of my day trying every applicable macro I could find on the Internet and altering it for my needs with no success. If anyone here could help me I would be so grateful! I have an Excel file with which I want to limit the Save As option to 3 file types that the...
  16. O

    Prompt User to Save File with Specific Extension (xlsm)

    Hello you amazingly helpful Excel wizards! I have a csv file that I'm fixing up using VBA. I'm getting errors about running out of memory and have read that saving the file can help resolve that. I'd like to prompt the user to save the file immediately after the macro is ran but can't seem to...
  17. J

    XLSM vs XLSB

    Ive been using XLSM for ages but just found anything works the same for me in XLSB format at nearly half the filesize. Does XLSB have any cons? I've read up on it but a lot of the info is old. I read with XLSB, if file becomes corrupt its harder to fix.
  18. Trevor3007

    choose xls or xlsm?

    good evening, I currently use the following vb:- Sub savetab() ' ' savetab Macro ' ActiveWorkbook.SaveAs Filename:="C:\times" & Application.PathSeparator & ActiveWorkbook.Sheets(1).Name ' However i can only send this to my recipients as an xls...but before send the final draft, i need to use...
  19. bobkap

    Convert XLSM to XLSX

    I have some XLSM files that I need to send to some people who know VERY little about Excel, much less how to deal with changing their settings to use an XLSM file. I only need for them to see the content. I have already massaged the data in to the form they need it to review it. HOWEVER, when...
  20. T

    Help regarding data extraction from multiple files

    Hi there! Please accept my apology in advance. I know similar questions have already been posted in this forums but being a dumb with VB codes I could not amend them for my purpose. I tried my level best to solve my problem with the help of the link given below...

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