saving

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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?

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

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

Hi, Firstly, my knowledge of coding is basic at best....i've looked on various pages to find a solution and concluded the below. However, whilst everything works perfectly, unfortunately i cannot seem to get the file to save to the correct folder. I keeps saving to my documents!! Sub...