I have the following code that is intended to save and close a particular workbook after 30 mins of inactivity. I get an error however when it is run and I think its because I have other excel workbooks open. I think i need to reference the workbook I am interested in but dont know how to do so. The workbook I want to refer to is P:\Departments Online\Property\Activity\Activity.xlsm
Please Login or Register to view this content.
If the error is with the line Application.Match, it is only possible if the username is not listed on col. A of Users Sheet assuming that your Activeworkbook has a sheet named "Users".
Manually check if it meets all three requirements i.e. Activeworkbook contains a sheet Users and col. A of this has the username listed.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
sktneer
My workbook does have a sheet named Users, but my issue is (I believe) that the fact is I have many workbooks open at once, so the "active" workbook at any one time is not the one with the sheet called Users on it. Which is why i want to specifically reference the workbook instead of the active one.
In that case user Thisworkbook instead of Activeworkbook.
And that only if your code is on the workbook which has sheet users.
Otherwise you may declare a variable like WB As Workbook and then set the WB and use it like WB.Sheets("Users")......
ah that makes sense. Yes it would be "This" workbook that has the sheet with Users in it. Will be testing later today - thank you sktneer!
You're welcome Nick!
Hope that will resolve this issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks