View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick S. Rick S. is offline
external usenet poster
 
Posts: 213
Default Open non-Office prog. macro

FYI
Learned from using this example code. The cmd.exe shell is limited to the
old DOS 8.3 file naming conventions.
Thus, a path string like "C:\Mydocument.pdf" would be condensed to
"C:\Mydocu~1.pdf"

--
Regards

Rick
XP Pro
Office 2007



"jonjo" wrote:

Here is the simple version:

Sub Makro1()
Shell "cmd.exe /c start C:\document.pdf"
End Sub

Greetings Jonjo

"Schneider_4" wrote:

Just a warning - I'm not very well versed in VB like this. Here's what I
want to do:

Off of a button in Excel, I want to open a shortcut to another document
(non-office document)which is on my desktop. Let's just say the document's
name is "ABC" for the example. Can someone help me with what the macro text
would look like? TIA -Steve (operating in XP)