1. A

    ADO Connection question

    Hi, I have a connection between Excel and Access. From Excel, I query Access and use the Recordset method to put the data into a sheet. Can I use this to somehow Update or Edit an actual query that's in Access ? Please advise yes or no. I think its No ! Thanks, ABB
  2. R

    Get Sheet number using ADOX

    Hi All, I m using this function to get the Sheet names in a workbook. But any idea on how i can tweak it so that i do get only the second sheet name of the workbook instead of all. Not able to figure out how to get the specific sheet number. Function GetSheetsNames(WBName As String) As...

Some videos you may like

This Week's Hot Topics