Hi,

I think you're going to have to provide additional details. Are you
using a command button on an Access Form? Does the button run a macro or
a procedure? Are you trying to open Excel from Access (macro=RunApp
action, Shell() in VBA)? Are you trying to import data from a single
linked spreadsheet into your db? Or choose from several spreadsheet
files? What kind of file are you trying to open after you fetch the
Excel data? What kind of "manipulations" and "calculations" are we
talking about?

LeAnne

mseifert_99 wrote:
First off let me say that I know that this is not a Access Forum .. but
I have tried repeated to get my data into a Access table and it is not
working.. So this is what I am hoping to accomplish in Excel... Since
my knowledge of Excel far exceeds my knowledge of Access...

What I want to do is put a command button in Access that opens an Excel
add-in spreadsheet. then it will at first prompt you to select a file to
manipulate and then when the file is opened manipulate the spreadsheet
the way that I want it to. So that I can import it into Access...
Without having to do all the crazy calculations in an Access Query ...


Hopefully someone can help ....