Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File Import from desktop with XP

Status
Not open for further replies.
kbWilliamson

kbWilliamson

Programmer
Feb 28, 2002
18
US
I have an access mdb that will be installed on multiple pc's with runtime (each standing alone.) Part of the process is to import a text file that the individual receives via e-mail. Prior to XP they would drag the file to the desktop and then click a button that ran a macro to import. With XP the path to the desktop changes with each login so each itteration of the macro must be edited and only one login will work. Is there a way to get to the active desktop or a way to read the path to the file?
 
Sort by date Sort by votes
Ok... so I've got to pay closer attention. The path is
"C:\Documents and Settings\ALL USERS\Desktop"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
626
OCM
OCM
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
496
Moss100
Moss100
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
529
lmcate
lmcate
EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
120
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Searching for a way to get Access to retrieve and use data from a hard drive file not within Access 3
Replies
13
Views
245
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top