saving

  1. C

    Excel 2013 VBA - Pauses on Open and Save Files - Cancel to continue

    Hi all Ive got a bit of a strange one. I have a macro which opens various files, and saves them. Occasionally on opening or saving, the macro seems to pause where the opening/downloading or saving dialog box appears (the one which shows progress on downloading/saving). The only way to get it to...
  2. J

    Personal macro book save

    Saving personal macro book in VB Editor by: Select "File" then "Save" Personal.XLSB. However when going to the folder for the personal macro book: C:\Users\jjohn\AppData\Roaming\Microsoft\Excel\XLSTART The saving date of the personal macro book has not been updated to todays date. I some...
  3. B

    Excel 2010 data validation drop-down list disappears

    I'm having a rather perplexing issue with data validation lists on excel 2010 intermittently disappearing/breaking after a file is saved and reloaded. Every now and again after saving and closing my workbook, one or more variants of my drop-down lists will break. The arrow to select the list is...
  4. T

    Macro to stop a Workbook being saved anywhere but its current location and name

    Hi Everyone, I need help, once again despite my best effort people have suppased my expected level of stupid. Whats happening is they are opening a document then saving a copy in a different location. I've gotten past the problem of them doing this in the folder by using a shortcut and saving...
  5. E

    Prevent Saving

    Hello, I'm wondering if there is a way to not allow saving in the workbook if the user has not changed the answer from a validated list? I have Yes, No, and Provide-Answer in the data validation list and some VBA code that does not allow saving with an empty cell but I couldn't save when it was...
  6. E

    How to Create a Validation List That Reqs an Answer Change and Selection in Order to Allow Saving

    Hello everyone, I have just recently begun using Excel more frequently as well as VBA and have run into a problem with something I am trying to do. I am creating a form where I have created a cell validation in multiple series of columns. Most were just Yes or No available from the list I used...
  7. J

    Saving as PDF ? ANyone know why this code is saving as a PDF ?

    Sub saveworkbook() Sheets("Details").Select ActiveSheet.ExportAsFixedFormat Type:=xlsm, _ filename:="C:\Users\James\Documents\Excel Test Folder\Quotes Invoices Spread Sheets\_" & _ Worksheets("Details").Range("C6").Value & ".xlsm", _ OpenAfterPublish:=False End Sub
  8. D

    Coding help please - Looping through drop down lists and copy/pasting contents into new workbook, saving

    Hello, My first post, please be nice My coding skills aren't great, but otherwise very well skilled in Excel. Hoping somebody can help, I'm stumped. I have a workbook with tables and charts that are populated from another worksheet (in the same workbook) using lookups. There is a...
  9. K

    Suppress Saving Dialog

    Hi guys I hope you can help as I have been scratching my head a bit! I have code which opens, updates, saves then closes two different work books. I already have used the below snip to stop the screen flicker but i also want to stop the saving file dialog from appearing. This is to prevent...
  10. D

    Help Needed in Saving a Comma Delmimited File

    I am working with a list that I am copying into Excel. I need the list to end up in a text file with a comma and a space after each record. After saving the file out of Excel into a comma-delimited file there is no comma after the records. Am I doing something incorrectly?
  11. J

    Time zone conversion

    Hi guys, I've been Googling this and can't seem to find an appropriate answer. What I am looking is for a way to bulk convert Times from Pacific Timezone (PST/PDT) into local UK time (GMT/BST). So what is needed to be known is whether the date is in Daylight Saving Time for one or both of the...
  12. I

    Userform Help

    Hi I've been looking around to see if this is possible. I have a userform for 3 different shift a day using page option. Is it possible when each shift opens the user form that the previous shift's checks and comments are there to be reviewed and when saving i don't save 2 or 3 copies of the...
  13. D

    Excel / VB code

    Dear Sirs, I am using below code in my work. Kindly please help me some one and code in below code "so that while saving file below code also run (I mean either keyboard short key or on saving file ) Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+Shift+L '...
  14. S

    "Saving..." Dialogue Box Remains Open

    Hello all. Firstly, thanks for any input you can provide on this, it's got me absolutely stumped. I've been putting together what is essentially a database in Excel for the company I work for. Before any comments, I know, Excel is not the ideal place for this (if only the company execs would...
  15. M

    VBA regional settings vs saving as CSV

    Hi All,I need your help with following case. I build a macro, which have to save the data as csv file, which can be used by other application.Everything is working except saving part. During saving as CSV I see in results file that every line of data is in quotes "...".The problem occurs in...
  16. T

    Is Ctrl + S and ThisWorkbook.Save the same?

    Hi, I'm trying to find out if there is any difference between ways of saving a workbook. I have a userform that pops up before saving the workbook. If I save the workbook using the save button, press Ctrl + S or use SendKeys("^"&"s") it is no problem. But if I use ThisWorkbook.Save or...
  17. S

    VBA saving as pdf using 2 cells

    Hi, this is my first post because i have tried scouring the forums for help and it appears my coding levels are terrible. I have a whole workbook to print, i have it saving in the required place and with a correct filename using a cell. I just need to add the date from another cell to the...
  18. V

    Saving File as a .csv and then saving in a sprecific folder

    Good afternoon all I want to be able to save a an specific sheet of a workbook as a .csv file and the have it save to specific folder path controlled by a cell (person's name ) located in the sheet. Can anybody help with this?
  19. C

    Saving to SharePoint

    Hi all, I have a button with a code to save on SharePoint (SaveAs) and it all works fine. When the process is done and the user wants to close the workbook, the system would ask if they want to save it (it shouldn’t ask as the file is just saved and no changes been done since then?) and when...
  20. Vally 88

    small excel big loading and saving time

    Hello guys, I have a problem with my excel file, this is very small 174 KB and not particularly complex in formulas, just a few arrays and simple vlookups or math formulas, but it's sitting on dropbox. It takes a very long time for taking actions as well as saving. I have deleted all the not...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top