Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Languages / VB.NET / November 2006

Tip: Looking for answers? Try searching our database.

How can I send 'Save' message to the excel main window?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
iloveprincess - 27 Nov 2006 04:15 GMT
Hi,

I'm developing windows application using VB.Net 2005.
I would like to send 'save' message using 'SendMessage' API to the excel
appication. I've already got a handle of the excel window with 'FindWindow'
API.
How can I send 'save' command to external excel window?

Actual thing I want to do is I can handle excel application in the winform.
My client hope that all staff can use excel application in new window
application.
So, I placed excel application to the panel control on the winform using
'SetParent' API.
But I've found that excel application's main window handle is changed after
placing in the winform. So, I couldn't do anything with original excel main
window handle.

Finally, I'm trying to find another way.
First way is that user click 'open' button on the window application to open
an excel file in the network folder, and start excel application, and user
update excel file on the external excel application, and then click 'save'
button on the window application to save external excel file, and click
'close' button on the window application to close external excel application.

So, I need to use 'SendMessage' API to save and close excel application.
How can I do?

Second way is using 'Process' namespace.
However, to use 'Process' I have to study more and more.
Can you help me?

Thank you for your time.
Michel van den Berg - 27 Nov 2006 08:51 GMT
It isn't an answer to your question, but please have a look at VSTO:
http://msdn2.microsoft.com/en-us/library/d2tx7z6d(VS.80).aspx
As Excel is an Office product, you might want to use it...

iloveprincess schreef:

> Hi,
>
[quoted text clipped - 28 lines]
>
> Thank you for your time.
iloveprincess - 27 Nov 2006 09:27 GMT
Thank you for your reply.

I really appreciate.

> It isn't an answer to your question, but please have a look at VSTO:
> http://msdn2.microsoft.com/en-us/library/d2tx7z6d(VS.80).aspx
[quoted text clipped - 34 lines]
> >
> > Thank you for your time.

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.