Filename or path difficulty in a macro

Hi, all - I am having trouble running a macro in Access 2000. In an
action within the macro, it is set up to import data from an excel
file. When I try to run it, I get an error message:

The Microsoft Jet database enginecould not find the object
'(filename)'. Make sure the object exists and that you spell its name
and the path name correctly.

This macro works fine on the computer of the person sending it to me,
but when I unzip it, I get the error message, even after I adjust the
filename to include the path to my local directory.

Any help is greatly appreciated

re: Filename or path difficulty in a macro

Sean wrote:[color=blue]
> Hi, all - I am having trouble running a macro in Access 2000. In an
> action within the macro, it is set up to import data from an excel
> file. When I try to run it, I get an error message:
>
> The Microsoft Jet database enginecould not find the object
> '(filename)'. Make sure the object exists and that you spell its name
> and the path name correctly.
>
> This macro works fine on the computer of the person sending it to me,
> but when I unzip it, I get the error message, even after I adjust the
> filename to include the path to my local directory.
>
> Any help is greatly appreciated[/color]

Try importing the Excel file manually to make sure that works?
--
regards,

Br@dley

re: Filename or path difficulty in a macro

it definitely works. In the macro designed to Transfer the spreadsheet
into the database, I can manually change the filename so that it's
tailored to my computer (ie. Filename: c:\My Documents\Filename to
c:\Documents and Settings\...\Filename, where the dot dot dot is my
actual path). what I'm looking for is what to type so that I don't
have to enter it manually, so that the database will find it. Not a
big deal for me, but then I have to deploy this to a team of people who
it would be time-intensive to teach how. It would just be a lot easier
if there is something streamlined I could put in so it's all ready to
run when it shows up on other people's pcs.

again, any help would be great.