+ Reply to Thread
Results 1 to 2 of 2

Newly opened xls file appeared as a workSHEET not workbook

  1. #1
    Forum Contributor
    Join Date
    01-06-2010
    Location
    East Grinstead, UK
    MS-Off Ver
    MS Office 365
    Posts
    502

    Newly opened xls file appeared as a workSHEET not workbook

    I'm sure this is very basic! I opened a workbook called Walk Index.xlsm (which I've been using regularly for a few weeks) and it duly appeared as usual.

    A little later I opened a separate file called DVD Index.xls, which I haven't used since replacing Excel 2000 with Excel 365 a couple of months ago. My intention was to bring it up to date and then save it in the xlsm format as recommended in an earlier post. But to my surprise it opened as a separate tab (a separate worksheet) in Walk Index.xlsm

    I'd appreciate an explanation of this unexpected behaviour please.

    --
    Terry, East Grinstead, UK

  2. #2
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Newly opened xls file appeared as a workSHEET not workbook

    Hi Terry,
    I do not have any experience with earlier Xl , having come in as a late starter with computers at the XL 2007 / 2010 time.

    But check out “Weirdo 1” in this Thread
    http://www.excelforum.com/excel-prog...w-modules.html
    I am wondering if for some strange reason your DVD Index.xls has been taken by your newer XL as a Macro sheet, or something similar****
    If you _.....
    _a) cannot see a worksheet code module or any information about that worksheet in the VB Development project Window
    and
    _b) when you right click on that worksheet you do not get the option to view code
    _.... then it sounds like it is being taken as a ( Excel 4. ) Macro Sheet or similar

    I do not know whether in XL 2000 you only have one sheet and is that Excel 4 ????? – I do not think XL 2000 is Excel 4 https://de.wikipedia.org/wiki/Microsoft_Excel )
    But do you only have one sheet in XL 2000?

    ****I believe Macro Sheets in later XL versions are only there for backward compatibility. So that could answer your question. It is perhaps not possible to save a File from earlier versions as an .xlsm File. “Housing” them in a macro sheet in another .xlsm File is possibly therefore the only way to go “half way” to “bringing it up to date”.

    _........

    Also if you right click on the tab of that worksheet and select the Insert, you will see Highlighted what it is.

    Alan

    P.s. if you upload the File i can take a quick look and see if it looks the same as the mysterious Macro Sheet that I once had ( which as you see from the Thread I referenced came out to be just a ( Excel 4. ) Macro Sheet that I probably inserted by mistake )
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If The Sheet it A Newly Opened File does not exist
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2015, 07:11 PM
  2. [SOLVED] Put name of every newly opened file into variable?
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2014, 08:18 AM
  3. [SOLVED] auto macro for newly opened workbook
    By namluke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2014, 03:11 PM
  4. Need to Copy Columns from Previous Workbook to Newly Opened Workbook
    By BYizz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-06-2012, 06:33 AM
  5. Make newly opened workbook the active workbook
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2011, 10:12 AM
  6. Find newly opened file and copy 1 column
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2011, 10:37 AM
  7. [SOLVED] Close file and run macro from newly opened file
    By Pradip Jain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2005, 07:06 PM

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