save as

Hello, I want to save a file as a PDF file instead of a macro enabled excel file. Below is the code I am currently using to save to the desktop as an Excel file. I just want to switch it up now and save as a PDF. ThisWorkbook.SaveAs Filename:="C:\Personal\" & Environ$("Username") & _...

I've got some code that deletes a couple of tabs and then finished with a Save As box. Display Alerts is turned off for the second deleted tab (but I want it on for the first) but then turned back on before the Save As. The Save As dialog box comes up and when I navigate to the desired file...

Hi all, I've searched high and low for the answer to this and spent countless hours trying to figure it out, so I am hoping someone out there can figure out what is going wrong. I am putting the final touches on a big VBA project, and my final sticking point is that I cannot for the life of me...

Hi all, I am looking for to pick your brains over an issue I am having with regards to adding in an Excel button to 'save as'. Basically, I have... Created the button Edited the code so that I am only saving a selection of cells (A1:I95) and in PDF format. This saves my file to desktop, as...

Hello, I am working on a project in Excel 2010 that will automatically save a file using a specific naming protocol, based off the dates included on the spreadsheet. Right now, I have the following code working perfectly for today's date Sub Save() Dim dtDate As Date dtDate = Date Dim...

When the code below is executed it prompts the user to choose the location they want to save on their computer (also inputs a default filename from values in the sheet) and prints the range to PDF. Worksheets("Sheet1").Activate filename =...

Hello, My macro was built to loop through data of an original workbook and break out the data into individual workbooks based on the value of one field. The code works perfectly for creating the workbooks but I can not figure out how to get each workbook to save and continue on to the next. It...

Hi all, I am trying to figure out how to add a button that will save a image that was generated via the excel camera feature. Basically I am pulling via lots of slicers data together and want the user to be able to save the image in order to attach it to emails. Unfortunately there is only a...

Hi I have a sheet that I want to use as a template that is filled in via userform. I cannot for the life of me figure out why the code to save the workbook won't work, so maybe somebody here can help!! Once the form has been filled in I have a section of code to copy the template sheet into...

Hi, I for the life of me cannot figure out why the 'path will not save the file but if I use the M: drive it works just fine. I have triple checked that M:/ = \\office\group11\. I have screwed with it for hours with no luck. I continue to get a Method 'SaveAs' of object'_Workbook' failed error...

First off any input is greatly appreciated, here's what I am trying to accomplish via Macro/VBA code: 1. Copy cell A2 on tab 2 to cell $A$2 on tab 1 2. Copy cell B2 on tab 2 to cell $B$2 on tab 1 3. Copy cell C2 on tab 2 to cell $C$2 on tab 1 4. File Save As (make the save as name equal to...

Hi All, Please let me know if below is possible in VBA code. I have provided the macro below and few edits(if possible) are required in it. So the first step of the VBA is to open the provided code file. What I need is – - I need one button in the excel file, so when I click on this button...

I had a workbook which became monstrously large for no reason (100mb). I copied and paste special values the tabs into a new workbook which reduced the size to ~120kb. However now, when I copy a row into the row below, it brings up the save as prompt every time. Why is this happening?

Is there a way to save a worksheet using VBA to a text file without any delimiters like commas or tabs? I tried recording my self saving files as a way to make the code but my output is getting random double quotes at the beginning and ending of some lines. also is there a way to save files...

I'm having trouble with the following code. It works perfectly, except that it adds the name of the parent folder at the beginning of the SaveAs filename. The SaveAs file name should be "ParsedInfoData.xlsx", but it is saving as "ParsersParsedInfoData.xlsx". The name of the folder these files...

Good Evening, I'm hoping you can help me with this one. I'm using a userform to aid data entry...I was wondering if it is possible to attach to my button code something that saves the workbook as the value of a textbox, say for example TextBox1 so ... if i wanted to save it as a new file in...

I would like my users to be able to hit a button in the spreadsheet and have the Save As dialog box pop up already set to save the document as ta Text(MS-DOS).txt file but still allow them to choose the name & location where the file will be saved. Can anyone help me with the code for this? I...

Hi I am working on a document where I just want the users to be able to save only and for them not to be able to save as. Is there any solution for this?

Hi guys, These are my Subs: Sub Undosave() Application.ScreenUpdating = False Application.OnTime Now, "Undosave2" ThisWorkbook.Close SaveChanges:=False End Sub Sub Undosave2() Application.Workbooks.Open ("C:\Users\Seth\Documents\Costing Program\Process Costing\Process Costing Updating")...

I'm working in xl2010, and have a workbook with ~70 sheets. I'd like to save the sheets as individual .csvs, each with the name of the sheet. I tried using the following code: Option Explicit Sub SaveShtsAsBook() Dim Sheet As Worksheet, SheetName$, MyFilePath$, N& MyFilePath$ =...