access database in vba

[keith05281967]

Greetings,

I have a link to a folder in a database

\\abc\123\data\datafolder

microsoft sql server

is there a way to access this datafolder in vba code?

excel 07

thanks.

 

[keith05281967]

i think the title might be mis leading. This has nothing to do with microsoft Access. I mean gaining access to the database via excel vba code.