Hi all, thanks for looking in!
I'm writing a front end back end type database app using VBA (we don't have MS Access at work or a bespoke piece of software).
On opening the workbook the following code runs.
Code
Public wbBackEnd As Workbook
Sub OpenBackEnd
Set wbBackEnd = Workbooks.Open Range("Back_End_Location")
End Sub
I want to keep wbBackEnd available to subsequent macros all the time the workbook is open. At the moment I am having to reinitialize it when I need it which I don't want to do, is there a way around this?