saveas

I have a macro that opens several files, calls a macro, and needs to be able to save the file as a new name once fixed. The code I need should notify the user they are about to save the file with a new name if an error was found. If Sheets("ErrorSheet").Range("A2") = "" Then MsgBox "There...

I've been trying different macros to get excel to save as the file with the current date as the filename to no avail. Currently the code I have in my Workbook is this. My issue is that it just doesn't appear to do anything. Whenever I click SaveAs it just tries saving the file as its current name

Hello! I have created an xlsm file that contains two worksheets. One of them is a locked down form that contains a list of options and pricing for our dealers. the top row is frozen and has a print, save form, email form, and reset button. The problem I am having is with the save form button. I...

I have a Spreadsheet that has Read Only Recommended. When a user wants to Save it, I want a new Filename entered by the user, and to make sure that the Read-Only Recommended status is switched off (i.e. Read-Write always On) Although my users can do this by File-SaveAs, most of them forget to...

I wanna overwrite my active workbook Any ideas? Application.EnableEvents = False filename = Application.GetSaveAsFilename ThisWorkbook.SaveAs filename & ".xls" ThisWorkbook.Saved = True Application.EnableEvents = True I have this few lines of codes.However , it...

I'm working on a .NET program to interface with Excel. The code looks like this: private static void ConvertToXls(string xlsxFn, string xlsFn) { var Excel = new Microsoft.Office.Interop.Excel.Application(); var wkb = Excel.Workbooks.Open(xlsxFn, false, true)...

I have some code that updates a bunch of data from another sheet now I want to add in to automatically SaveAs and have the file name automatically added from a cell. I have most of it working except the characters I am copying are formatted MM/DD/YY and the "/" cannot be a part of the file name...

Hi, I have a multisheet workbook that I am trying to export out to individual csv files. Within the worksheet I have a column with VLOOKUP values. When I SaveAs from the file menu, everything is perfect! However, when I export to csv from vba - I get the #REF! values where my VLOOKUP should...

I have two macro-enabled templates and I want to force save as macro-enabled workbooks. The following code works fine in one template but not in the other template. Any ideas why it won't work in both templates? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)...

Hello, I have a bit of vba code that saves a copy worksheet from my workbook as a .prn (text file). See code below. This code works well from the macro enabled workbook, but it does not work from a macro enabled TEMPLATE. Any ideas? Code; ' Save sheet as .PRN file Sheet5.Select...

Hi All, I am no expert on vb code and usually get by by pasting chunks of code from forums and tutorials etc. The first part of my macro, for information/ context is as follows: A .csv data file is opened and a macro started, which does the following: Open a template .xlsx file (which is...

I have a workbook with several worksheets. The sheet I want to save has data and/or cell formatting across the range A1 to LP46. I'm using this VBA code from a button within the worksheet to save the same worksheet: ' Copy just the current sheet ActiveSheet.Select...

I am working on automating a report download through IE9, using a VBA Excel macro. I read many threads about this topic and had to compose between several, to adapt it to my situation. Basically the automation navigates through several pages, checks options, and clicks on a download button...

I have a project I am working on where I would like to save one of the sheets in my workbook as a .csv document. Below is the code I am currently using: Sub myExport_Click() Dim ws As Worksheet Set ws = Worksheets("Export") ws.SaveAs Filename:="myExport", FileFormat:=6 End Sub This...

For Each objAtt In itm.Attachments If InStr(1, objAtt.DisplayName, ".jpg") > 0 Then '<-- will save if this is gone stFilename = saveFolder & "\" & itm.Subject & "-" & dateFormat & ".JPG" i = 0 Do While Dir(stFilename) <> "" i = i + 1 stFilename = saveFolder &...

Hi, I have a number of users using the same Excel template in folder A and I would like to have all users save their projects to folder B without being able to delete their own or others projects. I have tried to limit the users rights to “write but not delete” via security features in Windows...

Anyone have a list for all of the file format numbers? I've done some poking around on the interwebsbut have only come up with the following... <o:p></o:p> <o:p></o:p> FileExtStr = ".xlsb": FileFormatNum = 50<o:p></o:p> FileExtStr = ".xlsx": FileFormatNum = 51<o:p></o:p> FileExtStr = ".xlsm"...

Hi everyone. I have a macro that goes through a bunch of emails and saves them into my temp folder. Every now and then it hits an email that when it tries to save it as an mht file I get the error: "Microsoft Office Outlook A file error has occurred." Obviously not too helpful. Here is the...

I have this code that is suppose to go to a directory and allow a user to define the file name and save in that directory. The only problem is, the code do not give an error of any kind and after you attempt to save and follow the path to where the file should be it is not there. I may have it...

Hi Guys, Usually I can find answers by searching the site, but couldn't seem to find an answer to this one.. Any Ideas as to why this VB Code is resulting in the Clicked SaveAs action dumping the file into the "*******s" part of my File path rather than into "1 QUOTES" Which is where I need it...