Hi everyone! I'm using A02 on XP. I have this nice little macro that
ex****ts a query via 'TransferSpreadsheet' and names it using the contract
number ="S:\RPS\PTS\CensusConversion\ToClient\" &
[Forms]![fCensus1Conversion]![RunThisOne] & ".xls"
It has run well for a few years now. The client is sent the ex****ted file,
they update data, add and delete employees and return it. We re-im****t
and
run a few routines on it and re-ex****t it for loading back to the original
system it was extracted from. Now they want to rename a few columns for
the
client. It shouldn't be a big deal and they at least agreed to no spaces
in
the new names BUT...how do I re-rename the columns when the client returns
the file and I re-im****t the data for processing? The renamed fields are:
EXLCOMP to ExcludableCompensation; DEFAMT to DeferralAmount and COMP to
W2Box1. Like I said, I can ex****t the new field name but don't want to
reprogram all my routines when I re-im****t. My re-im****t needs to change
them back.
Can this be done with my limited programming abilities? I do work with
expressions and some VB so would appreciate any and all assistance or
suggestions.
Thank you very much!
--
Bonnie W. Anderson
Cincinnati, OH
