View Word & Excel in form w/o OLE.
guys i know there's a lot of topics about this in google but i still cant find any accurate solution to my program. i'm trying to show the users an attachments (which is word or excel files). at first i thought using pdfs would be good but when excel is converted to pdf some contents are not shown. do you guys have any alternatives on how to show these files in a vb form? Any advices would be considered. Thank you!
Re: View Word & Excel in form w/o OLE.
you could use the copypicture method of a range, then copy from clipboard to a picturebox
there would be several similar alternatives, including a screen snapshot of a particular area, either of which could be saved to file first then loaded into a picturebox or similar
Re: View Word & Excel in form w/o OLE.
u mean i have to capture an image of the document? then show that image in the picturebox? am i getting it right?
Re: View Word & Excel in form w/o OLE.
Does the Word or Excel document absolutely have to reside within the form? Could you not check for an existing Word or Excel instance and launch the files into that, bringing it to the front - or if no instance open Word or Excel and pass the filename? I know there are APIs available to accomplish testing for an instance, opening an instance, and bringing it to the front.
Re: View Word & Excel in form w/o OLE.
-- I think that he/she means that to have a fully working ActiveX Control Object of Word or Excel in the Form, using OLE processes, right???
Re: View Word & Excel in form w/o OLE.
maybe using SetParent API? you would need to find its hWnd first tho and then set parent into a form/picturebox/frame
Re: View Word & Excel in form w/o OLE.
ahm yes that's what i meant guys. i want the doc inside a window or something, with that the user can only view it just like a picture but can navigate through that document though. do you know any activex (preferably free) that i can use?
Re: View Word & Excel in form w/o OLE.
I'm a bit confused, dexjel. Do you want to use OLE or not?
Re: View Word & Excel in form w/o OLE.
another suggestion which might work is use a program from inside vb6 (example: excel) save as .jpg temporary (all this would be done either invisible or off screen) so you dont see then simply open the temporary jpg file in picturebox?
cannot try at the moment, i am away from pc
Re: View Word & Excel in form w/o OLE.
Quote:
ahm yes that's what i meant guys. i want the doc inside a window or something, with that the user can only view it just like a picture but can navigate through that document though. do you know any activex (preferably free) that i can use?
that sounds exactly like an ole control, from tool box