I
IT
Hello,
In Excel i import information from an external system , (this query was
orginally built in msquery). I then recorded a macro linking to this query
to get the vb code to get the external data.
At the moment in vb i rebuild the sql statement each time i want to import
the data. For example i might want to change the date range of the imported
data.
Is it possible to simply use parameters , like you do in the data
environment in VB6 , as opposed to recreating the sql statement each time.
If so could someone please provide an example of the vb code.
Cheers
In Excel i import information from an external system , (this query was
orginally built in msquery). I then recorded a macro linking to this query
to get the vb code to get the external data.
At the moment in vb i rebuild the sql statement each time i want to import
the data. For example i might want to change the date range of the imported
data.
Is it possible to simply use parameters , like you do in the data
environment in VB6 , as opposed to recreating the sql statement each time.
If so could someone please provide an example of the vb code.
Cheers