save as

Hi all, I'm using the following piece of VBA in outlook to save a file when it is received automatically however the file is unusable. If I don't change the name of the file when saving in the directory it is ok but because the file names can be different at times the VBA changes the file name...

I have a piece of code which copies a worksheet from an Excel workbook and saves this as a text file with the file path and file name being dynamically pulled from two cells. I want to know how to adjust this code so when the file already exists a new version will be saved. Ie: Initially the...

Hi all. I hope you can help. I have a piece of code. Essentially what it does is, it opens a dialog box that allows a user to select an excel sheet, then it goes out to the country column (11) filters it, then copies and pastes that country into a new workbook, names the new workbook after...

Hi Everyone, i would appreciate for this, I require a vba when I save it should just save the file and when i press Save As it should run some procedure and prompt a dialogue to Save As file. Thank you in advance.

Sub saveFiles() Dim sf2 As Workbook sf2.SaveAs "C:\Users\Desktop\TEST\" End Sub So far I have something like this. I want to save as excel workbook to different path, but same name. Is there any way to solve this? Thank you

Hi all, I had this code working great on my PC. When converting to mac, it will create the text file but fails at the "save-as". I have the newest excel for mac. Can any give advice? Here is the Sub ExportCSV() ' ' ExportCSV Macro Dim MyPath As String Dim MyFileName As String 'The path...

I am looking for a macro that will populate the save as dialogue box to a specified file path and with a custom save name based on the cell value of (d4) of sheet2 . I want the user to be able to review one last time and manually click the save button. In other words, I want the populate the...

hey all, Have some code that saves the one sheet as a new workbook which is cool. However I’d like to utilise a For – If loop to save every worksheet in that range to a new workbook. Sub SaveSheet() ' 'Save single sheet as new workbook ' Dim rcell As Range Dim Background As Worksheet Set...

I have two sheets (Sheet1, & Sheet2). Sheet2 is a template that has multiple vlookups connected to Sheet1. What I would like to do, is go through every single row (A2, A3, etc) from Sheet1 & paste it into Sheet2 Cell C5, and Save As the text from A2 in Sheet1. Not having much luck, and was...

I'm trying to create a macro button in my Excel spreadsheet. I can create the button, I just need the code. I need the 'Save As' dialog box to open. FileName to be the text located in "J15" , the file path to be linked to "K61", and the file type to be ".xlsm" Can anyone help that knows VBA...

Hi guys, I'm pretty new to VBA. I know there are some similar threads on here which have similar issues, I've worked my way through them and I'm still at a loss as to why my code won't work. I'm trying to create a button which will save the workbook to a certain location using the contents of...

Hi all, I have googled it, and I have been through this board and found similar questions with answers that are close, so I apologise if this is already covered but I cannot fins a solution that works. I need a bit of help though I have a Microsoft mail merge doc, can have 3 data records, can...

Sub SAVEasCSV() ' ' SAVEasCSV Macro ' ' Keyboard Shortcut: Ctrl+Shift+S ' ChDir "F:\C Store Shared\Credit Cards\Tesoro Connect CSV Credit Card Files" ActiveWorkbook.SaveAs Filename:=Range("A2") , FileFormat:=xlCSV, CreateBackup:=False End Sub Trying to save as the date in cell...

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 =...

Hi, I have a macro (code below) that runs when a button is pressed. It opens up the save as dialog box and restricts the save as type to marco-enabled workbooks. Sub save() varWorkbookName = Application.GetSaveAsFilename( _ fileFilter:="Excel Macro-Enabled Workbook (*.xlsm), *.xlsm")...

Hi, I have a template that I would like users to fill out and then save as a new file name. Quite a lot of the users aren't great with excel and I don't want them to just save the template, I need them to save as. Therefore, I'd like to have a button with an assigned macro that they can press...

Dear Gents, my code as following Dim MyFile As String MyFile = ActiveWorkbook.Name Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:="D:\E-DRIVE2\1234567\Logbook\2016\" & MyFile End sub my current file name is "LogBook July" My question are...

I have a sheet with several workbooks. The aim of the sheet is to generate a text of a letter automatically depending on a lot of parameters. In one of the workbooks I have the result in column A. lets call this workbook corrections The content of the cells in letter_text might be in English...

I have a file that is distributed to many users. I need to embed a VBA script in the file that when run opens the 'Save As' dialogue box to a specific folder location BUT does not save the file. The users will need to select a sub-folder within the primary folder and enter the file name in...

Hello, I need a macro to act differently on events Save and Save As. There is Workbook.BeforeSave functionality in VBA, but is there something like BeforeSaveAs? Or is there a way around? Thank you.