VBA working with excel

[douglas]

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 you tell me how to accomplish this task?

 

[ryguy7272]

Perhaps this is what you want:
http://www.rondebruin.nl/txtcsv.htm

Regards,
Ryan---

 

[douglas]

Ryan:

Your answer was very helpful! However I still have another question is
there a way with VBA, and/or a .net peogramming language where I can run a
crystal report and export the output of the crystal report to an excel
workbook and a pdf file?

Thanks!

 

[ryguy7272]

Sure, look at this:
http://www.excelguru.ca/node/21

Remember, you will be in Excel controlling the Save As process. VBA
certainly work in Crystal Reports, or .pdf environment. You probably know
that; just want to make sure.

You mentioned that you want to 'run a crystal report and export the output
of the crystal report to an excel workbook and a pdf file'. Sounds like you
wanted to control the process through Crystal Reports...maybe I'm just
misunderstanding.

Let me know if you've got any more questions.

Regards,
Ryan--

 

[douglas]

"ryguy7272":

I did not know that excel can access crystal reports. That is new to me.
Can you point me to a reference so that I can see how the output from a
crystal report can end up on an excel spreadsheet using VBA or .net?

Thanks!

 

[ryguy7272]

I thought I posted this before...guess it didn't make it off my Thinkpad...

Sorry, I meant to say VBA certainly will NOT work in the Crystal Reports
environment nor will it work in the .pdf environment. VBA works in MS
applications: Excel, Access, Word, PowerPoint. Maybe you can link to a
Crystal Report, or somehow access a Crystal Report, I'm not sure. I've only
used Crystal Reports once or maybe twice and that was years ago; long before
I knew anything about VBA.

If your question is this: 'How to access a crystal Report using VBA?' Just
start a brand new post, with an appropriate title. Your new post will appear
at the top of the post list, and others, much more knowledgeable in Crystal
Reports than myself, may be able to help you.

Regards,
Ryan---