+ Reply to Thread
Results 1 to 7 of 7

spreadsheets in forms 2007

Hybrid View

  1. #1
    Registered User
    Join Date
    01-10-2010
    Location
    Malmo, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    27

    spreadsheets in forms 2007

    Hi I'm sorry to continue my rant as to why my macro written in excel 2003 does not work in 2007.
    However, I've now gotten indications that it is due to embedded spreadsheets in some of my forms that presents information.
    The reason for that being that I deleted forms with spreadsheets in them and mailed it to a 2007 user who said it suddenly worked.

    Does this sound familiar to anyone?
    Is there some sort of work around?

    I guess I could delete the spreadsheets and instead present info in about 100-300 different labels or textboxes. However that is something that probably would look bad and also take a lot of time, so any other suggestions would be welcome.
    Last edited by aron; 11-22-2010 at 12:30 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: spreadsheets in forms 2007

    Can you stick to the original post on this subject please
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    01-10-2010
    Location
    Malmo, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: spreadsheets in forms 2007

    I'm not entierly sure what you mean by that roy.

    What I mean't by rant, is that my last three questions have been regarding compatability between 2003 and 2007.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,982

    Re: spreadsheets in forms 2007

    I presume your forms are using the Office Web Components? These were discontinued from 2007 onwards.
    Everyone who confuses correlation and causation ends up dead.

  5. #5
    Registered User
    Join Date
    01-10-2010
    Location
    Malmo, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: spreadsheets in forms 2007

    Yes that was a problem before!
    However I did turn those off (don't know why they were turned on from the beginning to be honest), it still does exactly what it is supposed to in 2003 and nothing at all in 2007.
    The references I have running now are:

    Visual Basic for Applications
    Mocrosoft Excel 11 Object Library
    OLE Automation
    Microsoft Forms 2.0 Object Library

    Reason I was thinking spreadsheet was that I remembered those had to be imported (a long time ago since I did that).

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,982

    Re: spreadsheets in forms 2007

    If the forms still contain the Spreadsheet control, then they won't work in 2007.

  7. #7
    Registered User
    Join Date
    01-10-2010
    Location
    Malmo, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: spreadsheets in forms 2007

    Thank you so much!

    At least I know where to start messing around now. Not looking forward to it.

+ 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