saving

Option Explicit Dim wb As Workbook Dim ws As Worksheet Dim ws2 As Worksheet Dim rng As Range Dim r As Long Dim i As Long Dim er As Long Dim c As Range Dim sht As Object Dim wb2 As Workbook Dim fname As String Dim fpath As String Sub printshts() Set wb = ThisWorkbook Set ws =...

Hi, I have a VBA code that loops through different files, making changes in them and then saving the files. When saving some of the larger files, I have a problem that the Saving dialog box will not close. I save the following way: Application.DisplayAlerts = False...

Hey I was hoping for some help with a little problem I am facing. I have a data set which is roughly 120,000 rows & 26 columns. I need to split these into individual workbooks 1000 rows each copy and paste them into a new excel and save them into a folder on my desktop called product split...

Hi All, Ive searched and searched and cant find an answer to my query. If it has been answered already please point me in the right direction. I have a shared excel workbook where multiple staff could be in at the same time. Staff input and update data via a userform. To populate the excel...

I have a small section of VBA code (as part of a larger macro) which takes some of the pages of the report I'm working on and saves them to a new file. Dim wb As Workbook Set wb = Workbooks.Add ThisWorkbook.Worksheets(Array("Page 1", "Page 3", "Page 4", "Page 6", "Page 7")).Copy...

I've seen some posts on how to save a file as macro-free workbook. But all of them result in currently open file becoming the new one. What I need: 1. run the macro in currently opened xlsm file 2. save entire workbook (multiple sheets) as xlsx (macro-free), without opening xlsx - I don't want...

I've had this problem show up before and I don't know what causes it. I expect CTRL+S to save the workbook but instead, it's putting it into full screen, hiding my headings, and hiding my tabs... How do I fix this?

Hi all - thank you so much with my previous question (literally saved me hours each month!) Question I have an Excel Workbook that exports standardised reports each month directly in to a fresh PowerPoint file. This works great, but the problem I have is that I suddenly have 20 open PowerPoint...

Hi All, I have a control (Dashboard) workbook/sheet that runs a filtering macro on one report and splits it out to the required fields based on the sort options I have put in. To open this I use Sheets("DASH").Select PathName = Range("K4").Value filename = Range("L4").Value...

Hi I hope someone can help me I currently have to copy and paste a master copy of a workbook every day and rename it to the current date I.E 01.01.20 but I am after a button I can press that will automatically save the workbook 356 / 366 times naming all the workbooks a different date is this...

Hi. I am trying to save information within a textbox, to a .txt file, to a spesific folder, without using dialog (this button shall basicly autosave the information within the textbox to a folder, with only saying something like "Submitted" when its done) I have only used...

Is there a way to publish an excel document so that you can still interact with it, not just saving as a pdf?

Hi all, I am trying to check for all sheets if specific call E10 is empty and it prevents user from saving. Currently it is only working on the sheet that i am on. It does not work on the others, i want to make it that it checks all check for a specific cell before saving. This is currently...

Hi I would like to disable version saving in the current Excel product. This feature has caused me issues. For instance: If I want to open an Excel spreadsheet and work within it without altering the file, I do not want to have to search through versions/dates to find where I started to revert...

How do I disable the popup that says Excel is "SAVING AS" with the bar that shows % complete? Application.DisplayAlerts = False doesn't seem to help. Application.DisplayAlerts = False ThisWorkbook.Save txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")...

I have a file that I am using as a template for divisions to retrieve productivity report. So when user opens (Read only), he then logs in and their particular division(s) data will open. Since it is read only. I t prevents people from saving over the file so all can use as a template and I...

Hi, This code I have to add new workbook > copy data from active sheet to Sheet1 of new workbook then save runs slow. Private Sub SaveSheet() Dim WB1 As Workbook, WB2 As Workbook Dim WS1 As Worksheet, WS2 As Worksheet NUMBERA = Sheets("Main").TextBox1.Value LR = Range("A65000").End(xlUp).Row...

Hi I copy a range from one workbook, then creating a new book to save this data in. I’m trying to save this newly created workbook to a directory and name the workbook as a value of a range in that newly created workbook. That is range(“G1”) which is a date in Excel numeric (43735). My code for...

I just went from 2010 to 2016 and have some programs that I created a few years back and they are all from 950kb to 1400kb and are all macro enabled worksheets. I just finished a new one in 2016 almost the same thing but with less sheets and macros but now find that is saving at 81,147kb and...

ChDir "C:\Users\frank\Desktop\OCIP" ActiveWorkbook.SaveAs Filename:="C:\Users\frank\Desktop\OCIP\LCP.xlsx", _ The file I am saving is called LCP. I would like it to be saved different every time with today's date on it every time I save it. Something like this LCP - 08-23-2019 Also if it...