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

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.

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

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

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

Hi, I was wondering if there is a way to limit how many copies you can make of an excel file(xlsx or xlsm). (i.e. limit # of copy+paste operations carried out on a file) Thanks, Sj

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

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

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

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

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

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

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

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

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

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

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

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

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

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