close

I need a code please that will open some files within a folder and insert a column in AD with a header of Eurostd and close and save. Is this possible please? Thanks

I looked and could not find how to edit an existing post, in hopes of making it read better, but cannot find that option. If you could point out where this button is or how to close out the post so I can retry would be appreciated. Much thanks.

Hi, In one of my workbooks, if I try to save it after changes, I am not prompted. The workbook just closes. There are no macros in the workbook. How can I turn the prompt back on? I close the workbook and it just closes which is annoying. Thanks

Is there a way to have an Excel 2010 workbook to open and save and close each day by its self? Thanks

Hi all! Not really sure what supporting info to provide but I have a spreadsheet that has a rather odd behaviour. The workbook has a lot of formulae and a sheet that has over 7000 rows. That sheet has about 10 columns of formulae which include INDEX/MATCHES referring to a couple of tables in...

Sub isAnyWorkbookOpen() Dim wb As Workbook Dim wbs As Workbooks Dim msg As String Dim Result msg = "The following workbook(s) must be closed before continuing:" & Chr(10) & "Do you want to close?" & Chr(10) & Chr(10) Set wbs = Application.Workbooks...

I am trying to sum the total number of player scores (usually 10 players) for a particular team (1 of 60) in a particular week (1-26). This formula will be copied down about 200 rows for both Home and Away Team, across 4 divisions. I'm close, but not close enough! =SUMIF('All...

This is a question I am struggling with to help one of my students.... In the Profit - Loss Summary worksheet, in the cell D8, use the If function to show Close if the SUM of C9:D9 is greater than22500 and Not Close if it is less than or equal to 22500.

I have a file of 160 golfers. There are 80 couples with varying levels of handicaps from as low as 4 to a high of 17. I want to be able to make 40 teams keeping the spouses together so that the resulting total handicaps per 4some is around 50. Unfortunately there are some couples that each have...

Im having a hard time with VBA editor, it shows me some errors sometimes, and sometimes don't. Mostly, I got error " Can't find project or library" and what i had done so far was deleting the error file and tried to recover the previous version of the file before. I could find any missing items...

Evening Is there a simpler way to perform this action. and possibly center align the offset value without a new loop. Thanks guys :) Dim r As RangeSet r = Range("Z3", Range("Z" & Rows.Count).End(xlUp)) For Each c In r If c.Value = "AmountPaid" Then c.Offset(, 8) = "Close" If c.Value = "Amount...

Hello i am getting Msgbox Error Twice when i close the userform Can someone check and help me to get rid of the MsgboxError when i close the userform Basically if the date is wrong for which I puroposely incorporated Cancel = True in the If EndIf so that textbox1 is set focussed but when i...

Hi, I have a simple macro which just clears some data in a couple of cells. The macro code is shown below. Once it is run i am then unable to do anything with these cells. If i save,close the worksheet & then open again it allows me to add values etc but as soon as i run this macro again back...

Hi all I’m looking for a vba-macro that will pop up a warning after 5 min inactivity and then save & close if still idle after 5 more min. Ideally the clock would restart after the pop up is close. Thanks in advance/ Office 2016 if it helps Cooky857

Hi all I’m looking for a vba-macro that will pop up a warning after 5 min inactivity and then save & close if still idle after 5 more min. Ideally the clock would restart after the pop up is close. Thanks in advance/ Office 2016 if it helps Cooky857

Good Morning, I wrote this piece of code to attempt to close excel if the userform "X" is used to close the userform. Basically the userform opens when excel does and asks for one of two buttons. If neither button is pushed (i.e. someone closes the userform), then I want excel to close...

I have a WB that opens and if left open for 2 minutes runs the macro below to close it. But if I close the workbook before two minutes it still runs the macro and for some reason reopens it and then closes it. So I tried to stop the second macro from running [WbCls] by checking to be sure...

I am trying to save and close a specific open workbook without prompts. Why does this not worK? For Each Workbook In Workbooks If Workbook.FullName = "ExcludedWo.xlms" Then Workbook.Close (True) Next Workbook

Hi all This is really foxing me and I'm hoping someone can help before I pull all my hair out! In 2013/2016 creating a new workbook will leave the focus on ThisWorkbook even though it is the ActiveWorkbook, and I cannot seem to get around it. The reason this is causing an issue is that in...

hello- I have a button that saves the workbook (code below). Irregardless if I save the workbook using the button (which works), when I go to close the program, it still asks me if I want to save (excel generated, not me). How can I get it so I don't have to save twice. I'd like it so that if...