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

Export Excel file on mapped drive

P: n/a
Hi,
I have a small databse that outputs 2 excel files to a folder.

DoCmd.TransferSpreadsheet acExport, , "randtrack",_
"C:\randomization\Trackrandomization.xls"

The person wants to put the database on a Mapped drive which shows as
their H drive:

path
test2$ on server1 (H:)

My question is that if put the database on that mapped drive (H) can I
just use the drive letter as the export target or do I need the full
network path?

thanks for your help
Bob
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, 19 Jul 2005 21:39:36 -0700, al*****@cox.net wrote:

The elegant solution is to ask for the destination path using a
File/SaveAs dialog, and save that user selection. Then use it as the
default the next time around.

Quick and Dirty solution is to use "H:\" as the new path.

-Tom.

Hi,
I have a small databse that outputs 2 excel files to a folder.

DoCmd.TransferSpreadsheet acExport, , "randtrack",_
"C:\randomization\Trackrandomization.xls"

The person wants to put the database on a Mapped drive which shows as
their H drive:

path
test2$ on server1 (H:)

My question is that if put the database on that mapped drive (H) can I
just use the drive letter as the export target or do I need the full
network path?

thanks for your help
Bob


Nov 13 '05 #2

P: n/a
Thank you for the input

Bob
On Wed, 20 Jul 2005 07:43:37 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Tue, 19 Jul 2005 21:39:36 -0700, al*****@cox.net wrote:

The elegant solution is to ask for the destination path using a
File/SaveAs dialog, and save that user selection. Then use it as the
default the next time around.

Quick and Dirty solution is to use "H:\" as the new path.

-Tom.

Hi,
I have a small databse that outputs 2 excel files to a folder.

DoCmd.TransferSpreadsheet acExport, , "randtrack",_
"C:\randomization\Trackrandomization.xls"

The person wants to put the database on a Mapped drive which shows as
their H drive:

path
test2$ on server1 (H:)

My question is that if put the database on that mapped drive (H) can I
just use the drive letter as the export target or do I need the full
network path?

thanks for your help
Bob


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.