Search results for query: *

Thanks for the Excel tip on Application.GetOpenFileName(). I tried it and it does capture the full path along with the name of a file clicked on. I found code that does what my prompt says: "Choose a folder". Code: Function BrowseFolder(Title As String, _ Optional InitialFolder As...

I tried this code in Excel 2003 and it tries to open a file I select: dlgAnswer = Application.Dialogs(xlDialogOpen).Show The code is executed from a command button on a worksheet. What I want to do is navigate to a folder, click on any type of file, and then parse out the path to store it in a...

Thank you starduspater for taking the time to test the original code to play both MIDI and MP3 files on an XP PC, and letting me know that it worked. After running the Excel 2003/VBA application, which uses mciSendString to play MIDI and MP3, and finding that MP3 files played on my Windows 7 PC...

My solution to playing MP3 and MIDI files from an Excel workbook, which will run in both Windows 7 and XP, is to use a WindowsMediaPlayer control on the worksheet. From References in the VB editor, I added "Windows Media Player" from the list of references. Code to start and stop the player...

I am working on a personal Excel program the plays MP3 and MIDI files stored on disk. The VBA code to play audio files works flawlessly on my Windows 7 laptop, however when I run the same code on a Windows XP PC, there are no error messages, and no sound. Maybe someone out there knows that...