Link to home
Start Free TrialLog in
Avatar of kwarden13
kwarden13

asked on

Named Ranges: Access 2007 to Excel 2007

When I export from Access 2007 to Excel 2007, my name range in Excel overwrites and it causes excel to create a new tab instead of exporting directly to the named range specified.

Basically the named range is giving a REF error because the export query is not always the same amount of record/lines.
It changed everytime, either expanding or shrinking.

Please I need help!
Avatar of Mike Eghtebas
Mike Eghtebas
Flag of United States of America image

The best way to handle it to have a MS Query installed to activate from withing Excel where it ajusts the number of rows as required.

Is this a new design or it is an existing solution that worked for before?

Mike
Avatar of kwarden13
kwarden13

ASKER

a new design
I saw your other question.

If you are working a lot with Excel, you may like the idea of using MS Query. It is a bit hectic to build and assign parameters but doable.

You can bult MS Query (in Excel, or some other methods... will discuss later). This way, the user of excel can click on a button to reftesh the data. Als, excel user is able to enter some criteria (such as customer name, City, etc.) in some excel cells before refreshing the data.

This means, you don't put criteria in Access query. The criteria is supplied with Excel user.

Mike
i'll give it a try and see if that works
Access Query won't work for me as I can't let the Excel user have that access. I need it to be restricted and locked if i do use it. I think an export using transferspreadsheet would be better so back to my original question: How can I accomplish this?
ASKER CERTIFIED SOLUTION
Avatar of Mike Eghtebas
Mike Eghtebas
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial