hy
I need to access data from an sql server 2005 database everytime i open an excel file to fill a list with employee names. if i import it once, new people won't be added, if i import it on event open true vba, it asks which dataset to use. is there a way you can use vba but don't need to make an connection manually eveytime.
Many thanks.
jens
hi jens,
you can add a vba form to excel
in the form you can place a button and named it refresh
when the user clik on the button thats the only time
you read new employee from sql server
regards,
joey
No comments:
Post a Comment