STRPATH - Save export to excel on the form within the same database

L

learning_codes

Hi,

Right now, I use "strpath" and the database save all files in H:\ FOLDER. I don't want that.

I want the excel files save where the ms access database in L:\Projects\report\ where the access database resides in L:\Projects\

Thanks
 
J

John W. Vinson

Hi,

Right now, I use "strpath" and the database save all files in H:\ FOLDER. I don't want that.

I want the excel files save where the ms access database in L:\Projects\report\ where the access database resides in L:\Projects\

Thanks

Well... you can tell much better than we can what the local, programmed,
non-Access-builtin variable strpath contains.

It's a variable. It's apparently set (somewhere) to "H:\FOLDER". If you'ld
rather it be set to "L:\Projects" just do so.

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:

http://answers.microsoft.com/en-us/office/forum/access?tab=question&status=all
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
and see also http://www.utteraccess.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top