Save As Macro Enabled Document Only

Mar 6, 2014

I have been having a problem with a document which I have created as a xlt format which then is saved locally but because some users arent as computer literate I have found them saving the document in non macro enabled format which means all macros are removed causing me a huge issue. Is there a macro which will only allow the document to be saved as macro enabled?

View 2 Replies


ADVERTISEMENT

Save Sheet As Macro Enabled Workbook Using Codes

Jan 28, 2014

Working with a macro enabled workbook that has many sheets what would be a good code that would save Sheet1 into a new MACRO enabled workbook so that the 'Buttons' (which are linked to macros) on this specific sheet will be the only macros that will be copied to the new workbook as opposed to the rest of the macros that are found in different sheets?

Here is what I g=have:

[Code] ......

View 11 Replies View Related

Save Workbook As Macro Enabled Workbook By VBA

Jan 23, 2012

the following scenario.

I am using the following code to save a workbook as a macro enable workbook on the selected path as today's date. But it is being saved as a macro free workbook.

Below is the code in module:

Sub save_file()
Dim tDate As String
Dim FileSaveName As String
Dim fPath As String
tDate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), "dd-mm-yyyy")
'FileSaveName = Application.GetSaveAsFilename(InitialFileName:=tDate, filefilter:="Excel Files(*.xlsm),*.xlsm", Title:="Please save the file")

[Code]...

View 4 Replies View Related

Save Word Document As PDF?

Sep 28, 2013

Amend this code? I want to save the word document, then save it as a pdf file, then delete the word document;

Code:
Sub E_W()
Dim strDate As String
Dim DirName As String

[Code]....

View 3 Replies View Related

Name And Save Document Using Defined Variables

May 28, 2009

I wasn't sure if I should put this question under "Excel Programing" or "Word Programing"... I am writing this program in excel, but the program references the word object library.

WHAT I AM TRYING TO DO: This program I'm making defines variables based on the values of a couple specfic cells. I want to save a newly created word document that this program generates, using the variables as its name.

View 4 Replies View Related

Excel 2010 :: Save As PDF - Document Not Saved

Apr 12, 2013

I have an Excel 2010 spreadsheet which I need to print to PDF. There is a simple "Save as" PDF option which always fails with just the message "Document not saved". I created a simple test sheet with just a few numbers on to check it isn't due to complexities with the particular workbook. This works on my home PC (Windows 7) but not on the Windows 7 Club PC which is where I need to run it to generate the output which eventually will go to the club's website.

