![]() In my VBA list of available references, I have 6 that start with BusinessObjects, a bunch that start with Crystal or Crystal Enterprise, and I have 13 that start with Crystal Reports:īut none that say "ActiveX" or "Runtime".ġ) Which reference(s) should I activate? Or if I need one that I don't have showing, how do I get it in there?Ģ) What is some sample code that will get my report to run? Let's say my data source is called "data.xls", and my report is called "Report.rpt", and all my tables & fields have already been set up in the report. I'm running Windows 7, Office 2010, and here is my Crystal Reports version info: My problem is that I do not have such a reference showing up in my list of available VBA references. ![]() I've searched the internet and found various answers, but the general consensus is that I need to activate the reference library Crystal Reports ActiveX Designer Run Time Library, or something close to that. My data source will always be Excel but the specific file being used will vary each time my application is used. Now I need to do the same thing using Excel VBA code. I am able to run my report by manually opening the Crystal Reports program, linking to my Excel data and either previewing or printing the report output. ![]() My goal is to use Excel VBA to run a Crystal Report. I have been programming in Excel VBA for about 3-1/2 years, and this is my first time posting. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |