Results 1 to 10 of 40

Thread: Notes tests. Excel VBA Folder File Search

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 02-09-2017, 02:39 PM #1
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    In support of this Thread Question
    https://excel.tips.net/T008233_Findi...e_Desktop.html
    https://excel.tips.net/T008233_Finding_the_Path_to_the_Desktop.html



    …………………… I tried this one
    sPath = Environ("USERPROFILE") & "\Desktop"

    It didn't work for me, because I had moved my desktop to another location.
    Is there a way to find the 'actual' placement?....    ...................................


    [FONT=Arial][size=3] [color="#3E0000"]

    Demo Example

    Download both files. Put both in the same folder. ( Unzip the zipped file
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by DocAElstein; 01-31-2020 at 11:54 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Tests and Notes on Range Referrencing
    By DocAElstein in forum Test Area
    Replies: 70
    Last Post: 02-20-2024, 01:54 AM
  2. Tests and Notes for EMail Threads
    By DocAElstein in forum Test Area
    Replies: 29
    Last Post: 11-15-2022, 04:39 PM
  3. Notes tests. ByVal ByRef Application.Run.OnTime Multiple Variable Arguments ByRef ByVal
    By DocAElstein in forum Test Area
    Replies: 37
    Last Post: 02-28-2018, 12:22 AM
  4. Move File From One Folder To Another Folder Within Mapped Drive using VBA in Excel
    By ashmakda in forum Excel Help
    Replies: 1
    Last Post: 02-14-2013, 12:09 PM
  5. List File name in folder to excel with images
    By Ryan_Bernal in forum Excel Help
    Replies: 2
    Last Post: 01-15-2013, 11:37 AM

Bookmarks

Posting Permissions

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

Forum Rules