workbook close

Hi I'm looking for a vba code to monitor the time spent since the workbook was opened. I want to track the time from opening the sheet till it was closed and create a log for such event.

Hi guys, Im new in the VBA What I'm doing is opening a few files to copy the information of each of that to a main file, Im doing this after open a USERFORM with a button in the USERFORM What I cant do is tell VBA to close the source files, it give a RUNTime Error 1004, Method Close of Object...

When I run this code, Excel will crash when it reaches the last line, i.e where I close "document2". Any thoughts? I've used similar code before and it has always worked. Option Explicit Sub DAILYSALES_END() Dim rownum As Double 'save document1 at temporary location...

Hello MrExcel-Forum, there once was a computer, who at certain times, ran a batch-file via the task-scheduler, the batch-file starts an xlsm-file, and the xlsm-file used "thisWorkbook.close false" at the end of their vba (in workbook.open. the "false" means that changes are not saved). there...

Hello, Trying to figure out the vba code which can help me to close all opened workbooks except the active one which has macro. Below is my code. But it does not close any workbook. Please help. Thank you in advance. Sub CloseOtherWorkbook() Dim WB As Workbook Windows("Master...

I am copying from one workbook to another. This code works fine in Excel 2007. However, it freezes each time in 2013 on the .Close portion. Any idea as to why this would happen? There is no issue with the path, and this code has been run hundreds of times in the previous version of Excel so it...

Hello all I started to learn VBA code on Excel 2010 10 days ago and have "successfully" written the following basic code: This works great for what I need it to do except for the final line :( For the life of me I cannot seem to be able to close the variable defined workbook....I always get...

2003 / w7 Things have been going swimmingly and then..... I used the Workbooks.Open FileName = Application.GetOpenFilename(fileFilter:="Excel Files (*.xls), *.xls") MsgBox "You selected " & FileName If FileName = False Then Exit Sub Workbooks.Open FileName:=FileName...

Hi, Using Excel 2007, I have an .xlsm file with a custom ribbon tab containing Button and Separator controls. Quite frequently, when the workbook is closed, Excel crashes. I think there is a problem when the customised part of the ribbon is unloaded. The workbook does not contain...