I'm hoping that someone can help me out as I'm sort of new to programming.
I recorded a macro that uses microsoft query to get data from an access database. It works fine as it is, but I want to change the final filter to a variable and I can't seem to get the syntax right no matter what I try. Anyone have any ideas?
The part that I would like to replace with a variable is 'MMMX028762'.
[With ActiveSheet.QueryTables.Add(Connection:=Array(Array("ODBC;DSN=MS Access Database;DBQ=N:\FLEETDIS\Fleet Data References\Fleet DB\Utilization Database with NBVs.mdb;DefaultDir=N:\FLEETDIS"), Array("\Fleet Data References\Fleet DB;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;")), Destination:=Cells(4 + i, 8))
.CommandText = Array("SELECT `Total Fleet Current NA`.`Railcar ID`, `Total Fleet Current NA`.NBV, `Total Fleet Current NA`.`Adj NBV`" & Chr(13) & "" & Chr(10) & "FROM `Total Fleet Current NA` `Total Fleet Current NA`" & Chr(13) & "" & Chr(10) & "WHERE (`Total Fleet Current NA`.", "`Railcar ID`='MMMX028762')")
.Name = "Query from MS Access Database_1"
.FieldNames = False
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = True
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
Any help is most appreciated!!!!