close

Hey what I need is simple buy I am not able to perform it I am using the following Vba code: Private Sub Workbook_Open() Workbooks("close opened.xlsm").Close End Sub I need the window which contain the workbook to be closed totally not only close it at the same window I have made .bat...

Greetings! I have a shell command that uses curl to capture live audio output from a port on our call server. Sub RecordAudio() Call Shell("cmd.exe /S /K" & "curl 92.68.0.10:8888 > i:\voicetemp\voice.wav", vbMinimizedFocus) End Sub What I would like to know is; 1) how can I stop the...

Hi can anyone tell me why when I open a spreadsheet it doesn't tell me there is another user already using it until I close it down

I have the following code that separates and creates a new workbook that does not include the sheets "Main", "template" and promotes the user to save it at a desired location and exits out of the old workbook and keeps the new workbook that was created open. The code works perfectly however, the...

I want my workbook to save as two cell ranges when it closes, and if it is already named that, then to just normally save and close. Example In range D1 it has Joe Dirt In range G1 it has 123456 I want to be able to close the workbook and have it save as JoeDirt123456 Once that workbook is...

I have a sheet that goes back some years. Its a pain to view old data so I auto filter it to the current month. But other ppl access it to and mess up the filter. I am now turning off the filter at close and back on when opening. How can a set the filter to only show the current months...

I want to Merge and centre current row (row 2) with next blank row (row 3) if value is "Open". Similarly for other rows (6-7, 8-9, 10-11 etc.) Can you please provide any suitable VBA Program? <tbody> A B 1 Status remark 2 Open 3 4 Close 5 Close 6 Open 7 8 Open 9...

Hi guys Not strictly an Excel Q and I'm sure this is really simple but I am seriously losing the will to live right now!! I need a macro that will: 1. Save the already open word document to a text file with the same name but me the option to choose the file path 2. Re-save the Word document...

In Excel 2010, if I use the close workbook "X", Workbook_BeforeClose works, but if I use the application close button, it does not - why?

on trying to close one of my files, I get the "can't find project or library" message. there are no macros used in this file. I can then not open the References list from the Tools menu. I click on Tools and nothing happens. If i force close excel and then come back in using a different file...

Hi No one talk about "Workbooks.close" --> collection leve<collection level="">. I did google search and they are all talking about "Workbooks("name").close" <-- workbook level<workbook level=""> The code below, will close the first workbook no matter how many workbooks are open. My questions...

I have 4 PowerPoint Shows that I need to open, run, close in a specific order. I'd love to be able to code in each PowerPoint to close by clicking an action button and then open the next show. But I'm having trouble finding any good suggestions on the internet. So I thought perhaps opening them...

Does anyone have any VBA code that loops through say 5 open MS Access databases and enables me to close a specific one?

I'm using a Userform.show vbmodeless to float above the worksheet I'm using. I'm having to utilize form buttons to interact/transfer data between one workbook and another and I sometimes click between the sheets. THE PROBLEM: Sometimes when I click on one workbook's sheet, it seems to think...

Hi I want to ask user to enter workbook number to close and then close that workbook accordingly. So I wrote the code below, but did not run. Any help would be appreciated. Thank you. Sub mywb2() Dim x As Integer x = InputBox("which workbook") "workbooks" &x.close End Sub

I have the Following button code that saves my workbook at a desired location (Save As) with a desired name without including the pages "Main" and template". Right after I save the copy, I have another button that when clicked, it closes my "Master" workbook without any changes but keeps excel...

I wish to automate the calculation of my portfolio at the end of day for my analysis purposes. https://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=SBIN The above web address needs to be dynamically modified to obtain data of stocks. In the above address "SBIN"...

Dear All, If you run this application, and this opens the xlMicrsoftWord ..... how do you get VBA to CLOSE it?? Sub Macro1() ' Application.ActivateMicrosoftApp xlMicrosoftWord End Sub Thank you, Pinaceous

I've truck an oddball problem. My workbook opens ok, and to test I load my Form from the immediate window and close it If I then attempt close Excel. I get the wait cursor forever and need to Contrl-Alt-Del End task. Could someone in the know take a look at it please ? I have proved the issue...

Hi everyone, I have a sheet which has to be partially protected (with some cells always editable) and, sometimes, I unprotect it to change a formula. It is very important for me not to forget that I must protect the sheet again. I would like to have some kind of Pop-Up that warn me when I...