Recent content by TraceWilliams

I did but I still cannot get the loop to work.... I decided to try this loop in Excel 2007 module: Sub PWProtect() Dim NowWrBk As Workbook Dim WbkName As String Dim WbkPW As String Dim i As Integer Application.ScreenUpdating = False Set NowWrBk = ActiveWorkbook LastRowA1 =...

Isskint, Thanks for the reply... This is the module I built and I keep getting a User Type error when declaring "Dim XLapp As Excel.Application" Function PWWbk() Dim WbkName As String Dim WbkPW As String On Error GoTo Err_fGGO Set rst = CurrentDb.OpenRecordset("FilesTBL") Do While Not...

I am trying to build a module to open a list of Excel 2007 workbooks stored in a table and attach a single password to each. I will have to build a do until loop with a counter that will designate the row selection from the Access table each time through. Does anyone have any code built to...

Is there a function or command I can insert into a DO LOOP that creates a pause before excuting a function? I am creating a function to remove all users from my database for maintenance and want to warn them and give them 90 seconds to complete their work before the database closes. However...

GHudson, Your pause function is the perfect solution for my issue. Do you know the command to tell Access to continue normal function during the DO LOOP? Here is my issue, I am installing a control via function to remove all users from my database for maintenance. I send them a message...