| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Creating Variable and using variable in a SQL statement
Jimmy It sounds like in your SQL command you have "StartDate" (inside quot marks). You need to remove the quote marks to enable VB to see the variable I have not played around with sql but you may need to do something lik this to enable your StartDate variable "SqlTextCode" & StartDate & "MoreSqlTxtCode -- mudrake ----------------------------------------------------------------------- mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247 View this thread: http://www.excelforum.com/showthread.php?threadid=27188 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable statement | Excel Discussion (Misc queries) | |||
| Variable in if statement | Excel Worksheet Functions | |||
| IF Statement Variable | Excel Discussion (Misc queries) | |||
| if than statement has too many variable | New Users to Excel | |||
| creating macro to ask for variable info when excel starts | Excel Programming | |||
![mudraker[_318_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
