Printable View
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!
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
u mean i have to capture an image of the document? then show that image in the picturebox? am i getting it right?
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.
-- 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???
maybe using SetParent API? you would need to find its hWnd first tho and then set parent into a form/picturebox/frame
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?
I'm a bit confused, dexjel. Do you want to use OLE or not?
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
that sounds exactly like an ole control, from tool boxQuote:
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?