Recent content by Zak

Thank you Paul

Please use as to your requirement following Code to Import Data into your Excel. You can change SQL as per your requirement. IF require you can convert all Imported data as Copy Paste Value afterward. Cheers.. Public Sub ExportToExcel() Dim cn As ADODB.Connection Dim rs As...

This could be also done through building dynamic linkage between your Excel template and DB if the reportare to be dynamic and periodically updated. You will just need to Refresh the data manually or set a small code to Referesh it on Document Load event. There is lot of variation when you link...

I am Zak, lives in Toronto. Recently got into a project in Access 2007. IT was interesting project where I had to develop FE and BE model for client data. There were some challenging issues and I had to do alot of search to find relevant replies. I found this site with few solution and thought...