Results 1 to 13 of 13

How can I get a file to automatically save as xlNormal?

Threaded View

foxguy How can I get a file to... 08-08-2010, 03:29 PM
martindwilson Re: How can I get a file to... 08-08-2010, 05:11 PM
foxguy Re: How can I get a file to... 08-08-2010, 05:15 PM
snb Re: How can I get a file to... 08-08-2010, 05:24 PM
protonLeah Re: How can I get a file to... 08-08-2010, 05:38 PM
foxguy Re: How can I get a file to... 08-08-2010, 05:46 PM
romperstomper Re: How can I get a file to... 08-08-2010, 06:22 PM
foxguy Re: How can I get a file to... 08-08-2010, 06:30 PM
romperstomper Re: How can I get a file to... 08-08-2010, 06:32 PM
foxguy Re: How can I get a file to... 08-08-2010, 10:42 PM
  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    How can I get a file to automatically save as xlNormal?

    I have a file in my XLSTART folder that I want to have available to Excel 2002.
    When I open Excel 2007 and modify the file, I want to save it as a .xls file so that it is available to 2002.

    Is there a convenient way to have 2007 automatically save it as an .xls file? I know I can write a BeforeSave macro to do a .SaveAs xlNormal, but I'm hoping that there is some setting somewhere that will do it automatically.

    EDIT: I just discovered that Excel appears to save a file in the same format that it was originally saved in. Sorry for wasting every one's time.
    Last edited by foxguy; 08-08-2010 at 10:42 PM.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

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