I have created an excel macro to run SQL queries whereby the user can run the query on certain criteria which is built in on one of the worksheets. The macro is running perfectly fine.

However, I was looking for a recommendation on some better way of making this macro more effective .i.e. rather than running it through the excel, is there a better way to have it developed through some VBA forms and users can access it directly through some short-cut on the desktop.

  • 1
    Question: How do you want your output formatted? You can run vbs script, but if you want any specific format you have to code it yourself. What kind of database are you running it against? ms access, mysql,mariadb, or etc? – cybernard Feb 19 '19 at 0:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.