activeworkbook.save

Here is a macro I recorded. I need this to paste values only in the new sheet. The blank cells must truly be blank and not with a formula in them. The online webpage I upload this to will return an error if there is data in the blank cells. Thanks for your help Sub MBMexport() ' ' MBMexport...

I've seen a couple of things close to this but this is a little odd. I have a password protected file "Mater File Links" Its protected from the general public (of this office) The way the data is entered is through another Workbook. Before I was forced to protect the "Master File Links" the...

Hi, I am trying to let Excel save active workbook just before my paste as values code, however I can't figure a way to store the clipboard before the Activeworkbook.Save event, and after the event the clipboard is lost if it is consist of data from another or current excel sheet. It is no...

Hi, I have the following code; Private Sub Workbook_BeforeClose(Cancel As Boolean)Dim ws As Worksheet Sheets("START").Visible = xlSheetVisible Application.EnableEvents = False For Each ws In ThisWorkbook.Worksheets If ws.Name <> "START" Then ws.Visible = xlVeryHidden End If Next ws...

Hi, I have a macro which runs when the workbook is closing where I can create the filename. Sub shiftchnage() ' ' shiftchnage Macro ' FileName1 = InputBox("Input filename ", "Filename") ActiveWorkbook.Save ChDir "c:\" ActiveWorkbook.SaveAs Filename:="K:\ESS- 2005\Production Meeting\Daily 6...

I have a long macro that works great every time I run it except if I try to save at the end. If I put ActiveWorkbook.Save at the end it skips the code in front of it and just saves and does nothing else. What would cause this? I'm using the latest Excel and windows 10.

I cannot get the macro to work as I want. I cannot get the MsgBox "Check Columns H and AA before Saving and Sending" to come up if No is Selected if I use the code below. Code Showing No MsgBox Sub SavecheckCL() ' ' SavecheckCL Macro ' ActiveWorkbook.Save Dim AnswerCL As...

Hello All, and happy belated Thanksgiving, I have a workbook with about 20 sheets, most of which are protected. I have a Main sheet with a "Log In" command button, and based on what password you enter, you're given access to certain sheets. With that said, it all runs perfectly. And I have a...

Since upgrading to Excel 2016 my spreadsheet now saves files to a new filename in the same folder but with an unusual filename in the format "DC3E7000" or similar with no file extension. When I change the file name to have an XLSM extension it opens and displays the saved data. The original file...

Hi, Can someone assit me by looking over my code below or alternativly at my workbook & make any suggestions as to why it won't execute when the file is shared? This is my first attempt at VBA & I'm stumped! It is part of a 'Scan in / Out' time capture workbook that I've written up. Reason is...

I would be VERY grateful if anyone could advise on the following. I have a sheet used by multiple users (usually on a remote network) - the file works perfectly for 75% of users by will not allow other users to save the file. The Macro i use is: Sub Macro12() ' ' Macro12 Macro ' '...