saving

Hi guys, I need some help with a macro Im trying to make All I am doing is cycling through a folder of .xlsb and saving them as a CSV file and then close The latter part Im having difficulties with, any code that I try using to close without saving does not work. When I run the macro, it...

Sub PasswordSave()Application.DisplayAlerts = FalseApplication.ScreenUpdating = False SaveAsName = Application.GetSaveAsFilename( _FileFilter:="Excel Files (*.xlsx), *.xlsx") ActiveWorkbook.SaveAs Filename:=SaveAsName, FileFormat:= _xlNormal, WriteResPassword:="test", ReadOnlyRecommended:=False...

At my work we run off a networked system. The only way I can make my excel tool to be used by my fellow counterparts is by creating a shortcut from the network drive to my desktop, than save the workbook by using that path. What is a way that i can save my workbook to this shortcutted folder.

During the day I switch back and forth between Automatic and Manual calculation options. Every time I switch to manual, The Recalculate workbook before saving option is turned on. What workarounds do you suggest so that Recalculate workbook before saving option remains off by default when...

Hello wonderful Mr Excel forum. Could i have some assistance on creating VBA code to prevent a document save unless certain criteria is met. i have four codes within a drop down which relate to invoices, however one is a general code and require information is their a way to stop the document...

Guys, How can I save a cell value in another cell as a copy? I mean I dont want to keep a connection between the cell that receive the value 1 or 0 with the cell that I want to copy this values. I want to do that to save the number of time that the cell goes to 1 or 0 among the day. Can...

I hope somebody here can help me with some coding issues. I have been trying to do it via Record Macro but I am stuck. I need to accomplish this report as soon as possible. I have tried to add the code using Mrexcel HTML maker but it didn't work. I also have a workbook but I don't know how to...

Hi All, Currently i have a macro which saves a file to 3 different locations on a shared drive. However if someone has the file open in one of the locations it returns an error and doesnt allow the macro to run properly. Is there an override code that i can use or possibly an alternative where...

Hello all, I'm having trouble saving the outlook item. (Hmmm, I just realized I'm working with Ms Word - does it matter? Can I still post here?) Anyways, the issue is that, Word is creating the Message and sending it just fine (with attachments, subject and everything), but it is not saving the...

Hello Everyone, I've been having some problems with a really simple VBA code, I have tried "save as" or Copying the file and renaming, once or twice, for some reason it has worked, most of the time it doesn't. I have to create 30, 35MB Workbooks and everything works fine, formulas and VBA apart...

I have written some code that uses the copy to new sheet function in excel a very format heavy tab. I then have written some code to save said tab and some other code to update some values in the original sheet and alter the country loop through it saving the file each time. Each bit of the...

I am using the following code to prevent users from saving a document. The problem is, I can't save the code in the document either as it's preventing all saving. OMG!!! How funny. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) MsgBox "Please don't use the save...

I have a workbook that is stored as read only on a SharePoint site. Users are unable to save the document (save as is allowed), but when closing out of the document, the dialogue box still shows saying "Want to save your changes to [file name]" with options of "save" "don't save" and "cancel"...

Good day, I have been trying to save a few excel files into a PDF format. It would get half way and excel would crash, not responding in task manager. Can someone please help me out with this, I have macros and its somewhat a large excel file. Any help would be appreciated.

I was working on my Excel 2013 workbook and when I clicked on "Save", Excel froze up and I had to eventually CTRL+ALT+DELETE it. Then when I reopened Excel 2013, I went to my recent workbooks and clicked on the one I was working on and it told me that the file may have been moved or deleted. I...

Hi all I'm using Office 365 / Excel 2013 and have recently upgraded to Windows 10. I keep getting "Can't save due to sharing violation". Does anyone know what this is, or have any solutions to offer? Thanks in advance.

For some reason I keep getting an error when I am trying to save two sheets as a PDF. Still new to VBA so i know there is a better way to do this all but this is how i have it set up right now. I always want the Letter sheet to be the first sheet in the PDF, but then I want either CAt, Dog or...

Hello, I am currently writting a macro which requires that the data after the macro is ran, to be put into a new workbook. However, I need some Macro code to go over with it for use later on the data present. Is it possible to have the macro copy another macro to another workbook? Thanks in...

First of all I'm not using Excel as a norm spreadsheet. I'm using it to create customer billing forms with detailed word processing as well as needed calculations. I don't have a problem with that part of it, my problem is combining 2 sheets of the workbook only when a second page is used. My...

Is there a way to make a copy of a macro-enabled excel file into a new excel file where all of the original values and formatting matches the original (ie. if a a data field is a vlookup formula I want the shown data to be copied not the formual itself)??? Any help would be greatly appreiciate...