Excel 2010 VBA Tutorial 98 - Combining Data from Multiple Spreadsheets using ADO

[RobMynatt]

Hello, I have ODBC connections in a workbook, and I want to put that workbook in a share folder so that other users can access it. However, when other users from their computer try to open it, it prompts then to set up all the connections again. Is it possible achieve this without manually setting up connections on other users computer? Thanks in advance!

[bofengzhao]

Hello Matt, May I ask that why do you need RecordCount > 0?  Thank you very much! Matthew

[Lineatus]

Hello, I am wondering if you can help me. I need to batch upload a number of excel based forms into a vba data base. There is a lot of info to move across and I cannot seem to get the code to do it. No errors appear and going through step by step, all my variables become coded to what I would expect them to be but when the  "  cmd.Parameters.append param##" finishes and "cmd.Execute" is run, no records are uploaded to the database. I would love to upload the code but it has 92 parameters and is a bit nuts!