![]() ![]() ![]() A Macro in this file creates a Copy of a specific Sheet within the Active Workbook and I want to Save it to the individual's Desktop. I have a VBMacro Excel file loaded on a Server that numerous people access. 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. But, some of the people using this may have XP and some may have Windows 7. On my computer, which is Windows XP, it happens to be MyDocuments. But, I want it to revert back to the default directory (no matter what that was). 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?). 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 googled and found answers to part of my question but not the complete question. To use multiple MS-DOS wildcard expressions for a single file filter type, separate the wildcard expressions with semicolons for example, 'Visual Basic Files (*.bas *.txt),*.bas *.txt'. For example, the following string specifies two file filters- text and addin: 'Text Files (*.txt),*.txt,Add-In Files (*.xla),*.xla'. A Macro in this file creates a Copy of a specific Sheet. › Getopenfilename Default File Path Access █ ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |