+ Reply to Thread
Results 1 to 3 of 3

Exporting a report to Excel

  1. #1
    Forum Contributor
    Join Date
    06-18-2008
    Posts
    123

    Exporting a report to Excel

    Hi guys.

    I have a program that I use to export call data to Excel. No issues with that side of things. I don't know what the program we use is called, as its kind just a shortcut page that we have access to.

    What I want to know is, is it possible to export this data to a specific sheet in an Excel workbook?

    Currently, I need a blank workbook saved in my home drive, as when you export the data, you kind of "save as" it to this blank workbook. It overwrites everything that would have been stored in there previously, hense why it needs to be blank/spare. When you open the workbook, it has one tab, Sheet1, only. Not the usual 3 tabs.

    Any ideas if I can type a new path in the save box to make it insert it to another book or another sheet, e.g. Sheet2? I suppose this is more of a path question than a specific Excel question though!

    Thanks,

    Tony

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Exporting a report to Excel

    I doubt it. It's saving as a new workbook.

    Why would you want to save it as a 3-sheet workbook?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Exporting a report to Excel

    Some thoughts ...

    with the newly created workbook open (let's call it Book1.xls), also open the workbook where you would have liked the sheet to go (let's call that target.xls).
    Then right click on the sheet tab in Book1.xls, select "Move or Copy" and in the following dialog select target.xls from the top drop down.
    Then hit OK and save your target.xls. You can then discard Book1.xls.

    does that help?
    Last edited by teylyn; 11-14-2009 at 09:25 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1