locked
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