Exporting to an Excel Worksheet


R

Rook

I am exporting a report to Excel and would like to be able to export i
to a specific worksheet within a workbook, is it possible to do this
Is it as simple as modifying the path name? For example, if I a
exporting the data and it prompts me for the destination, can I ente
something like:

C:\Documents\Workbook!Sheet4.xls
 
Ad

Advertisements

M

mk

I am exporting a report to Excel and would like to be able to export it
to a specific worksheet within a workbook, is it possible to do this?
Is it as simple as modifying the path name? For example, if I am
exporting the data and it prompts me for the destination, can I enter
something like:

C:\Documents\Workbook!Sheet4.xls?
Probably not. Where are you exporting from? Is it MSAccess, Crystal Reports?
 
Ad

Advertisements

M

mk

I'm exporting it from Crystal Reports.
Well, as far as I know you can't/

Maybe with VBA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top