Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » External Data » VBA (RSS)

Browse by Tags

Sorry, but there are no more tags available to filter with.

  • Lessons in SQL

    Here's some code I have to generate a SQL statement Public Function BuildRepSQL(ByRef clsRepLine As CRepLine, eType As aiDBStatus) As String       Dim sReturn As String       With clsRepLine         Select Case eType             Case aidbstatusdelete                 sReturn = "DELETE * FROM tblRepLine WHERE [...] Read More...
    Filed under: ,

  • Create a QueryTable from an Excel Source in VBA

    Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...] Read More...
    Filed under: ,
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.