saves

Hello, need a little help, hopefully it's relatively easy. I currently have a code that saves my workbook to a specific folder I designated, naming the file based off a cell value. Unfortunately once I click the button to run the Macro it saves the current workbook to that location. I would...

I have the following code to save a sheet in my current workbook to a new workbook. Sub Sheet_SaveAs() Dim wb As Workbook Sheets("Audit Sheet").Copy Set wb = ActiveWorkbook With wb .SaveAs Format(Date, "yymmdd") & "_REP_" & Range("M4") & "_" &...

Here is my simple code, found online. Sub test2() ' copies a worksheet into a new file and saves it onto desktop Dim newWB As Workbook Sheets("Sheet1").Select 'Add a new workbook and copy the Members sheet over Set newWB = Workbooks.Add ThisWorkbook.Sheets("Sheet1").Copy...

Lost a new thread post - where do auto saves go? i answered the phone after three minutes went back and posted by question but it's not anywhere to be seen. Looks like my session timed out. But I always see the auto saved popup - so where do I go to find the original post?

Hi I have the following code that saves and prints just the visible tabs in a workbook, but I want to change the code so that it only saves and prints the first two tabs only could do with a little help if possible :) Sub SaveShts() Dim Ws As Worksheet Application.ScreenUpdating =...

Greetings, I have a macro that creates a new workbook and saves it with the file name composed of a number in cell A09. ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\TDN Forms\" & Worksheets("Rev #").Range("AO9") & ".xlsx", CreateBackup:=False How can I insert a prefix to the file...

My coworker has built the code and I'm only trying to save it to a specific site, this is the code: Public Sub SaveAs_TL_ETI_Y() Dim NewBook As Workbook Dim varResult As Variant Dim E_F, E_SN, P_PN, P_SN, D_F As Variant Dim FName As Variant Dim LockBook As Workbook 'Saves TL_ETI_Y as new...

I have a Macro setup that saves the worksheet as PDF and attaches to an email, At the moment the PDF saves to desktop, however I'd like to modify the code to have the PDF save to the directory in which the Excel file is located. Any assistance would be appreciated. Title = "Transport Booking...