I'm currently thinking to put some help files into excel, and would like to call them from on click event of the button. Don't want to keep them in access as the main file gets large and takes to long to load on some computers/when lan is crowded.
I use this to open excel
Can i modify this so that it would open on a specific sheet?
maybe some on load event for excel? not sure how variables transfer between applicstions.
In the end I might to put all the data into a table (lot's of tables, pictures) in backend, but for now I'm exploring this option.
I use this to open excel
Code:
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.Workbooks.Open "my file", True, False
Set xlApp = Nothing
Can i modify this so that it would open on a specific sheet?
maybe some on load event for excel? not sure how variables transfer between applicstions.
In the end I might to put all the data into a table (lot's of tables, pictures) in backend, but for now I'm exploring this option.