Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SchizoPhreddy
- Order by date
-
Protect-Unprotect VBAProject Programatically
Scottflyer, If you want to access a workbook with out having it active try using: WorkBooks("myWorkBook") Instead of: ActiveWorkbook To protect the workbook, use the following: Workbooks("myWorkBook").Protect "Password", True, True The first password is case...- SchizoPhreddy
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Finding Last Modified Dates for an Access file and an Access table
Hi IoMatua, I think that the best way to retrieve any file related information / attributes is to use the FileSystemObject (scrunn.dll). This is a standard Microsoft component, so there will be no problems in using it within VBA. The following function takes in the name of a file and returns...- SchizoPhreddy
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
