+ Reply to Thread
Results 1 to 6 of 6

Visual Basic changes?

  1. #1
    Registered User
    Join Date
    08-22-2008
    Location
    Corpus Christi
    Posts
    3

    Visual Basic changes?

    Greetings,
    I know nothing about writing code but I had one written for me many years ago for my log at work and it has been a magnificant tool. I was just upgraded to Version 2007 and I find that it does not function for me any longer. I had a co-worker still on the older version check it and it does work still. Can anyone please help? What do I need to do in the 2007 version to get it functioning again.
    Thanks,
    Linda

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi Linda

    Please post your full code. There are incompatibilities between the two (notably Application.FileSearch is missing in 2007) but it is impossible to be any more precise without seeing what you have at the moment that doesn't work.

    Richard

  3. #3
    Registered User
    Join Date
    08-22-2008
    Location
    Corpus Christi
    Posts
    3
    I would sure appreciate any help I could get!
    Please Login or Register  to view this content.
    Last edited by royUK; 08-22-2008 at 02:50 PM. Reason: add Code Tags

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

    Please take the time to read the Forum Rules that you agreed to and use Code Tags in future.
    Hope that helps.

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

    Free DataBaseForm example

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    The code works ine in Excel 2007. Have you enabled macros? There's a security warning displayed above the column headings, click options.

  6. #6
    Registered User
    Join Date
    08-22-2008
    Location
    Corpus Christi
    Posts
    3
    Please accept my apologizies and my gratitude. The security settings were the problem.
    LM

+ 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. RATE() function with Visual Basic
    By Lotus123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2008, 12:51 AM
  2. Combo Boxes in Visual Basic and excel
    By chris980 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2007, 03:06 PM
  3. What version of Visual Basic w/Office 2001 Mac??
    By doctormelodious in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2007, 01:52 AM
  4. Microsoft Visual Basic For Applications Extensibility Library
    By DCSwearingen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2006, 03:52 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