lkpdolphin.blogg.se

Then you can write code to do whatever you want with the filename. This method simply returns the user-selected filename as a string. The GetOpenFilename method doesn’t actually open the specified file. The GetOpenFilename method displays the familiar Open dialog box (a dead ringer for the dialog box Excel displays when you choose File → Open → Browse). I understand that I need to use the ChDrive function in order to nominate a folder on a network drive. How do I specify the file path in vba code in powerpoint 2011 for mac? Hi, I am trying to use the GetOpenFileName function for a network folder location. For a better solution to this problem, use the GetOpenFilename method of the Application object, which ensures that your code gets its hands on a valid filename, including its complete path. In other words, it’s far too easy to screw up when typing a filename. An input box usually isn’t the best tool for this job, however, because most users find it difficult to remember paths, backslashes, filenames, and file extensions. By If your VBA procedure needs to ask the user for a filename, you could use the InputBox function and let the Excel user do some typing.