Ok - So I posted this code in another post and my question was answered. That fixed the initial issue but I am now running into a new error. I also keep coming across different posts that lead me to think there's a way to do this cleaner. My code is erroring out on this one line: For Each ws2...
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...
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...
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...
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...
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...
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 =...
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.SaveAs FileName:=FullName, AddToMru:=True
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...
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.
Is there an easy way to have this macro save the file Text_on_XY.scr in the ActiveWorkbook.path?
ActiveWorkbook.SaveAs Filename:= _
"H:\Text_on_XY.scr", FileFormat:=xlTextPrinter, _