Hi,
I want to have a database query run automatically on a Progress database. To do that I created a scheduled task to open a certain Excel sheet which contains a auto_open macro. The auto_open macro runs another macro which runs the query and copies data to a new workbook if a certain requirement is met.
Now the thing is that when I run the macro I keep being asked to enter a password. This should be done automatically. I have found in the Progress knowledge base that you can bypass this password prompting by creating a file dsn. When I now start Excel and create a new database query and choose the file dsn, it indeed doesn't ask for a password. But not I want to automate this in my Excel macro. In the usual VBA connect string I cannot reference a file dsn though, just a normal dsn. Do you know a way to handle this issue?
Thanks,
Cynthia Haanstra
I want to have a database query run automatically on a Progress database. To do that I created a scheduled task to open a certain Excel sheet which contains a auto_open macro. The auto_open macro runs another macro which runs the query and copies data to a new workbook if a certain requirement is met.
Now the thing is that when I run the macro I keep being asked to enter a password. This should be done automatically. I have found in the Progress knowledge base that you can bypass this password prompting by creating a file dsn. When I now start Excel and create a new database query and choose the file dsn, it indeed doesn't ask for a password. But not I want to automate this in my Excel macro. In the usual VBA connect string I cannot reference a file dsn though, just a normal dsn. Do you know a way to handle this issue?
Thanks,
Cynthia Haanstra