Recent content by tdesilva

Thanks for your reply but this excel file is not a shared file hence not an active workbook to find out users logged in. I changed slightly the but the array "users" blank and get an error message. Private Sub clientList_Click() Dim FileNm As String Dim ret Dim users As Variant Dim row As...

How to find out the user who locked the excel file in vba? I know how to find the owner of the file but owner not always the last user Private Sub clientList_Click() Dim FileNm As String Dim newwb As Workbook Dim us1 As String Dim ret FileNm = "C:\client list.xlsm" ret =...

Thanks it worked:)

I can run the above script opening .mdb in 64 bit operating system but when I run in 32 bit operating system I get the error run time error 2147024703 ((800700c1) Method 'Run' of the Object IWshShell3 failed Is there another method of running shell command in 32 bit operating system

Thanks, What is the version of excel did you use? 2010 or 2013

I can open database in excel application with the below code in Excel 2013 Dim cstrDbFile As String Dim objShell As Object cstrDbFile = "C:\Database1.accdb" Set objShell = VBA.CreateObject("WScript.Shell") objShell.Run cstrDbFile At work, I have access database in .mdb format as some...

Hi, I am trying to open access database using excel application. I am using Office 2010. my code in excel vba is Dim db As Object Set db = VBA.CreateObject ("Access.Application") db.OpenCurrentDatabase "L:\Client Database\Access_fe.mdb" db.Application.Visible = True I have error message...

Hi, I am an experience excel vba developer Tus