This is FANTASTIC!
Thanks for sharing!!!
Brilliant (can you tell I'm in the UK this week?)
I second Tim's review! It is a great tool. Thank you for sharing.
A couple of things I noticed that others will need to be aware of:
- I needed to use a different form of connection string - http://www.connectionstrings.com/ is a great resource.
- The hyperlink is hardcoded to your vault (WestportEPDM) - I needed to Find/Replace with my vault name.
- click on the Path to be taken to the file in the vault, click on the file to open the file, click on the version to look at its history.
Once again, excellent tool - thanks for sharing
You are right. The user can add a constant right next to the connection string constant
Const strMyVault = "WestportEPDM" or whatever the company name is
Then replace "WestportEPDM" with strMyVault.
Good point. Sometimes I forget that I have hard coded strings in my code. I know it's generally bad practice, but I program alot of vapor ware
Thanks, Kent. This works great!
This is awsome.
Is there anyway i can bring the list of report selection window ,once i've generate a report. currently i am running the macro again.
Once again Thanks
Cntr-Shift-R will run the report again. Or, you can go the the developer ribbon, macro, run ShowReportForm.
Very nice tool, works well. I have little question.
How can I make it to pull out list of all files in specific folder and sub folders.
I have tried to search web and modify it but seems that my knowledge about SQL queries are not enough.
Hope that somebody can help me out or show some direction where can I find more information about that.