Excel 2010 :: Macro Save File As XLXS But Not XLSM

Sep 13, 2012

I am using the macro below to save a file. It works with the extension .xlsx but not xlsm. I get a message that I can't use this extension for this file type. I am missing something fundamental.

Using Excel 2010
Sub testsave()'
Dim a As String
Dim b As String
Dim c As String
Dim d As String
b = "Myyfile"
c = b & ".xlsm"
a = ThisWorkbook.Path
d = a & "" & c
ActiveWorkbook.SaveAs Filename:=d
End Sub

FYI - there are no macros in the file I am trying to save.

View 1 Replies


ADVERTISEMENT

Excel 2010 :: Right Click (save As) Saves Inoperative XLSM File

Mar 22, 2012

Excel 2010, Win 7. I have attached a .xlsm file to an email. The contained macros run perfectly, and one of them is "public" so it shows up in "Developer - Macros", and "Customize Quick Access Toolbar" lists.

If the recipient clicks and drags the attachment to a folder, or copy/pastes the attachment, it works fine. (Macros are enabled, etc.)

However, if the recipient right clicks on the email attachment, and selects "SAVE AS" from the item list, the file saves, has the right name and extension, looks ok (the icon has the exclamation point, etc), and it is the correct size, but it simply will not load. You can double click, do a file open, etc. but it will not load. It's a hidden workbook, but if you "open it" and Alt-F11 to show the VBA editor, it isn't there!

It's not stopping the project - we simply tell them to click/drag, etc. but I totally do NOT understand why that happens.

View 5 Replies View Related

Excel 2010 :: Macro To Open XLSM File Based On Latest Date Found In Filename

Feb 11, 2013

I'm on excel 2010 and I have a small group excel files I open everyday. Most of the files are static in name and location. I've got a macro created to open those files, which works fine with workbooks.open and the file path.

There are two report files I want to incorporate into my macro of workbooks to open. The files are created weekly and the files names have the following format: "Report Name (YYYY-MM-DD).xlsm". I don't want to use the file's last modified date because older files may get edited after the more recent ones are created. The files are also not always created on the same day, so the solution needs to be flexible enough to not refer to a specific day of the week or anything.

Macro open an excel file based on the latest date found in filename.

View 9 Replies View Related

Excel 2010 :: Save As Cell Name In XLSM Format

Jan 28, 2013

I am looking for a vba to use a button to save a file using the cell as its name and save the file in xlsm format. I am using Excel 2010.

View 12 Replies View Related

Saving XLSM File From Excel 2010 To 2003?

Aug 1, 2013

I'm trying to save an Excel file to be opened on Excel 2003, but with some VBA formulas. What is the compatible format? 2003 doesn't open in .xlsm format.

View 1 Replies View Related

Excel 2010 :: SAVE AS File Name Using Macro?

Aug 13, 2012

USING EXCEL 2010

I am trying to record a macro where the last step is to SAVE AS the file. I want it to use the current date as the end of the file name.
i.e.

Daily OST -- 2012-08-10
Daily OST -- 2012-08-11
Daily OST -- 2012-08-12
etc...

This is what is currently in the macro but all it gives me is the first part "Daily OST --". How to fix?

ActiveWorkbook.SaveAs Filename:= _
"Y:ProjectsProgram ManagementPIODaily ReportsDaily OST -- " & DateString & ".xlsx" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

View 6 Replies View Related

Excel 2010 :: Macro To Save As PDF - Using File Name In Cell

Jun 24, 2012

I recorded a macro to save my file as PDF and assigned the macro to a button. Easy. Now I would like to change my macro to pause when the file is saving to allow the user to enter a file name. If that is not possible, I'd like to reference a cell to use as the file name. I have gone through other posts and tried changing my macro, but always get an error. I am using Excel 2010. Following is my code for saving to pdf.

Sub SavePDF()
'
' SavePDF Macro
'

[Code]....

View 9 Replies View Related

