Excel functions (1 Viewer)

C

CedarTree

Registered User.
Local time
Today, 09:01
Joined
Mar 2, 2018
Messages
404
How to refer directly to Excel function within Access VBA, please? Thanks! Old database has this coding which is bombing...

Code: 
Abs(Round(Excel.WorksheetFunction.Days360

I get "variable not defined" for the "Excel" word.
 
C

CJ_London

Super Moderator
Staff member
Local time
Today, 14:01
Joined
Feb 19, 2013
Messages
16,607
just a guess - suggest try adding the excel library to your references
 
C

CedarTree

Registered User.
Local time
Today, 09:01
Joined
Mar 2, 2018
Messages
404
Duh?!?!?
 
You must log in or register to reply here.

Similar threads

NauticalGent
Run Excel Trim Function from Access
2
Replies
31
Views
989
KitaYama
K
R
Updating Excel spreadsheet from within the Access
Replies
8
Views
324
CJ_London
C
S
Solved Export from Ms Access form in to Excel
Replies
5
Views
268
skdn71
S
E
export query to Excel file
Replies
1
Views
371
The_Doc_Man
The_Doc_Man
A
Trying to access database in MS Teams
Replies
4
Views
482
CJ_London
C

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom