INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

In an Excel Export... can I get the sheet name to not use the file name of the Report?

In an Excel Export... can I get the sheet name to not use the file name of the Report?

In an Excel Export... can I get the sheet name to not use the file name of the Report?

(OP)
Strange one here... Using Crystal 8.5 with a paradox database, I am exporting invoice information to an Excel file in order to be imported into QuickBooks. However, when I create the export, the Sheet tab uses the file name of the Report (salesinv.rpt), and the importing into QB program doesn't like the "." before the rpt extension. Is there any way to keep the sheet tab from using the file name. To be frank, I am skeptical there is a solution, but there is some really smart people on these forums so I throw myself on your wisdom! bigsmile

RE: In an Excel Export... can I get the sheet name to not use the file name of the Report?

HI,

Why not export a .csv text file. I believe that Quicken et al can import text files.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: In an Excel Export... can I get the sheet name to not use the file name of the Report?

No, there's no way to change that. Also, Crystal 8.5 has been out of support for at least 10 years, probably longer. If you can upgrade to the latest - Crystal 2013 - Excel files are exported with the default sheet name of "Sheet1".

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close