-
I've written a reporting package in VBA for Excel 97, and my boss is now getting on my case to get it converted to full VB (5 or 6 I should think). I think most of the conversion should be dead easy, but the reports concern me. Currently, I use blank single sheet Excel workbooks for each report generated, coz it's easy to align/bold/size stuff.
MY QUESTION IS THIS!!!!!!!!!!!! (tense, expectant silence)
What's the best way to output these reports using full VB? Can I use Excel objects (I think I may have just invented that), or do I have to print all my stuff to text boxes/picture boxes, and figure out some way of aligning and all that? I really don't know where to start here...
-
You bettya! I've used it for several applications. You basically create an Excel object, and manipulate it with it's properties and methods, just like any other object. You'll find lots of info at the following web page. Good luck.
http://msdn.microsoft.com/isapi/msdnlib.idc?theURL=/library/officedev/odeopg/deovroffice2000visualbasicprogrammersguide.htm
-
HDR!!! Hayelp!!
Here's the thing - can I insert an excel sheet from the Components/Insertable Objects tab? I mean, add that to the toolbox, then draw the excel sheet on the form, then somehow manipulate that with the usual excel properties? I've been mucking around with the GetObject thing, but I can't get it working... aaaaarh, help me please (fades)
btw, I did have a look at the link you very kindly provided, but I'm not that hot with all the talk, couldn't really work out where I should start looking.
