xlsm

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

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

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

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

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

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

Hi All, I'm keen to add a field to a spreadsheet that populates a cell with the username of the last person who edited the file, as in the system or logon name, e.g. first.lastname syntax. I would however like to keep this sheet as an .xlsx and not have it as an .xlsm. I have the code to use...

Hi All, Using: Office 2007 I have taken on a design spreadsheet from a colleague which is in .xls format. I want to produce MS word docs using data taken direct from the spreadsheet and so I have written VBA/Macro in word to do this. However, the excel doc will not save as a .xlsm spreadsheet...

I have an EXCEL 2003 xls file with embedded macros. Just installed EXCEL 2013 on new computer and after opening 2003 file, tried to convert/save as 2013 XLSM (macro enabled) version. Went through Convert/Save as XLSM/SAVE, but after Clicking "Save" the dialog goes away but no file is created...

An XLSM file that was created in Excel 2010 is on a network share. The file is accessed by a dozen employees, all using 2010. It opens quickly & appears fine for all but one person. The file seems to load on her PC (the properties are accessible) but nothing is visible. There is a prompt to...

When i open a xls file in excel2010 i have 65536 rows. After SaveAs xlsm there still are 65536 rows After closing and reopening the file, the 1000000 rows appear. Do i have to re-open the file? Why: We use different EXCEL versions. The advanced users have EXCEL 2010. Our mainframe starts...

I have a workbook with an ActiveX button that makes a copy of the activesheet and emails it. I figured out how to remove the button from the copied sheet and how to save it as xlsx instead of xlsm. However, how do I stop Excel from warning me that I am saving it in this format and my VB...

Hello! I've created a form for my work colleagues to complete when they want to start a new project. The form is completed by the project leader, then they hit a Command Button and it's sent to the Senior Manager. After the Senior Manager looks at it and approves it, he then sends it on to Admin...

Custom Ribbon Bar Stripped Out of .XLSM I have a mini-application that has been upgraded from Excel 2003 to Excel 2007. This upgrade involved replacing the custom application toolbar with a custom ribbon bar which consisted of creating a customui folder and customui file embedded in the .XLSM...

So here's the situation... I have an Excel 2007 .xlsm file that only contains Sheet1. I have two options, but the outcome has to be the same... Options Option 1: Have a "Load CSV" button on Sheet1. When clicked, the user needs to find a .csv file and Open it. Option 2: Press Alt+F8 to run...