Microsoft Excel - VBA code required for Excel 2010 to open, perform and save a Crystal Reports 9 report pls.

Asked By Paul Potter on 27-Jun-12 03:35 AM
Earn up to 50 extra points for answering this tough question.
Jitendra Faye replied to Paul Potter on 28-Jun-12 12:23 AM
Refer this link-

http://forums.esri.com/Thread.asp?c=93&f=992&t=67019

solution-

Before executing below code Put the CrystalReport control on your form.
      

CrystalReport1.ReportFileName = gStrReportsPath & "\" & str
    CrystalReport1.Connect = "DSN=scana"
    CrystalReport1.SQLQuery = "SELECT CATCHTRY.STREET,CATCHTRY.YEAR,ESTAB.ES_NAME,CATCH.LEA FROM CATCHTRY,ESTAB WHERE CATCHTRY.CODE=ESTAB.ES_ESTAB " & strOrderByClause
    CrystalReport1.Destination = crptToWindow
    CrystalReport1.WindowState = crptMaximized
    CrystalReport1.Action = 1
    CrystalReport1.Reset
help
VBA form controls do not include a date-picker. VS2005 does. This is a critical matter for me. Is there a way to import a VS2005 form in Excel VBA? (I am trying to create better reports than Crystal, that will take data from a database, based on user selections in a form, and then populate cells in a spreadsheet with the data. Crystal will do two or more levels of groupings, but I want to also break-up the data by week, month or quarter, in ways that are too complex for Crystal Reports. Then, I want double clicking on a cell to bring up a another report
keywords: Microsoft Excel, Excel 2010, date, VBA, Crystal Report, report description: VBA code required for Excel 2010 to open, perform and save a
I am setting up a VBA application where I will be creating a crystal report and exporting the data to Excel 2003. For each unique crystal report, I would like to export each report to a different tab (worksheet) on one excel workbook. I do not want each report to be on separate excel workbooks. Thus can
NET TECHNOLOGY .NET(ASP.NET / C# / VB.NET) VB, ASP (VBScript & Javascript), SQL Server, Access (VBA), Excel (VBA), Oracle Crystal Reports & SQL Reporting Service LAMP TECHNOLOGY PHP 4 / 5 MySQL I can work on migration leo [at] gmail [dot] com VB.NET Discussions SQL Server (1) MySQL (1) Oracle (1) Excel (1) ASP.NET (1) VB.NET (1) VBA (1) VB (1) Please do not post solicitations in these newsgroups. It is specifically mentioned
ASP.NET / C# / VB.NET) SharePoint 2003 / 2007. VB, ASP (VBScript & Javascript), SQL Server, Access (VBA), Excel (VBA), Oracle Crystal Reports & SQL Reporting Service LAMP TECHNOLOGY PHP 4 / 5 MySQL I can work on migration freelancefromindia.blogspot.com / ASP.NET Discussions SQL Server (1) MySQL (1) SharePoint (1) Oracle (1) Excel (1) ASP.NET (1) VB.NET (1) VBA (1) This is not how these newsgroups are supposed to be used. Try monster.com
NET / C# / VB.NET) MOSS 2007 / SharePoint 2003 VB, ASP (VBScript & Javascript), SQL Server, Access (VBA), Excel (VBA), Oracle Crystal Reports & SQL Reporting Service LAMP TECHNOLOGY PHP 4 / 5 MySQL I can work on migration gmail [dot] com ASP.NET Discussions SQL Server (1) MySQL (1) SharePoint (1) Oracle (1) Excel (1) MOSS 2007 (1) ASP.NET (1) VB.NET (1) This newsgroup is for people
NET / C# / VB.NET) SharePoint 2003, MOSS 2007, VB, ASP (VBScript & Javascript), SQL Server, Access (VBA), Excel (VBA), Oracle Crystal Reports & SQL Reporting Service LAMP TECHNOLOGY PHP 4 / 5 MySQL I can work on migration gmail [dot] com Office Miscellaneous Discussions SQL Server (1) MySQL (1) SharePoint (1) Oracle (1) Excel (1) MOSS 2007 (1) ASP.NET (1) VB.NET (1) Wrong place or newsgroup to
ASP.NET / C# / VB.NET) SharePoint 2003 / 2007. VB, ASP (VBScript & Javascript), SQL Server, Access (VBA), Excel (VBA), Oracle Crystal Reports & SQL Reporting Service LAMP TECHNOLOGY PHP 4 / 5 MySQL I can work on migration http: / / freelancefromindia.blogspot.com / C# Discussions SQL Server (1) MySQL (1) SharePoint (1) Oracle (1) Excel (1) ASP.NET (1) VB.NET (1) VBA (1) What specific problem are you having with C#. . .? - - Mark Rae ASP.NET MVP http
Based on the following description: "The Crystal Ball and CB Predictor Developer Kits allow users to completely automate and control Crystal Ball simulations and CB Predictor forecasts from within a VBA program or any other language outside of Excel supporting OLE 2 automation. The kits consist of libraries of macro commands and functions that unlock the programmability of Crystal Ball and CB Predictor. With the kits, users can automatically run multiple simulations to test
I am learning VBA Excel and have attempted this, but can't seem to get it to all work together 2. I believe I can take it from here. Any response would be greatly appreciated! Excel Programming Discussions Application.GetOpenFilename (1) Workbooks (1) Sheets (1) Excel (1) Macro (1) VBA (1) Workbook2.Sheet2 (1) Workbook1.Sheet1 (1) Sub test() Dim ws As Worksheet Dim wb Workbook Dim fName As Variant Set ws = ThisWorkbook.Sheets(1) fName = Application.GetOpenFilename( _ FileFilter: = "Excel Files (*.xls), *.xls") If fName = False Then Exit Sub Else Set wb = Workbooks.Open(fName with the new data.", vbOKCancel) If Msg1 <> vbOK Then Exit Sub fName1 = Application.GetOpenFilename(FileFilter: = "Excel Files (*.xls;*.csv), *.xls;*.csv") If fName1 = False Then Exit Sub Set wbCrystal = Workbooks.Open