473,327 Members | 2,103 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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

Feb 15 '06 #1
2 1976
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: hokiegal99 | last post by:
I've written a small script (with much help from this list) that searches through a directory for files without a PC filename extension like .doc .xls and then adds them. The reason for writing the...
17
by: Sean Ross | last post by:
Hi. Recently I made a small script to do some file transferring (among other things). I wanted to monitor the progress of the file transfer, so I needed to know the size of the files I was...
1
by: Matt | last post by:
In test() method: var path="C:\test\hello.txt"; //returns -1 for path.lastIndexOf("\\"). why?? var pos=path.lastIndexOf("\\"); //return -1 But in showFile() method: We are able to get the...
2
by: Rob Cowie | last post by:
Hi, Given a string representing the path to a file, what is the best way to get at the filename? Does the OS module provide a function to parse the path? or is it acceptable to split the string...
2
by: Xam | last post by:
Hello everybody Do you know of a javascript routine that can warn if there are any pre-defined invalid chars in the filename of an INPUT file box before it is submitted with the submit button. ...
2
by: Csharper95 | last post by:
I want to get the file name and path from a SaveFileDialog (for a 'save as' operation) after the user has saved the information under a new file name (and presumably under a new path) ? I want...
10
by: Brian Gruber | last post by:
Hi, I'm looking for a way to rename a whole directory of files in short order. The files in the directory have different lengths, however all of them end with _xxxx the x's represent a randomly...
8
by: Lad | last post by:
Hello, what is a way to get the the extension of a filename from the path? E.g., on my XP windows the path can be C:\Pictures\MyDocs\test.txt and I would like to get the the extension of the...
1
by: newton2000 | last post by:
How can I use the preprocessor functions to get the __FILE__ macro only with the filename (without the path). The reason is that the objects are different when complied on different machines...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.