A few possibilities

1) Your file may be on your netwrok drive (usually h:Mydocuments) and a
shortcut gets created in the C: drive under c:\documents and
Setting\username\My Documnets. You may of copied the shortcut insteaad of
the real file.

2) Your path name and filename may be too long. copy the xls file (not the
shortcut) to a Root directory where the file name is shorter.

"misschanda via OfficeKB.com" wrote:

I have a search form in Access, that creates a query and than will Export to
excel once useer selects path: excel 3, excel 4, excel 7 etc. I am not able
to see the file. I have edited the export code to show a message if error,
and no error messages shows.. The process continues and ask me to name file
and etc. I did and name the file test4 and saved it to my desktop. Not seeing
on my desktop I ran a search on my computer and the file name showed as test4.
xls, size: 1kb,
type: shortcut. when i then click on the file it says: Windows is searching
for "test4.xls" To locate click browse.. And after the search it says
"The item test4.xls that this shortcut refers to has been changed or moved so
this shortcut will no longer work properly. Do you want to delete this
shortcut?"

where is the file going to???

thanks
misschanda

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200805/1