Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calling an Access function from Excel VBA

Status
Not open for further replies.
tomlander

tomlander

Programmer
Jul 10, 2002
15
0
0
CA
Is there a way to call an Access function from a Excel VBA codes?

Thanks.
 
Sort by date Sort by votes
You have to set a reference to Access and then control it using your Access object. Sorry all I can do is point you but I'm about out of time.

Good Luck!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Question
Filter vba problem
Replies
0
Views
91
Moss100
Moss100
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
99
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
92
Viswa.R
Viswa.R
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
142
Knicks
Knicks
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
115
TheAceMan1
TheAceMan1

Part and Inventory Search

Sponsor

Back
Top