John, I guess I didn't make my situation clear. Imagine I create the workbook "SpanishTest.xlm" and save it in folder
C:\Users\George\My Documents\Timothy's Academics\Timothy's Spanish\
Imagine further that this folder, besides containing "SpanishTest.xlm" also contains the folder "Sounds". If I want to play the sound Testing123.wav, I could do so using the following code
mypath = "C:\Users\George\My Documents\Timothy's Academics\Timothy's Spanish\Sounds\Testing123.wav"
sndPlaySound32 mypath, 0&
Now Imagine that I save the entire folder
C:\Users\George\My Documents\Timothy's Academics\Timothy's Spanish
to a thumb drive and copy it to the desktop of Timothy's computer. I go into this folder on the desktop of Timothy's computer and doubleclick on SpanishTest.xlm. Now the code to play Testing123.wav won't work because the specified path is no longer relevant. I don't want to have to change the VBA code every time I move the folder
to a new location.
Recall that when you try to do a "Save As" in Excel, the program remembers the path from which the workbook was loaded and suggests this path as the location to which the new workbook will be saved. What I am trying to do is find out how I might use VBA to grab hold of that suggested path, put the path into a string variable, and use this string variable to create the path to the folder "Sounds" where the file Testing123.wav is located. The folder "Sounds"will always be in the same folder as the folder from which Spanishtest.xlm, the active workbook, was loaded.