Excel worksheet in an unbound object frame RRS feed

  • Question

  • 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



    Wednesday, June 27, 2007 1:57 PM

All replies