save & close

I have a workbook with a connection. I have gone to connection properties and set it to refresh periodically in the background. But I don’t know if it saves the document after the refresh. I don’t think so because the time of last modification of document doesn’t change. So I’m trying to...

I have a VBA program that loads a pivot table into a VBA array. The program then creates various spreadsheets required. It opens a new excel file, populates the data, then saves the file and closes the file. The program creates circa 270 excel / CSV files. However, just recently we have run...

Hi, I have a vba code that needs to copy an array of sheets from one workbook & paste as values to another workbook & save the destination workbook as either xlsx or xlsx. Below is the code: Sub SaveSheetsAsCSV() Dim ws As Worksheet, ws1 As Worksheet Dim newWorkbook As Workbook...

Hello, I have a data analysis project to roll up multiple individual, macro-enabled Excel workbooks with tables and formulas. Each workbook contains 31 individual sheets (one for each day of the month). The 31 individual day worksheets each contain nested Excel tables with formulas and are...

Hello, I'm really new when it comes to excel, and are really just trying to piece together strings from different forums alongside trying to learn. I'm trying to Save a Copy as a CSV file, without the need of choosing a file-name or path - I really just want the file to appear in the correct...

Hello all, I have done much digging in order to get this far but I'm still in little bit of a pickle. I am trying to make it so if a cell I have has a specific number form that it will save to a specific folder. In the Cell (L1) I have the date set as "mm-dd-yyyy hh-mm" and machine number ("11D...

I have the following code: Sub addwb() Application.ScreenUpdating = False Dim wbNew As Workbook Sheet1.Copy Set wbNew = ActiveWorkbook wbNew.SaveAs "C:\Users\Owner\Documents\Automation\TestWB.xlsx", 51 wbNew.Close True End Sub but I am prompted if...

Hello all, I have a workbook that will open multiple workbook and edit the data before saving and closing them. I'm now needing to save a copy of the first workbook under a new name in a new file path before I make any changes. The file paths of all workbooks are changing everyday, and as...

While executing the following code I always get a message that "MS OFFICE EXCEL HAS STOPPED WORKING... ...... CHECK ONLINE FOR A SOLUTION...... CLOSE THE PROGRAM TO RESTART ......." Request to guide Private Sub cmdLogout_Click() ActiveWorkbook.Save ActiveWorkbook.Close...

I'm wanting to log user inputs from one spreadsheet to another one that would be closed. It just needs to paste to the next available row. I've scoured the internet and am having trouble finding something that works. The below code will open the workbook but isn't copy/pasting the info or...