Excel 2010 :: Macro To Save As Encrypted File?

Jan 21, 2014

I am looking for a macro to "Save as" the current open file with an encrypted password using the highest protection algorithm in Excel 2010.

This should be a background process without user interacting with any dialogs and the new file should have "_enc" added to the end of the filename.

View 1 Replies View Related

Excel 2010 :: How To Save Excel File As Cell Reference Using Macro

Mar 5, 2012

I have created a macro in excel 2010 which enable the file to save (extract) data into separate location and name. The vba code for macro is as follows: Question: How can I save this workbook with reference to the value containing in cell B2? (it is named temporary now - as defined in the code)

Sub aaa()
'
' aaa Macro
'

[Code].....

View 1 Replies View Related

Excel 2010 :: Save Open Worksheet To File And Include Date Of Save?

Mar 11, 2014

am using Excel 2010 and having issues trying to save a worksheet to a specified file location with the save date....

I have tried several posts form this forum and elsewhere and can't seem to get the macro to do what I want.....

I want to save a 'worksheet' from an open workbook that I use for updating information to the same file path as the workbook with the date the file saved...

View 6 Replies View Related

Save XLSM File To Zip File?

Aug 3, 2014

There are two excel files abc.xlsm and xyz.xlsm enclosed. download these two excel files to your desktop. Then open abc.xlsm and run following code.

[Code]....

After running code above you will see that you have a new file in your desktop named xyz.rar. Everyhing is okey until now.

Now, delete abc.xlsm, xyz.xlsm, xyz.rar from your desktop. Then download enclosed file named klm.xlsm to your desktop. Then open klm.xlsm and run following code.

[Code] ....

After running code above why there is no klm.rar file in your desktop? Is it not possible to create a zip file running code includes same workbook? I mean why I cant zip excel file, from same excel file?

Attached Files :

klm.xlsm‎
xyz.xlsm‎
abc.xlsm‎

View 1 Replies View Related

Excel 2010 :: XLSM Password Remover

Aug 6, 2014

I have an MS Excel 2010 xlms file which is password protected. Unfortunately, the person who has the password has left the company!

Which is the best tool to remove the password / recover the file?

View 2 Replies View Related

Create Fillable Pdf File From Existing Excel Xlsm File?

Feb 25, 2014

I have a macro enabled file with some functions. Now I want to create a fillable pdf file from this file.

I am able to create a pdf file from Excel 2007, but not able to make a fillable one

View 1 Replies View Related

Excel 2007 :: Force File To Be XLSM File Type

Oct 22, 2013

I have a macro-enabled template file in Excel 2007. I would like the user to be unable to save in any format other than macro-enabled. They should be free to choose a path and filename, but not the file type.

I presume this means some VBA code in the before save event, but I don't know what.

View 2 Replies View Related

Excel 2010 :: Save Embedded PDF File To Disk?

Mar 4, 2014

Using Excel 2010, I have a workbook containing a variable number of PDF files captured as embedded OLE Objects. I wish to save each of the embedded PDF files to disk and assign the filename based on the contents of column 1 of the row containing the OLE Object.

View 1 Replies View Related

Excel 2010 :: Save CSV File With Non-English Characters?

Dec 5, 2012

I run excel 2010... I have xls file (see file attached) with both English and Non English characters.

When I save this file as xls or xlsx - everything is good, but when I save the file as CSV and try to open it later - I see that the English characters stays the same but the non English characters become gibberish.

How can I save a file (that include some non English characters) as CSV without loosing the non English characters? Is there a way to do that from within the excel 2010 menus? Or maybe there is an external tool?

Attached file : 913365454523.xls‎

View 1 Replies View Related

Excel 2010 :: How To Make File Auto Save To PDF

Aug 16, 2013

I have workbook I would like to auto save to PDF copy file in different location every time the original file is save maybe some VBA code

View 4 Replies View Related

Excel 2010 :: Save Open File Location?

Nov 26, 2012

