1. R

    SaveAs method not actually saving, wrong sheets being deleted (1004 Error)

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

    VBA Saving Dialog Box is not closing

    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...
  3. S

    VBA: Split Data Sets Into Sub Sets and Save

    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...
  4. J

    Identify if shared workbook is locked by another user before running macro

    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...
  5. Richard1982

    Excel/VBA automatically opening file - can I avoid this?

    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...
  6. G

    VBA - copy file as macro free and keep the original open

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

    CTRL + S not working as expected

    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?
  8. A

    Saving all open PPT within Excel

    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...
  9. S

    How d I save a workbook from a path and file name listed in cell from a second workbook?

    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...
  10. C

    VBA Code that will save the current workbook multiple times

    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...
  11. W

    Saving data from textbox to specific folder without dialog as .txt

    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...
  12. D

    Publishing a spreadsheet

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

    If cell is Empty!

    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...
  14. J

    Excel 365 Version Saving

    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...
  15. M

    VBA Disabling 'Saving As' Popup

    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")...
  16. C

    Saving Read Only

    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...
  17. J

    This code for saving worksheet is very slow

    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...
  18. C

    Saving a Workbook using a variable to name it

    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...
  19. O

    Excel is creating very large files

    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...
  20. Z

    Need to add todays date everytime i save file

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back