Prev: Case statement Problem not resolved
Next: Access Xp Record Locking
From: Javier71 on 4 Jul 2008 23:05
I have developed an application in Access 2003 and within this application I
created a Macro that exports some records to excel, it works perfect on
Access 2003 but when I run the application on Access 2007, the Macro doesn't
work. Even if I use the toolbar button provided by Access 2007 to export to
Excel 2007 it doesn't work either. Is this a problem with Office 2007 ?? Can
anybody help me? This is urgent!
--
JR
From: Allen Browne on 5 Jul 2008 00:59
Do any of your code/macros run? If not, it may be a matter of trusting the
folder where your database is.

Go to:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

If that is not the issue, this Jan 28 hotfix does address an export failure
with the XLS format:
http://support.microsoft.com/kb/943249

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Javier71" <Javier71(a)discussions.microsoft.com> wrote in message
news:FAECB227-D7A4-4730-BD58-324CA1A9D967(a)microsoft.com...
>I have developed an application in Access 2003 and within this application
>I
> created a Macro that exports some records to excel, it works perfect on
> Access 2003 but when I run the application on Access 2007, the Macro
> doesn't
> work. Even if I use the toolbar button provided by Access 2007 to export
> to
> Excel 2007 it doesn't work either. Is this a problem with Office 2007 ??
> Can
> anybody help me? This is urgent!
> --
> JR

 | 
Pages: 1
Prev: Case statement Problem not resolved
Next: Access Xp Record Locking