Solved

Access 2007 VBA code for formatting Excel output is not working

Posted on 2013-05-12
5
335 Views
Last Modified: 2013-05-18
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.
0
Comment
Question by:Kebell9
5 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39160360
Whats not working? If no code will run, I would check if the database is trusted. See this article.
If you want to do it manually see this.
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39160520
Did not experience such issue.
Try to recreate the issue using a test database, and upload.
0
 
LVL 84
ID: 39161556
Also be sure that the target directory for the Excel spreadsheet is Trusted. I've had issues with that in the past ...
0
 

Accepted Solution

by:
Kebell9 earned 0 total points
ID: 39162764
All, thanks for the suggestions. I inadvertently resolved the issue by doing a repair to MS Office. I only did this because another office app was having issues. In doing so the issue was resolved.

Thanks Again
0
 

Author Closing Comment

by:Kebell9
ID: 39176916
This was an accidental solution, not one of knowledge. However, the solution will be added to my solution db.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now