Access 2007 VBA code for formatting Excel output is not working
Posted on 2013-05-12
I recently had my work computer's hard drive replaced and re imaged. A database, that I backed up, that worked before is no longer working properly. The database would output Excel spreadsheets and then format them. I have not changed the vb code, I have only changed computers.
I have had something similar happen before and the solution was to recreate the db and transfer all (tables, queries, forms, etc) from old to new. This solution has not worked this time around.
I have checked the References of the backed up db verses the new db and see no differences.
Has anyone experienced and resolved something of this sort?
Thanks in advance.