Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 02-24-2014, 03:15 PM
macropod's Avatar
macropod macropod is offline Formula to open external file with specific program (like open with) Windows 7 32bit Formula to open external file with specific program (like open with) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,479
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


I'd still be inclined to leave the file associations alone, as changing them entails messing around with the Windows Registry. A better approach would be to extract the mp3s from the zip files, then play them. Either way, a fair bit of programming would be involved and, for the same reasons the files don't seem to be playing now, I'm not sure that would actually cause the mp3 files to play.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #17  
Old 02-24-2014, 11:39 PM
pemartins pemartins is offline Formula to open external file with specific program (like open with) Windows 8 Formula to open external file with specific program (like open with) Office 2013
Novice
Formula to open external file with specific program (like open with)
 
Join Date: Feb 2014
Posts: 9
pemartins is on a distinguished road
Default

Oh ok for sure it isn't a good idea at all to mess with Windows Registry. I wasn't aware of that.

Another idea I had and don't know if it is possible or not, is to make vba create a .bat and execute it.

So as I mentioned before, if I type this in Run or Cmd:
Code:
"C:\Program Files (x86)\KaraFun Player\KaraFunPlayer.exe" "C:\Users\P\Desktop\Karaokes\Phil Collins - Another Day In Paradise.zip"
it starts KaraFun Player playing Another Day In Paradise.

If I make a .bat file with this exact content and nothing more or less, as I double click on it it also works perfectly, starting KaraFun Player playing Another Day In Paradise (just tested it).

So could it be done in vba to create a .bat file for each time needed, with the cell containing the path of KaraFun Player.exe and the cell of the chosen song (a cell containing the full path and file name of the song zip file) and then execute it after been created?

EDIT: And then also delete the created .bat file after it has been executed?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to open external file with specific program (like open with) can I run a macro when I open a specific doc ?? ximpostor Word VBA 10 10-12-2012 12:35 PM
Preventing word/excel from trying to open external template locations Perhill Office 0 03-02-2011 04:44 AM
changing default program from works to word to open attachments catskier Outlook 0 03-10-2009 01:35 PM
Can't open the program/Was trying to setup email lbauge Outlook 1 04-18-2006 03:40 AM
I cannot open a hyperlink in an office 2003 program ArmandoS Office 3 11-26-2005 12:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft