+ Reply to Thread
Results 1 to 4 of 4

Workbook does not work in excel 2007, but is fine in 2010

  1. #1
    Registered User
    Join Date
    11-15-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    41

    Workbook does not work in excel 2007, but is fine in 2010

    Hi all,

    I have finished developing this spreadsheet for my company (or so I thought) and when i rolled it out, it kept asking people with excel 2007 to debug the code when the second userform was opened (it is attached and the code for the second userform is below). There is nothing wrong with it on excel 2010. I think that it is something to do with the listbox... but anywho, any help would please be appreciated!!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    11-15-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Workbook does not work in excel 2007, but is fine in 2010

    If it helps anybody I've managed to find out it is this line of code:
    Please Login or Register  to view this content.
    That is the issue... apparently 2007 doesn't like arrays and autofilters mixed together

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,603
    Why are you using an array for the criteria?

    Wouldn't it make more sense to use 2 criteria to specify the date range?

    Something like this, >=Date()-7 and <=Date().

    Not sure what the code for that would be but you should get something to work with if you turn on the macro recorder when you do the filter manually.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    11-15-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Workbook does not work in excel 2007, but is fine in 2010

    Fantastic, recorded the macro and have managed to get the criteria code!

    Btw, thank you so much for all your help recently, I've learnt so much in the last few weeks!

+ 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. [SOLVED] CheckBoxes.Add Works fine in 2010 but not 2007 or 2003
    By Jakeman92 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-18-2013, 05:17 AM
  2. Project with AddIn runs fine in Excel 2000, 2003 and 2007...2010 crashes
    By jaslake in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2013, 10:10 AM
  3. Replies: 0
    Last Post: 09-05-2012, 10:19 AM
  4. code that works fine in excel 2007 ie ver 7 not in excel 2010 ie ver 9
    By ycg0311 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-25-2012, 11:56 AM
  5. Replies: 0
    Last Post: 07-27-2010, 12:49 AM

Tags for this Thread

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