saveas active workbook.

  1. L

    .SaveAs doesn't initate 'Workbook_BeforeClose' ?

    Hi all, I am working on a macro that makes users click "Enable Content" mandatorily to access the workbook, works like a charm, except I have a macro which does a .SaveAs under a different name, and it automatically closes my original file, but doesn't initiate the "Workbook_BeforeClose" code I...
  2. M

    Created Macro to save file dynamically failing

    Hi there, I have created a macro which saves a sheet from a workbook in a location that that changes daily. This is captured in the macro by using formulas in excel. The macro seems to create the file as expected however I get to the following line and it fails to save .SaveAs...
  3. C

    Macro to save 4 other open workbooks

    I received great help from Fluffy yesterday. I've been working all morning and just can't figure this out, its a mess. I am a beginner and putting in time to learn but running out of time. It doesn't help that I am not the sharpest tool in the shed. I appreciate any and all help. I want to...
  4. J

    VBA Saveas using a filepath as specified by the user

    Good afternoon. I have been going round in circles trying to find the VBA code I need to perform a certain function, however, I have been unable to find it, so I am hoping all you experts will be able to assist me. I have created a general ledger journal and I want to assign VBA to a button...
  5. FalconBLUE

    Backup Macro Codes...

    Hi everyone, I want to backup my workbook with below codes. First of all, codes are checking backup folder whether or not. If not the folder, being created in C:\ and then being identified. Finally, this code must saveAs active workbook. But not. Where I am making mistake I don't know. Could...
  6. S

    saving a .xlsx as a tab delimited text file

    I have a spreadsheet that I need to convert into a tab delimited text file. I am writing some vbs code in notepad++ and I just cant get the last line to work, everything else runs perfect, but I just cant get it to save as a tab delimited text file :/ Set ExcelObject =...
  7. K

    Issues with Saveas on activeworkbook

    I have the following VBA code in a before save event ' check if file exists. if yes save else saveas Application.EnableEvents = False If Len(Dir(FullName)) > 0 Then ActiveWorkbook.Save Else ActiveWorkbook.SaveAs FileName:=FullName, AddToMru:=True End If...
  8. J

    I need VBA to save file and attach file to email based on conditional statements

    Good morning! Well I've been handed the task of taking an Excel form that works well, but expanding it to be a hybrid form that will take care of other needs/forms as well. The developer who created the original form no long works here, so I'm taking my rusty VB skills and trying to...
  9. F

    VBA - EXCEL -NEED HELP Renaming file in same path

    NEED HELP!! VBA - EXCEL -NEED HELP Renaming file in same path + text addition Hello and thank you for reading/responding. I am using the current code to save as CSV to XLSX. BUT- this is renaming the file with the TEMP<CURRENTFILENAME>... AND placing on my desktop. With Activeworkbook .SaveAs...
  10. G

    SaveAs location to ActiveWorkbook.path

    Hi all! Is there an easy way to have this macro save the file Text_on_XY.scr in the ActiveWorkbook.path? Sub Text_on_XY() ActiveWorkbook.SaveAs Filename:= _ "H:\Text_on_XY.scr", FileFormat:=xlTextPrinter, _ CreateBackup:=False End Sub

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top