I am using a SQL Query to pull 1 cell. If there is data it will pull ‘WFM_DATE_PROCESSING’ if it is empty, it will be null. I think I am then assigning that to a data table named dt_res. I then want to assign what is found to TRANS. Then if Trans has ‘WFM_DATE_PROCESSING’ in it, I want to open a Macro.
I think the problem I am having is getting the TRANS to be assigned what is in the dt_res table. Can you help me?