Re: Rename a Workbook??

From: Don (anonymous_at_discussions.microsoft.com)
Date: 09/18/04

  • Next message: JohnI in Brisbane: "Re: Excel Functions" 
    Date: Sat, 18 Sep 2004 13:06:54 -0700

    Thanks Dave for the reply, both to my query and for the
    info about various log-ins here. I will be checking them
    out soon.

    My first post still hasn't shown up here.

    I'll look at the .savecopyas and kill function, however as
    I was trying to avoid saving file to disk, this probably
    won't do what I'd like here. A bit more explanation may
    be helpful here...I've got a WB with multiple sheets, one
    *** gathers data from another *** in that WB and then
    is copied to a new WB...then with some manipulation, I
    kill the links and sort the data. It's at this point (WB
    is named "Book1" by default), that I'd like to change the
    WB name without saving so as to have the file name as a
    header, but if I'm reading you correctly, I guess that's
    impossible, even with VBA. I can just go the direction
    I've been going and print a draft, then save file and then
    print a final doc.

    Thanks again for the second reply....still not sure why my
    first post isn't showing here......but....at least I got a
    response....you guys and gals are great.

    Have a great day,

    Don

    >-----Original Message-----
    >This was my reply at your first post:
    >
    >The name of a workbook comes when you save it.
    >
    >Maybe you could use .savecopyas within your macro.
    >
    >Then if the printed copy is ok, keep that workbook--if
    it's not ok, look at Kill
    >(in VBA's help) to delete it.
    >
    >But if you use .savecopyas, you actually save a copy of
    the workbook you're
    >working in--the workbook that you're in doesn't change
    and isn't saved.
    >
    >If you want, you can open that .savecopyas file, but if
    you don't open it, it's
    >just sitting there on disk.
    >
    >
    >========
    >
    >I connect to the MS Servers directly. You may want to
    try it, too.
    >
    >Saved from an earlier post....
    >
    >If you have Outlook Express installed, try clicking on
    these links (or copy and
    >paste into MSIE).
    >
    >news://msnews.microsoft.com/microsoft.public.excel.setup
    >news://msnews.microsoft.com/microsoft.public.excel.misc
    >news://msnews.microsoft.com/microsoft.public.excel.workshe
    et.functions
    >news://msnews.microsoft.com/microsoft.public.excel.newuser
    s
    >news://msnews.microsoft.com/microsoft.public.excel.program
    ming
    >
    >(and a few more for MSWord)
    >news://msnews.microsoft.com/microsoft.public.word.docmanag
    ement
    >news://msnews.microsoft.com/microsoft.public.word.word97vb
    a
    >news://msnews.microsoft.com/microsoft.public.word.newusers
    >news://msnews.microsoft.com/microsoft.public.word.pagelayo
    ut
    >news://msnews.microsoft.com/microsoft.public.word.vba.addi
    ns
    >news://msnews.microsoft.com/microsoft.public.word.vba.begi
    nners
    >news://msnews.microsoft.com/microsoft.public.word.vba.cust
    omization
    >news://msnews.microsoft.com/microsoft.public.word.vba.gene
    ral
    >news://msnews.microsoft.com/microsoft.public.word.vba.user
    forms
    >news://msnews.microsoft.com/microsoft.public.word.word6-
    7macros
    >
    >(You can always connect to more later)
    >
    >Here are some links that explain it better:
    >
    >Chip Pearson has some notes written by Leonard Meads at:
    >http://www.cpearson.com/excel/DirectConnect.htm
    >
    >David McRitchie's notes at:
    >http://www.mvps.org/dmcritchie/excel/xlnews.htm
    >http://www.mvps.org/dmcritchie/excel/oe6.htm
    >http://www.mvps.org/dmcritchie/excel/oe6nws01.htm
    >
    >Tushar Mehta's notes at:
    >http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm
    >
    >And if you're looking for old posts:
    >
    >Or you can use google (maybe a few hours behind) to
    search for stuff you've
    >posted (and find the replies, too)
    >
    >http://groups.google.com/advanced_group_search
    >http://groups.google.com/advanced_group_search?
    q=group:*Excel*&num=100
    >
    >Ron de Bruin has an excel addin that you may like:
    >http://www.rondebruin.nl/Google.htm
    >
    >Don wrote:
    >>
    >> Howdy folks,
    >>
    >> First, if this gets double posted, I apologize...I put
    >> this question up over an hour ago and I can't find it on
    >> the board. It must be floating around out there in
    cyber-
    >> space somewhere.
    >>
    >> Question was....can you rename a Workbook, using VBA,
    >> without using the "Saveas" function. I'd like to print
    a
    >> copy of the one *** WB and leave the option to save to
    >> the OP using a msg box. I need to change the WB name
    >> because of a Header used in printing that reflects the
    >> current file name.
    >>
    >> I have been printing two copies, one before the saveas
    and
    >> one after the saveas function, but would nice to clean
    >> that up to one print, if I can.
    >>
    >> Any help would be greatly appreciated and again, I
    >> apologize if this gets double posted.
    >>
    >> Don
    >
    >--
    >
    >Dave Peterson
    >ec35720@msn.com
    >.
    >

  • Next message: JohnI in Brisbane: "Re: Excel Functions"