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!
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!
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
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
ASKER
i'll give it a try and see if that works
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is this a new design or it is an existing solution that worked for before?
Mike