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
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

Importing Visual Studio form into VBA? Excel
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
VBA working with excel Excel
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
asp.net programmer .NET Framework
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 developer .NET Framework
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
Freelance Software Developer .NET Framework
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
Freelance MOSS Developer Office
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
sharepoint / asp.net freelance developer .NET Framework
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
Calling Crystal Ball Predictor from VBA Excel
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
Copy Sheet1 from Workbook1 to Sheet2 Workbook2 Excel
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