#1
|
|||
|
|||
a problem with the "Documents" folder location in VBA !!
TaskID = Shell("C:\Users\%username%\Documents", vbNormalFocus) i want to open the Documents folder by macro on any user !! the problem is here "%username%" !!! |
#2
|
||||
|
||||
You probably should be using:
TaskID = Shell("C:\Users\" & Environ("UserName") & "\Documents", vbNormalFocus)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Cross-posted at: http://www.vbaexpress.com/forum/showthread.php?t=43965
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2010 "Unread Mail" folder missing | Emerogork | Outlook | 11 | 03-07-2013 03:32 PM |
Import holidays without "location" info | SteveRomo | Outlook | 0 | 08-10-2012 03:54 PM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
direct incoming email to "outlook" folder inbox | John Ames | Outlook | 8 | 06-25-2011 02:51 PM |
outlook "Unread Email" folder automaticaly reads then dissapears emails | michaelrj9 | Office | 0 | 08-20-2010 03:59 PM |