raghuram.sta
11-20-2014, 10:22 PM
Can someone please help me how to generate Crystal Report using Excel VBA?
I have only following details
URL : http abc0rr42 / BOE / BI
System : abc0rr43a:6400
User Name: User123
Password: Pass123
Authentication: Windows AD
After login and I do following steps to generate report manually
1) Click on "Documents" tab
2) Click on "Folders"
3) Navigate to folder "Public Folders > App > AutoReports > Mylocation > MyLocation - Operations "
4) Open "My Employee Data" Crystal File
5) Input - Start Date (01/01/2014), End date (30/01/2014) & Plant ID (NFC_ID_IND)
6) Click on "OK" to generate the report (it will take 5-10 mins)
7) Click on "Export this report" button
8) Select file format "Microsoft Excel (97-2003) Data Only" - Page Range: All Pages
9) Click on "Export" button
10) Save the "Excel File" to local drive.
Any help will save my but here
Thanks a million in advance
I have only following details
URL : http abc0rr42 / BOE / BI
System : abc0rr43a:6400
User Name: User123
Password: Pass123
Authentication: Windows AD
After login and I do following steps to generate report manually
1) Click on "Documents" tab
2) Click on "Folders"
3) Navigate to folder "Public Folders > App > AutoReports > Mylocation > MyLocation - Operations "
4) Open "My Employee Data" Crystal File
5) Input - Start Date (01/01/2014), End date (30/01/2014) & Plant ID (NFC_ID_IND)
6) Click on "OK" to generate the report (it will take 5-10 mins)
7) Click on "Export this report" button
8) Select file format "Microsoft Excel (97-2003) Data Only" - Page Range: All Pages
9) Click on "Export" button
10) Save the "Excel File" to local drive.
Any help will save my but here
Thanks a million in advance