We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Display an excel worksheet as child form in a VB6 MDI application

James_Tripp
James_Tripp asked
on
Medium Priority
695 Views
Last Modified: 2012-06-21
I'am looking for a solution on how to display an excel worksheet as child form in a VB6 MDI application
and if the user makes a change in the excel worksheet and does not want to save the changes to that
spreadsheet, when the VB6 MDI application closes the excel worksheet unloads properly when the VB6 MDI application closes.
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
you could open the excel sheet inside an OLE container that is placed on a MDI Child form.
from VB, you can then access the excel spreadsheet via the olecontainer's document property

http://support.microsoft.com/kb/242243

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.