xlsm

  1. R

    Reminder when Saved

    So, I have some code (see below) that won't allow users to save the spreadsheet until certain cells are filled in. I now want to include code that will remind the user to save as macro enabled spreadsheet (xlsm), but only if the file isn't already xlsm. Here's my code so far: Private Sub...
  2. M

    XLSM opening onto particular cell - why?

    Hi all, I have a largeish timesheet XLSM which contains a tab for each month of the year. Each month contains project numbers against employees. there is also some project data on the tab. Every time I open the workbook it defaults to select a particular cell in October's tab. This cell...
  3. S

    access 2013 vba relink back end tables if not found

    good afternoon, I am looking for a way of relinking back end tables if the links get broken. back end file name changes sometimes. my links are not just a back end single accdb, there are 3 accdb's and 2 excel xlsx or xlsm files. I used access to link them, however when updated back ends...
  4. K

    save xlsm to pdf in pages

    I want a macro to save xlsm to pdf in range. I have this macro but many times the range changes. It is better to say the pages. For example my macro save the sheet from 1 to 30 page. But I gave the range of these pages not the number. First is hot to write it as pages. And second how can i...
  5. J

    Excel Save As With Different File Type

    Hi, I currently have a macro in my file (XLSM) which has a step where the user saves out the workbook in the current format. Sub SaveAS_Final() Dim strName As String SvName = Sheets("Instructions").Range("C51") Application.Dialogs(xlDialogSaveAs).Show SvName End Sub But since my...
  6. O

    Corrupt Excel (.xslm) file. Lost almost all data

    Please help me recover this file. I've been working on this for the past 3 weeks and would be pretty devastated if all data is lost. I have no clue why this error is occuring. Situation Context is that I can no longer open my Excel file (and when I repair, most of the data is lost). I...
  7. T

    Save excel invoice as xlsm and pdf based on 2 cell values and then print...Solution

    Hi Guys, I have been working on saving my Invoices in the raw excel format that allows macros, xlsm, and in pdf format to the same folder, having it named automatically by the value of two cells, invoice number and customer name, then printing it out and closing the workbook down. It took a lot...
  8. F

    How to tell Excel 2010 to open Excel macro files (xlsm) in separate windows

    I have been trying to figure out which registry keys need to be modified in order to open macro enabled excel files (*.xlsm) in separate windows? I followed the instructions on the following pages Microsoft How-To (if you want to open *.xlsx files in separate windows) and relation between...
  9. S

    Export worksheet as csv using VBA without renaming the original XLSM file

    Hi, I'm looking to export a worksheet as a csv using VBA code, but do not want to save or rename my original file. I can save the file with this code but I only want to export the data in Sheet1 ActiveWorkbook.SaveAs Filename:="D:\PORTFOLIO.csv", FileFormat:=xlCSV, CreateBackup:=False Help...
  10. A

    Copy of xlsm file giving incorrect results

    Hi, I had a created a code to automate part of my reporting. The format is of a template where I paste raw data in different tabs and then combine them to get the report format using macros. The original code works fine but when I create a copy of the xlsm file in which the original code was...
  11. DPChristman

    Auto save to a different format

    I am working with a successful macro in saving the document via clicking a macro control button. However, I was wondering if there is a way to have the document save to another format. The reason is that some of the people on distribution for this form are pulling it up on their cellphones...
  12. S

    Excel macro files

    It has always been my understanding that macros can only be created in .xlsm file formats. Yet if I open a .xlsx file, create a button, put code behind the button, and click SAVE...I get a warning about how it will be saved as a macro-free file...yet the code remains and if I click on the...
  13. C

    Help: Trying to create a "Email XLSM" button. Code not playing nice.

    Hello Everyone, I would like my Email XLSM button to do the following: 1. User clicks the Email button 2. The current xlsm workbook is saved to a temp directory, with the current date appended 3. A new Outlook email dialog box is summoned that attaches the workbook. 4. If the user clicks send...
  14. C

    Macro for a "Save Form" Button. Help please.

    Hello! I have created an xlsm file that contains two worksheets. One of them is a locked down form that contains a list of options and pricing for our dealers. the top row is frozen and has a print, save form, email form, and reset button. The problem I am having is with the save form button. I...
  15. P

    Importing from sharepoint using VBA almost there (I think)

    Hi all, I've been working on a excel workbook, where I want to import a workbook from a specific excel file, that is located in a sharepointfolder, into another excel file (named Import.xlsm). I'm able to import the workbook, if source-file is on my C-drive and .xls format. Private Sub...
  16. A

    Using a macro to open a macroenabled file which has autorun but autorun doesn't work

    Hello everyone, I searched the forum and internet but couldn't find the answer I need. I don't know if I found a bug within excel. Here is the story: I am using an excel file (lets say "xlsm1") which has a userform in it (actually I am just letting the user to see the userform) With this...
  17. B

    Excel 2013 File on Shared Drive With Macros Slowing Down Computer

    My user has an Excel 2013 file with Macros (containing mostly links only) that has completely slowed down her entire computer after being open for a few minutes. The computer nearly freezes and she can't click inside any cells after opening it from a shared drive on the network. Her computer...
  18. A

    How to Run an XLSM file without excel?

    friends, I have created a macro in an Excel file and saved it as <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New'...
  19. N

    Large Excel File issues

    Good Afternoon All, So let me be the first to dust off my login, it's been quite a while since I've posted anything here. I just wanted to say that thank you for posting all of your great posts in here as I've got all sorts of great answers from this forum. My turn now, my HR department have...
  20. R

    Issues With Running xlsm files with Hyperion Add-In

    I have created Microsoft Excel Macro Enabled (xlsm) files containing 195 lines of VBA code (teo subroutines, two functions) and total file sizes ranging from 162 kb to 205 kb. The files run perfectly on my computer but when my boss runs it, it takes twice as long and then the screen freezes...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top