Page 2 - OLE control using excel

Then, programmatically, make it bigger before displaying it, and then make it smaller before occluding it.

It's not a perfect world.

Or make a solid rectangle (sized a little larger than the embedded object) colored the same as the form background, and programmatically unmask and mask the embedded object with that.

Good morning,
i'm sorry maybe i didn't make it clear.
but the excel application pops out, and opens for the user, not on the form but seperately as a stand alone application while it runs.
i dont have a problem with the form itself as all my calculations runs <on load> action so the form wont show to the user untill all the sheets are updated.
i need a code that allows me to edit unbound excel workbook with 3 sheets without the word application getting activated and visible for the user

In #11 you say...... . Now you can?

Why is Word involved in this?

Mimi,

You're using Excel as an instance (maybe even more than one instance); the upper left corner of the Excel window you're using says "Microsoft Excel," the instance in the tray at the bottom of the screen says "Microsoft Excel." You're building calculations and graphs in this window (or windows if you're launching more than one instance of "Microsoft Excel").

You're storing all of the data in Access (which I don't recommend, but if you're keeping the communication only between Excel and Access I guess it's okay, if there's not that much data volume to store. But that's not even the gripe I have with Access).

Describe the problem. Don't use the word "unbound" in describing it. Keep the big words out of the description.

You have Access in one window, and Excel in another. What's the problem?

Frank - What gripe DO you have with access if I may ask? I use it daily connecting to Oracle databases and doing some pretty heavy lifting professionally. Its a very capable tool. It should not be used for a web server database but for single user or small LAN user groups it's a fine, extremely powerful and very useful tool. I have back ends with literally millions of records. Storage should not be an issue for all but the most demanding of needs in which case SQL Server or something else should be considered.

I've observed it doesn't play well with XP combined with ASP; seen occasions were it drops entire rows of data.

(The DAO bugs under ordinary use don't count.)

Otherwise I agree it's a great front-end to more robust DBs.

Frank,
Thank you for your interest (again) in solving my problem, which was on hold for a while as i had to do something else in between..
Now, if i typed word by mistake in my problem, while i was asking about excel... then i just hoped i would be excused instead of being banged on the head... anyways... back to subject...

I dont have the choice of which programs i use, as its already developed and i need to modify the way things function...

Now.. i have a seperate excel sheet, that is linked to an access sheet, this excel sheet runs calculations and create graphs basked on an access database data.

The user would like to have the excel sheets integrated within the database itself on one of its forms...
now i dont understand why the word (unbound) is big.. but again.. anyways...
to keep it simple and basic.. i need an instance of an excel sheet on my form. this excel sheet will (should) have always 3 pages. the first will be empty, in order to create the graphs on, the second should have pivot tables, and the third will be used to get data from the database and listed there to be used later on the pivot tables and so to create the charts..

I have searched a lot on the internet to find a way to include an excel sheet on an ACCESS form but not being a link to or a copy of an existing excel sheet.

I dont want my excel sheet to be saved anywhere else but the access database, and i dont want it to be poped up for the user while things are getting populated... How can i do that ?

Thanks again.. and i hope that i didnt use any big words

If you read the whole sentence it says