I have data from an outside text file that I'm linking to in Access. I'm
then using the Access VBA to create an Excel workbook (I was going to try to
use TransferSpreadsheet, but the format and cell placement was too tricky).
The problem is that when I try to set the Formula property from Access, it
doesn't work. It just copies it as a string. I posted this in the Access
Programming as well, but since I'm doing it from Access, it gets a bit
complicated and I'm not sure exactly where it fits.