Hi,
i would like to be able to code in vba a function that will open a specified excel file. So the user can view relevent information to themselves.
I have been using an unbound object frame to view the worksheet by creating it on a form in design view. But the view is too large and cant be changed unless you double click to activate the document and use the scroll bars.
Is there a way to create / modify an empty unbound object frame on form load to do this? and specify a range of cells to view at the same time?
Many thanks if you can help
