We help IT Professionals succeed at work.

Excel 2007 not recognizing simple functions even after correct libraries added.

BenniBoy
BenniBoy asked
on
I have an issue where by Excel 2007 users of my Excel 2003 automated workbook are receiving the attached error when the following macro is run.  

I add the following library to the References but continue to get the error.  Anyone have any idea what steps I may be missing.

Library VBA:
    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
    Visual Basic For Applications
Public Sub VersionInfo()

'Macro to display the document version history

    Dim varIgnore As Integer
    Const cnstFileName = "DGSS Workbook-Checklist.xls"
    Const cnstCreated = "01-May-2010"
    Const cnstVersion = "2.1"
    Const cnstModified = "04-June-2010"

    varIgnore = MsgBox("File:   " & cnstFileName & Chr(13) & "Created:" & Chr(9) & cnstCreated & Chr(13) & "Modified:" & Chr(9) & cnstModified & Chr(13) & "Version:" & Chr(9) & cnstVersion, 64, cnstFileName)

End Sub

Open in new window

Error-Msg.doc
Comment
Watch Question

View Solution Only

Leo TorresSQL Developer

Commented:

Remember office 2007 stores all the drivers in this path
C:\Program Files\Microsoft Office\Office12

2003 uses this path
C:\Program Files\Microsoft Office\Office11
Make sure the VBE6.DLL

Is in the Office11 folder..
Leo TorresSQL Developer

Commented:
Sorry I meant

Folder
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6

Both 2003 & 2007 Should be using this path.. Is the File there
BenniBoy

Author

Commented:
Yes.  The file is there for both.  I added it today to my collegue, who is using Excel 2007.

Leo TorresSQL Developer

Commented:
Wait I thought the 2003 users are the one with issue? or is it the 2007?

I guess you mean 2007

Try these steps save file as an xlsm
And see if that works

if not then go to
1 Excel option  
2 press Trust Center(on left side of box)
3 Press Trust Center Setting on right side of box
4 press macro setting
5 The I would choose the Enable all macro

close out of all windows and reopen Excel and try file
SQL Developer
Commented:
and this file has to be xlsm and if the does not work also do 2nd set of steps
 
FYI any thing that is going to run macros in 2007 should be an xlsm file