save as and close

In the following code, i am trying to adjust so i loop through all the files on a tab, and if the range has formulas to convert it to value. But only for the specify tab. Before closing and saving the file, i want to save it as the current name and add in the end " _v2". Can someone help on...

Hello everyone, I have a macro that opens another excel file, makeschanges in that file and should then save and close the document. Currently I am using this line of code for saving and closing the document: WB2.Close SaveChanges:=True By using this code it is doing save as meaning it opens...

Hi all, I have the following code, but this saves my workbook to C:/Documents.. is there a way to make it save to the same folder, my original file is in? I have this Workbook full of macros and code which allows data manipulation efficiently sort of a 'Raw data converter', and this last macro...

Hello, I'm trying to copy every sheet in workbook as separate file (on X drive) with the name of the sheet with below standing code. It now creates a single file with the name %20&%20ws.name%20&%20 including all sheets. What goes wrong here? Thank you, Hans Grandia (Netherlands) Sub...

Trying to figure out how to create a prompt to rename and save CSV file in current macro to a specified directory and close. Any help would get me over this hump so I can move on in this project. Dim main_size Dim EndLine Worksheets(1).Activate...

Hello Does anyone know vba code to bring up a file Save As dialogue box when the user comes out of the file? I have been looking around for the code, but no matter what I put, nothing is happening and the file just closes when I click the "x" at the right. Thank you Mieke

Firstly, thank you for the invaluable information I get in here. I am no graceful in my macros but they work so i can't complain. I have 4 Questions I have a purchase order macro. Command Button is clicked and it opens a workbook and saves selected cells to next available row and saves workbook...

Hello All, I am still in the process of automating my workbook and am trying to work through the kinks of learning how to use VBA to do so. At this point I have the following code that I use to parse out the data for individual account managers and copy and paste that data to a new tab, then...

Hi everyone, I just stumbled upon a topic which seems to not have been discussed yet, although it is very ineteresting to me. Situation is: I have a file (an order form I created as an Excel sheet) for which I threw together a rather beginner level of VBA code. Task was to make four...

Hello, I am trying to piece together a macro for a WorkBook where the end result would be to copy a form on Sheet"InnoluxRMA" to a new workbook and save it as "InnoluxRMA_{DyanamicRangeValue from Sheet"List"}_DateStamp. Sheet"List"'s data will always be column A, with a header row. Right now I...

Hello, I'm trying to make some code that will let me select the active workbook (which is a txt file) and save the first worksheet page (the only page with data in that workbook) as an excel file, then close the file. Would it be possible to code that so that no file names are specified...

hello, I would like to save individual worksheets. I have 6 worksheets. In 4 of them do if the CommandBox Save is clicked, the Save as window will open and the leaf should then be saved under the name of the field is in G10. urgently need this VBA code hopefully you can help me Jannik

Hi, I have Excel 2010, and I'm getting an error message when I press the Clear and save button while using my invoice on my computer the error that i get is 400 i want the macro to save the invoice as (for example) invoice # 31254 and once it saves i want it to close automaticalluy the...