saving

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

I have a standard report which I need to sort in the same way everytime. Is there a way to save the "sort" sequence and apply instead of re-creating each time? Thanks in advance!

Folks, I wrote some VBA code to save files with a certain naming convention. However, the overwrite warning is not showing up and I would like it to. Below is my code. Thanks! 'save as dialog Dim fname As String fname = "Wafer " & WID & ".Ellpis." & ReadType & "." &...

Dear All, I have seen the great value of this website I'm not really experience with VBAbut relaying too much on MREXCEL i'm adding a code to for a button on the excel so when you click on it It should openthe saving as box with a specific name reading form a cell I found the acode but my...

Hi everyone Really hope a genius could help me :) I'm using the code below in a command button to save a particular worksheet in a new workbook, however I am trying to achieve 2 things, please could someone help me? 1) How do I only paste as values only but while also retaining the formatting...

I'm sure you've seen this subject before but I am pulling out my hair. Excel is getting worse and worse at hanging while I'm using it. I'm using Office 365 with a Windows 10 PC, stand-alone. I'm also using OneDrive and just a hunch that it is playing a part in what's going on. BUT it will also...

Hi all, Need your help here. I know how to create a form. Control T and such. But how can I customize the form. Make it bigger and color it. The form would be use to input data. Only completed data will be saved. But before saving, there will be a requirement to enter the next set of...

Hi all, Im not sure if this possible but any ideas would be amazing! I have a sheet that is used by a colleague of mine and she keeps accidently saving it in random places which breaks all of the external refs. Is there a way to set the sheet to only be able to be saved in one location? Im...

Working inExcel 2016 - I typically have anywhere between 5-9 workbooks open at one time,working in them all simultaneously. I amtrying to figure out how to not have them linked in a way where if I save one workbook that it doesn’t freeze up the other workbooks(showing the action of saving the...

Hi All, Just curious is there a difference in saving in Developer mode to saving in Workbook mode? The reason I ask is I was working on a (for me) complex VBA script and would meticulously click the "Save" button in Developer EVERY single time I made a change. I had to run an OS update (on my...

It can be enabled manually with tools - autosave and then clicking the appropriate radio buttons. But you have to remember to do it, and it lasts only until you quit Excel. Is there a way of having it turned on permanently, or of enabling it by using VBA? I tried recording a macro but it gave me...

Hi All, Since receiving a new laptop from work, a macro that I run has consequently started saving files in "protected view" (with the red bar along the top to say everything is disabled). This means that I am subsequently having to open each of the files that are created in order to select...

Hi everybody Been away for a while but lucky enough to just get a new job, hoping someone can help me out a bit on the last part of a VBA project. Using Office 2010 I have been working on some code to save selected sheets in an excel workbook as a named PDF document. The name is a cell value...

Hi All, Any help appreciated I have a Excel file, which contains VBA, Userforms etc - everything works fine.... However when anyone opens it, as it sits on SharePoint (I think that is why it does it) it opens in read only and you have to click the "Edit Workbook" button in the ribbon. Can...

Good Morning all, I am working on an Energy calculator and as part of the customer facing end I want to show a graph that shows return on investment. For this graph i need to show the current energy cost along with the savings the client will achieve using our products. The problem i currently...

My file is saving the entire name when it converts to a PDF. I am simply trying to get the .xlsb part to drop off. Can anyone help me understand how to code the removal of the .xlsb from the Filename or Populate the save as name as one I choose? I want to use this base code. Sub...

Hi forum, I have created a macro button that when pressed it saves the current worksheet as a PDF. This works great except the only thing I do not want to appear on the PDF is the button itself. Do you know of a way around this please? Other than having the button on a different part of the...

Hello. I'm trying to prevent the users from saving the file as a new one if they have left some cells blank. What syntax do I use? Thanks!

Hi, would it be possible to have a warning box pop up to prevent saving the PDF over an existing file? Also, can we have the box show the existing filename and be able to change the name and then save it? Thanks Sub DETAIL_PDF() Dim response As String Dim PrintAreaString As String...

Hello everyone! I would kindly ask you for help with macro which would save file #1 with name of file #2 .