Excel functions

C

CedarTree

Registered User.
Local time
Today, 14:14
Joined
Mar 2, 2018
Messages
440
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.
 
just a guess - suggest try adding the excel library to your references
 
Duh?!?!?
 
You must log in or register to reply here.

Similar threads

S
Solved Excel 2007 macro not working in Excel 2024
Replies
8
Views
266
smiler44
S
M
Solved What is the trick to be able to execute from the Immediate window a Sub defined on a Sheet of an Excel xlsm file?
Replies
9
Views
1,001
cheekybuddha
cheekybuddha
B
Invalid procedure call or argument - overflow?
2
Replies
23
Views
660
The_Doc_Man
The_Doc_Man
S
Solved Timing or other issue when closing Excel from Access
Replies
13
Views
508
sxschech
S
H
Extract a variable number of parts of text from a string
2
Replies
26
Views
547
AHeyne
A

Users who are viewing this thread

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