How to find the path to the downloads folder when it is different for each user

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to find the path to the downloads folder when it is different for each user

12-07-2012, 08:41 PM

macropod

Windows 7 64bit How to find the path to the downloads folder when it is different for each user

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Try:
Set fls = fso.GetFolder("C:\Users\" & Environ("UserName") & "\Downloads").Files

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Prompt the user to Replace	Lawmuse	Word VBA	9	02-27-2023 06:36 AM
How to find complete path to email from search window?	Jennifer Murphy	Outlook	1	08-12-2011 03:36 PM
User cannot move email messages within Outlook Inbox folder and sub-folders.	Darsss	Outlook	5	06-06-2011 11:37 PM
Update Outlook but user path changed	Ossie1972	Outlook	1	12-08-2010 08:19 PM
Outlook problem - Open Other User’s Folder doesn’t show Sent	imported_bankboysb	Outlook	0	12-12-2005 11:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:32 AM.