Export Excel file on mapped drive

[allyn44]

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

[Tom van Stiphout]

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

[allyn44]

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