Movian,

I am still trying to picture the trail the data(Date) takes.

It sounds like the data gets pulled from the DB via a Query and pushed into a TextBox, then pushed, via ControlSource, into a spreadsheet Cell, then pulled, via ControlSource, into a TextBox. Obviously, this is not the case, it's just what I gather from your descriptions above

Somewhere in there it gets reformatted from "m/dd/yyyy" to "yyyy-mm-dd."

Finally, some code accesses the TextBox to use the "yyyy-mm-dd" as a Workbook Name.



Can you post the reformat code? Tell us the source, but use a String variable or constant set to a "yyyy-mm-dd" date as a replacement for the actual source. Also use or tell us the destination object.