Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Posts
    41

    Unanswered: Exporting to User's Desktop

    I use a DoCmd.TransferSpreadsheet command, and I am trying to output a file to the user's desktop. This database will run on different versions of windows (XP, 2k, NT) - how do i export a file to wherever the user's desktop happens to be? I tried using the %HOMEDRIVE% variable but it doesnt seem to work. Any ideas?

  2. #2
    Join Date
    Dec 2003
    Location
    Toronto, Ont. Canada
    Posts
    238

    Re: Exporting to User's Desktop

    Originally posted by secutanudu
    I use a DoCmd.TransferSpreadsheet command, and I am trying to output a file to the user's desktop. This database will run on different versions of windows (XP, 2k, NT) - how do i export a file to wherever the user's desktop happens to be? I tried using the %HOMEDRIVE% variable but it doesnt seem to work. Any ideas?
    I went searching online and found this code... Here you go... http://cuinl.tripod.com/Tips/desktoppath.htm
    Works great for me...

    Have a nice day!

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Exporting to User's Desktop

    Originally posted by Trudi
    I went searching online and found this code... Here you go... http://cuinl.tripod.com/Tips/desktoppath.htm
    Works great for me...

    Have a nice day!
    That's fine
    I can need it.
    Thanks

  4. #4
    Join Date
    May 2003
    Posts
    41
    That URL is out of service! Do you have the code?? Could you possibly post it?

  5. #5
    Join Date
    Dec 2003
    Posts
    172
    I did some poking around. I found an alternate link. Try this one:
    http://www.mvps.org/vbnet/index.html...owse/csidl.htm

  6. #6
    Join Date
    Dec 2003
    Location
    Toronto, Ont. Canada
    Posts
    238
    Originally posted by secutanudu
    That URL is out of service! Do you have the code?? Could you possibly post it?
    Ohhh phooey!!! Teach me to delete the code after playing with it...
    It worked so well to... and it wasn't that long and drawn out...

    Let me see if I can find it again...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •