Hi,

I have a macro which basically has some vb coding in it which goes to a SQL Server and brings the values out a column from a given table.It runs fine when i select run and i have a created machine datasource which i select which basically has the server name and stuff and it asks for login and if select OK it runs fine brining the values i needed.

My question is Is there anyway we can automate it? Like if i just click run on the macro it must do all these operations rather than me manually doing it?


Thanks