I was wondering f soemone could give me some advice on OLE Objects with VB/VBA
I'm am just starting to learn OLE coding and creating Objects and such and I have come across a few issues I hope could be resolved.
I am trying to create an interface that connects to Excel, modifies an existing worksheet in a already dreated workbook and then returns the results in the controls on the form.
I have tried creating and setting up the object in the Load_Form event similar to below
Dim exlApp As Word.Application
Dim exlDoc As Word.Document
Set exlApp = CreateObject("Excel.Application")
Set exlDoc = exlApp.Documents.Open("C:\Foldername\Filename.xls")
but then I don't know how to then access this object from other procedures (ie other events or subs)
I hope this is relevant and any feedback or advice would be highly appreciated