0 items - $0.00

Your shopping cart is empty

Why not add some items in our Shop
Call Us at +27 21 786 1224

Excel VBA / 2 posts found

Multi-user prevention on Dropbox

by Brilliance Computer Training Academy & Services
Often we sit with the situation where we have multiple users adding data to workbooks. We want to prevent more than one user to open the same workbook so that one person does not overwrite the changes of another. When we are on a network, the code below will work. But this is not the case in Dropbox. Private Sub Workbook_Open() If ThisWorkbook.ReadOnly Then MsgBox “This File is already in use. ” & Chr(13) & Chr(13) & “Multiple users are not allowed at one point in time.” & Chr(13) & Chr(13) ThisWorkbook.Close savechanges:=False End If End Sub Shared folders in […]

Sending email from Outlook using a non-default account

by Brilliance Computer Training Academy & Services
My mentor David Wood from AdvancedApps has helped me out with code on how to send email from an Outlook Account where this Account is not the default Account. Outlook 2016 – Select the account from where email must be send. I am trying to send mail from a specific account. This account in Outlook is not the default account. In this case what makes it much easier is that the user can select the email address rather than account number. sendCaller loops through the accounts until it finds this email address. From there on it will call sendFile from […]