saveas code

Hoping I can get some help with this, quite new to VBA and loving what it can do ! I have this bit of code below which will save 2 sheets into 1 PDF: Sub CompileReport() Dim mySheets As Variant, sh Dim filename As Variant mySheets = Array("Print User", "Print...

I want to save Excel files in both the local drive and in the network folder. Currently I am doing it with SaveAs (local) and another SaveAs (network), is it faster to do a SaveAs then FileCopy? Code below: Sub SaveAs() Dim ws As Worksheet Dim ws_console As Worksheet Dim...

Hi Al, I hope someone could help a novice with this problem. I am writing some code which deals with opening and saving quotations. What I want to do is open a new document (document1) from my quotation template. Then i drop in some book marks, (which I have done with little problem). Now when I...

I have created the following VBA macro in excel. The macro works fine until I get to the save as section at the end. I have used the same code in other excel spreadsheet and its saves perfectly, although I get the following error message when I try to do it within this spreadsheet: "Compile...

Hello Does anyone know vba code to bring up a file Save As dialogue box when the user comes out of the file? I have been looking around for the code, but no matter what I put, nothing is happening and the file just closes when I click the "x" at the right. Thank you Mieke

I have several template files that I plan to add the following code to: Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim fname As String Dim MyDate Dim MyMonth MyDate = Date MyMonth = Month(MyDate) Sheet1.Protect "123" Sheet2.Protect "123"...