I just got a new computer and upgraded to Excel 2010 and Windows 7. When I try to open a workbook in Excel 2010, my saved file paths on the left side of the screen are gone. I want to put them back in there.

In Excel 2007 running Windows XP, I would just right click in the left side menu and click "add" and now that's no longer an option.

View 1 Replies View Related

Excel 2010 :: How To Make File Auto Save To PDF

Aug 16, 2013

I have workbook I would like to auto save to PDF copy file in different location every time the original file is save maybe some VGA code is this possible ???

View 1 Replies View Related

Excel 2010 :: Error / Source Not Found With Certain XLSM Files

Nov 17, 2011

I am working with Excel 2010.

There are certain .xlsm files in our system (some have macros and others don't) which generate "Error: Source not Found" in the Edit Links dialog box when the Check Status button is pushed. However, the source location is correct, as you can click on Open Source and it will open the correct file.

For simplicity of explaining my issue, consider the following scenario. In my workbook "Corn Production Summary.xls_" I link to 2 source files: "Iowa.xlsm" and "Nebraska.xlsx" (Note: The extension of the summary file doesn't matter. This error happens regardless of what the summary is.)

When I open "Corn Production Summary" I am prompted to update values. I select Update and the file refreshes and recalculates appearing to have updated all values (i.e. no error messages). However, the values from Iowa.xlsm did NOT update and there was no error message indicating that the values didn't update.

To confirm this, I go to Data>Edit Links>Check Status in "Corn Production Summary" and I see that Iowa.xlsm has the "Error: Source not Found" error. I click on Open Source and once the file is open, my data in the summary file will update.

One work around was to do the following process (with the summary file closed):

1) Iowa.xlsm and Save As Iowa.xlsx (removing macros if needed)

2) Save As Iowa.xlsx as Iowa.xlsm (overwriting the file that is currently there and readding the macros)

3) Open the summary file and both Iowa and Nebraska work just fine now.

There are a lot of files like this, and because Excel doesn't prompt us that it isn't really getting the values from these certain .xlsm files we would have to search in "Edit Links" for each file to make sure that they really are updating.

View 3 Replies View Related

Macro To Save XLSM In Defined Path With Year Day And Month Changed

Jan 31, 2014

I need to save a document in the following path: [URL] .......

Only the year month and day sould change when I hit the save button/macro: 2014_01_29

How to build a macro that would save my file as per my above explanation??

If I would run the macro today the excel file should be saved in the path: [URL] .......

View 1 Replies View Related

Convert CSV To XLXS File

Apr 7, 2013

I'm trying to convert a csv file but after conversion not everything is in place.

View 3 Replies View Related

Excel 2010 :: VBA Code To Save File As Semi Colon Delimited Format

Jun 3, 2014

I am looking for VBA code that will save Excel 2010 files in semi-colon delimited format without having to chage the universal language options.

View 1 Replies View Related

Excel 2010 :: Save As PDF Macro?

Apr 10, 2013

I need to create a macro that will allow me to save a PDF from an XL file I am creating by running a report out of Access. This report yields a workbook with 2 sheets in it. The first tab (sheet) called "Mishkon" and the second called "Women's League". I need to save these reports separately as PDFs and they need to be saved in seperate locations. The first sheet (Mishkon) needs to be saved here: \OSOFSDataDayHabMishkon . The second sheet needs to be saved here: \OSOFSDataDayHabWomen's League . Here is the twist... Both sheets need to take their name from their G3 cells. I have Excel 2010 and dont want to print from my Adobe PDF printer. I would like to save as a PDF so I can run it off of computers that dont have the Adobe PDF printer installed.

View 5 Replies View Related

Save As Xlsm

Aug 23, 2008

My office just converted to 2007 and I am running into a problem with code used to save a workbook. I need to use a dialog box as the file could be placed in several different locations which the user needs to choose.

When the save as dialog box opens it defaults to being saved as the xls type. I would like to modify the following code so the file type drop down defaults to the xlsm type. Below is my code.