It also fails the same way if I try to create an XPS file (although I don't want an XPS file).

This fails from the normal user interface "Save As". I also tried it from a VBA macro and run it: I get Run-time error '-2147467261 (80004003)' Document not saved

I've googled endlessly but all the references I tried failed to uncover a solution. I was a bit surprised that this doesn't seem particularly common and most of the reports seem to be a couple of years old or older (no workarounds were useful).

View 1 Replies View Related

Create New Word Document From Template And Save As

Jan 21, 2014

I have been working on the following VBA code, which should copy specific charts from excel into specific places in a word-template.

I Am quite new with VBA, so I googled the code, changed a few things, and it works exactly as it should - except from one thing. When the Word-document is loaded from the template, I would like the document to be "saved as..."
Instead of just opening the template. I have tried

Code:
.ActiveDocument.SaveAs Filename:=fname & ".doc"

The code is as follows:

Option Explicit
Sub EksporterTilWord()

Dim appWrd As Object
Dim objDoc As Object
Dim FilePath As String
Dim FileName As String

[Code] ...........

View 1 Replies View Related

Macro Enabled Workbook IOS App?

Dec 5, 2013

Is it possible to have a macro-enabled workbook to work on ios software(iphone or ipad app)? Currently I cant find any spreadsheet app that will let you have a macro enabled workbook. The code from the posts below would be great if they worked on my phone or ipad.

Scan barcode to excel with date & time stamp in & out.

View 4 Replies View Related

Userform To Fill In Blanks On Template Document And Save To PDF?

Apr 4, 2014

I have a word document that is a rental agreement. Im trying to make an easy to use user form where a person can input the information and it populates in the correct areas and saves as a pdf. How I could put the word document into excel and have a userform populate designated areas.

View 1 Replies View Related

Excel 2010 :: VBA Save AS (word Document) Not Working

Nov 8, 2012

I have a long bit of code that at one point saves a Word document and then saves it again with a new name and the old (legacy) .doc extension.

This all works find when the user is running Office 2007. However, it errors out for using Office 2010. The reference libraries are all correct (as far as I know).

Code:

Dim myDoc As Word.Document
Dim saveAsName as String

saveAsName = "some text here" + ".doc"

myDoc.Save

myDoc.SaveAs fileName:=(saveAsName), FileFormat:=wdFormatDocument

View 9 Replies View Related

Save Word Document With Current Date From Within Module

May 5, 2006

I am using a module to create and save a Word document from an Excel module. I'm using the following line to save the document which works fine but (and this is a big BUT)(to quote a TV programme from long ago) obviously everytime I save the document it will overwrite itself. Is there a way of adding the date it is saved on to the file name so it creates a new document each time.

objWordDoc.SaveAs Filename: = "WAGReport"

I have tried changing it like this but get an error message

Dim dtMyDate As Date
dtMyDate = Format(Date, "DDMMYY")
dtMyDate = Sheets("Client Master").Range("d2")
objWordDoc.SaveAs Filename: = "WAGReport" & dtMyDate

View 3 Replies View Related

Protecting Macro-Enabled Workbook

Apr 29, 2012

is it possible to protect a macro-enabled workbook with password.

View 5 Replies View Related

Macro-enabled Template Without Warning

Feb 13, 2010

I have created a template including a macro. It works as expected besides the issue that macros need to be enabled manually. This is totally annoying. I need to have it work directly.

Or what would be another way to have a macro available all the time I run Excel?

View 9 Replies View Related

How To Split Macro Enabled Text Into Different Cell

Apr 12, 2014

I usually copy ready macro from google. And I currently working on a check printing excel for my company to print check. I have googled and extract this macro from an author and place into my excel. But i run into a problem which is, the returned text will exceed the boundaries,

is there a way to spilt the text, lets say from after "dollars " to another appointed cell?

[Code].....

View 5 Replies View Related

Excel Macro Enabled Dashboard To Interactive Web Page

Jun 3, 2014

I have created a dashboard in excel and want to convert it into an interactive web page.

View 3 Replies View Related

Prompt User To Open Sheet As Macro Enabled - VBA

Jun 19, 2013

I have got a protected sheet with macros, how can I ensure that users can only open the sheet as Macro enabled only otherwise the sheet would not open?

I understand that some users may have different Macro security settings?

View 1 Replies View Related

Create Username And Password To Login Into A Macro Enabled Workbook

Jan 3, 2011

I need a macro ie when a user opens a macro enabled workbook,he should be asked for a username and password to access workbook. Administrator should have right to create users with reset password rights

View 5 Replies View Related

Excel 2007 :: Macros Enabled But Record Macro Grayed Out

Apr 14, 2008

I have excel 2007 and I want to record a macro. I have enabled all macros via the Trust Center settings and have even saved the current workbook (created from scratch in 2007) to a macro-enabled version.

But when I click on the 'developer' toolbar, 'record macro' is grayed out.

View 9 Replies View Related

IPad APP Which Can Open Macro-Enabled Microsoft Excel Files

Jun 20, 2012

I am looking for an IPad App which can open Macro-Enabled Microsoft Excel Files.

View 1 Replies View Related

Custom File Name At Startup Using Macro Enabled Template Format (XLTM)

Jul 17, 2012

So I am trying to make a file that when opened will act as a template does and change the file name on start-up.

Typically, the template changes the file name by appending one number (e.g. "Book Template REV 1.1.xltm' upon opening would change the file name to 'Book Template REV 1.11.xlsx'). What I want to do, however, is to custom the name change so I could use the file 'Book Template REV 1.1.xltm' while having it change the file name upon opening to 'Custom Name 567.xlsx', without a user being notified of the change (since typically when a template opens the file, the user has no notification that the file name has changed ever so slightly).

View 1 Replies View Related

Macro Enabled Column Hiding Based On Data Validated Dropdown

Mar 26, 2014

I'm trying to write macro for hiding columns based on a drop down answer. The drop down would be in cell B7 on Sheet 1. The colums affected would be in each worksheet in the workbook. The data validation would have a drop down selection choice of 1 through 16. The columns affected range would be H through W. For example, in the drop down if 1 was selected, only column H would show. If two, H and I would show...etc. This macro should affect all worksheets in the workbook EXCEPT sheet 1.

View 2 Replies View Related

If Macro Is Disabled: Place A Message On The Sheet Saying This Will Only Work With Macros Enabled

Aug 17, 2006

When you enable macros the sheets 2, 3, 4 ect are visible but if you disable macros, you only see sheet 1 and and you can place a message on the sheet saying this will only work with macros enabled.

View 2 Replies View Related

Searching For Mistakes In Document While Using Another Document As Reference

Feb 2, 2014

I am processing a fair few Invoices, which are being sent to me via e-mail as excel documents, very often they contain mistakes, a decent amount of mistakes. Usually the prices are wrong.

I keep track of every single entry on the invoice on my own document - Tracker, which I consider to be the superior/more correct document to the Invoice presented to me by my contractor.

Both of the documents have a reference number, which is a specific docket number, and horizontally, in the invoice, there is going to be a price for this docket. In my document, there is going to be a separate column for the total price.

Is it possible (I guess with VBA) to check for mistakes in the Invoice, but use the Tracker as a reference for this check.

Tracker has
columns
A - Name
B - Department
C - Date
D - Docket No.
C - Total price for the docket (calculation of E to Z)
E to Z - all smaller entries

Invoice has
columns
A - Date
B - Docket No.
C to E price for that docket, but it is spread, because departments are separated out, so each VAT account can be charged accordingly. I guess it is possible to do a separate column for the price, if it is easier to do a script that way.

Basically, I need to check if in the Invoice document, the price (C to E) for Docket No. (B) is the same as the price (C) for the Docket No. (D) in the Tracker.

I would like the wrong entries to be highlighted on the Invoice Document, so I can see straight away, that this needs attention.

Not always the price is wrong, sometimes the Docket No. is spelled incorrectly (Dyslexic contractor), hence the highlighting.

View 3 Replies View Related

Script That Will Turn Excel Document Into A Txt Document

Feb 17, 2009

I need a script that will turn a excel doc into a txt doc. Thats the easy part. The hard part (at least I think it is), is I need it to be in a certain format and I'll do my best to explain that fomat below.

View 9 Replies View Related

Macro For Document

Feb 8, 2010

i need macro for my document.this macro need run on column "E" & "H" i need like this.

ex- E2 cell some text or number is there,H2 cell value should delete.E2 cell is empty H2 value no need to delete.

View 9 Replies View Related

Macro To Format A Document

Dec 20, 2007

I am recording a macro to help me with formatting a document. I know do this manually, but realized that if I record a macro and run it the process would be faster. I have tried this and it works really well. However the problem is that although the columns are always the same, the rows increase and decrease everytime I download the raw report.

When I record the macro and then run it, it only selects the number of rows that I choose when I record the macro. I am sure there is a way to have the macro look for date and then stop after there is no more rows, but I can't find it in help.

I have tried selecting the whole document, but that slows the automated formatting down significantly.

View 9 Replies View Related

Macro For Printing A Document

Aug 9, 2009

I need a macro for printing a document, Could anyone supply me with the macro. And how to acivate it and sve in the sheet

View 5 Replies View Related

Macro To Check If Saved Then Save Else Bring Up Save As Dialog

Sep 6, 2012

I'm trying to make a macro check if a file has been saved (ever). If so I want the macro to do a regular save (with already esatablished filename and location) before it proceeds with the rest of the macro. If the file hasnt been saved (if it runs from a new workbook) then I want it to pop up the save.as dialog, so that the user can choose the name and location of the file before the macro continues .

The macro itself is saved in personal.xlsx.

View 1 Replies View Related

Save As Macro (macro That Opens The Save As Window)

Oct 22, 2008

I'm trying to have a macro that opens the save as window, places the name in cell f5 and then allows you to save the workbook with cell f5 as the filename. I have managed to get the save as window to come up and the cell f5 as the name, but when I press save is doesn't. Here is what I have (also, is there a way to direct this to a specific folder).

View 4 Replies View Related

Remove Macro From Backup Excel Document

Oct 28, 2013

I have this macro currently running on an original excel document

Private Sub Workbook_Open()Dim fname
fname = "C:ackupEconomics Tracker - " & Format(Now, "dd mmm yy hh mm AM/PM") & ".xlsm"
ThisWorkbook.SaveCopyAs Filename:=fname
Sheets("Menu").Activate
End Sub

Which creates a backup of the document each time the document is opened; I was wondering, is it possible to remove that particular macro from the backup as opposed to saving the backup as .xlsx? I don't want to be able to open a backup and the backup makes a backup

That particular macro is running on the main workbook.

View 9 Replies View Related







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