By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,487 Members | 1,747 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,487 IT Pros & Developers. It's quick & easy.

Filename or path difficulty in a macro

P: n/a
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

Feb 15 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Br
Sean wrote:
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


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

Br@dley
Feb 15 '06 #2

P: n/a
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.

Feb 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.