Sub SaveFile()

Dim Fdate As String

myDate = Range("HeaderPage!B13")
myFile = Range("HeaderPage!b8") & "_" & Range("HeaderPage!b9")

Application.Dialogs(xlDialogSaveAs).Show myDate & "_" _
& "_" & myFile & ".xls", 1, , , , False
End Sub

View 9 Replies View Related

Excel 2010 :: Using Macro To Open Network File

Jan 5, 2014

I am an extreme novice to using macros.

I used the 'record macro' feature to create the following: I created a rectangle box on sheet1 of NEW TEST.xlsm to link to the macros incidated below. Niether macro moves on after reaching the Workbooks.Open statement.

I am at a loss. Is there something in Excel that needs to be set? Is there something else that I need to do version of Excel is 14.0.6129.5000 (32 bit) MS Office Professional Plus 2010

What I am trying to accomplish is this: From 'NEW TEST.xlsm', open an excel file on the network, add a new sheet to this network file, calling it 'Pivot'. Then create a pivot table in this new sheet from the data in sheet data1 of this same network file. Then move control of macro / processing back to the NEW TEST file. Eventually I will do more, but for starters, I cannot even get the macro to add / name a new sheet in the network file.

[SIZE=3][COLOR=#000000][FONT=Arial]PS I have attached the NEW TEST.xlsm fikle as we as the data file. NOTE: the data file has been reduced to one day's worth of data, to to the upload file size.Also, my Excel Trustred locations has "Allow trusted locations on my network" checked, and the network location to the data file in trusted user locations.

VB:

Sub Open_Add_Sheet()
Dim filename, filelocation As String
Dim wb As Workbook
filename = "11 Nov, 2013 GDO AHS Agent Productivity Report.xls"
filelocation = "R:acharukAHS ReportsGDOGDO CSR ACTIVITY Report2013" & filename
Set wb = Workbooks.Open(filelocation) '
' Open_Add_Sheet Macro

[Code]....

View 9 Replies View Related

Excel 2010 :: How To Make Macro Print In Other File

Jun 26, 2014

Excel 2010.I'm using this code to print user's accessing a file:

[Code] .....

However as someone could just delete the printed user log in the Sheet2, and also you can't use this if you protect the sheet, which defeats the purpose.

I want it to print the log into a separate file. Can I add in the file path/name to this code somewhere?

View 1 Replies View Related

Macro To Save Excel Sheet As Comma Delimited Text File?

Apr 21, 2014

providing a macro to save an excel sheet to comma delimited txt file. Also, My sheet has 1st row as table columns and i dont want to export them in my txt file.

View 14 Replies View Related

Macro To Open File, Copy Paste As Values And Save As Excel Html

Feb 16, 2010

I have a folder containing 40 single sheet excel workbooks and I would like to automate following tasks:

- Open each excel file (need to open the file so as to update it since it gets the data from another workbook through =formulas)

- Copy paste as values

- Save this as excel html in the same folder as original excel files (keeping the original file name)

- Close (original excel file should not be changed ie formulas should remain in place, only the html file will contain values)

- Since there will always be xHtml files with same name need the macro to replace the excisting file

My abilities with excel are limited to functions, no VBA knowledge other than finding ready codes and pasting them in the module.

Since this routine is to be run almost daily the macro should run all files, instead of one by one.

I just hope that I am not asking too much for excel to handle and I hope that explanation is clear.

View 9 Replies View Related

Save XLSM As PDF And Mail To Recipients?

Sep 22, 2013

I know there are plenty of examples on how to do this at a basic level but I am looking at making it a bit more custom.

I would like to put some variables on a sheet in a workbook and use those to drive the behavior of the code.

EG I would like to specify the save-as-pdf path (eg c:users.etc), the email addresses to be emailed TO (specify a range eg A1:A14 where each cell has a different email addy in it), like wise for CC and then BCC (new ranges), also be able to specify subject of email (EG Cell F1.value is email subject).

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved