kguerrero
06-15-2012, 10:38 AM
Hi,
In excel's connection properties, I have an SQL command that looks like this:
SELECT
himpl_wiplog_0.w, himpl_wiplog_0.u, himpl_wiplog_0.logfile,
himpl_wiplog_0.e, himpl_wiplog_0.d, himpl_wiplog_0.c,
himpl_wiplog_0.s, himpl_wiplog_0.sc, himpl_wiplog_0.pos_no,
himpl_wiplog_0.type
FROM
process.himpl_wiplog himpl_wiplog_0
WHERE
himpl_wiplog_0.logfile="J70"
ORDER BY
himpl_wiplog_0.ped_pos_no
I'd like to create VBA script to change the "J70" to another value. A point in the right direction will be very helpful.
I'd like to use VBA script since I'll also be using this value in other aspects (ie exporting sheets to CSV).
Thanks a ton,
In excel's connection properties, I have an SQL command that looks like this:
SELECT
himpl_wiplog_0.w, himpl_wiplog_0.u, himpl_wiplog_0.logfile,
himpl_wiplog_0.e, himpl_wiplog_0.d, himpl_wiplog_0.c,
himpl_wiplog_0.s, himpl_wiplog_0.sc, himpl_wiplog_0.pos_no,
himpl_wiplog_0.type
FROM
process.himpl_wiplog himpl_wiplog_0
WHERE
himpl_wiplog_0.logfile="J70"
ORDER BY
himpl_wiplog_0.ped_pos_no
I'd like to create VBA script to change the "J70" to another value. A point in the right direction will be very helpful.
I'd like to use VBA script since I'll also be using this value in other aspects (ie exporting sheets to CSV).
Thanks a ton,