Getopenfilename Default File Pathway
I want to use this routine Application.GetOpenFilename to open either a *.txt file OR a whole folder. Is this somehow possible? If no file/folder is selected, the parent's folder path is returned, otherwise the selected filename? The following two procedures allow you to select a file (or multiple files) to open by using the GetOpenFilename dialog box: To open a single file.
Download cabo do medo dublado » cabo do medo dublado could be available for fast direct download. Director: Neil Marshall. Filme Abismo do Medo 2005 Torrent Dublado 1080p. Cabo Do Medo.Dublado.byDuDoG.mp4 341.9 MB. Magnet URI Scheme is a de facto standard defining a uniform resource identifier (URI) scheme for Magnet links, which mainly refer to resources available for download via peer-to-peer networks. »» TRAILER ««. Tags Relacionadas: Abismo do Medo (2005) Dublado – Torrent Download. Abismo do Medo (2005) BRRip 720p Dublado.
I have googled and found answers to part of my question but not the complete question. I want to use Application.GetOpenFilename in Excel VBA to open a file and I want it to open in the same directory as ThisWorkbook.Path. I have found that beforehand I can do OpenPath = ThisWorkbook.Path ChDrive OpenPath ChDir OpenPath But, after that runs, if I run any other Application.GetOpenFilename it will still access that same directory (until perhaps I close Excel???). But, I want it to revert back to the default directory (no matter what that was). On my computer, which is Windows XP, it happens to be MyDocuments. But, some of the people using this may have XP and some may have Windows 7. I can't find anywhere how to figure out what the original default directory was so that I can store this so that I can later reset back to the default.
Any help would be much appreciated.
I'm trying to adopt the Application.GetOpenFilename method, so I can let go of the dependency for comdlg32.ocx, which is not included in Vista. However, I haven't found a way to have GetOpenFilename start with a default filename. Starting in a given directory works (if I call it before calling GetOpenFilename), but I wonder if it's possible to have the dialog box open with a default filename in that directory? That is, when the dialog opens (in the given directory), the default file should be pre-selected. Is that possible?