file path separate saving

  1. J

    Extract file List from Explorer to Excel - full path name

    I found the code below on an earlier post from 2002, but it did not give me the full path, including subfolders and file name. It just gave me the files in that particular folder and did not include the subfolders, etc. How do you change it so that I get the full path? I want to use it for an...
    • JSH720
    • Thread
    • excel explorer file name file path separate saving
    • Replies: 2
    • Forum: Excel Questions
  2. G

    Separate Filename and path when saving a file in a macro (excel)

    Hi, Can somebody help in separating Filename and Path when saving a file in a macro (excel). Sub buclechupi333() Dim TempFilePath As String Dim i MiFile = Application.GetOpenFilename(",*.xls") If MiFile = False Then Exit Sub 'Here I have a path and filename (all together) and I can not...

Some videos you may like

This Week's Hot Topics

Top