Dave, try the ShellExec API. Very easy to use and it takes care of that problem.
On Sun, 13 Feb 2005 00:08:28 -0500, David Wit <[EMAIL PROTECTED]> wrote: > > > I am writing in excel 2000 VB module > > Looking for a way to open start Adobe Reader with a specific file. > > I can get it to work using the Shell(path\file,1) method only if I use the > dos directory names. (i.e. c:\mydocu~1\) > > However, I won't know for sure where the file I want to open is so I get the > path using workbook.path method. > This returns the full path (i.e. c:my documents) and the file won't open. > > any easy Ideas how to make this work? > > David > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [email protected] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > Yahoo! Groups Links > > > > > -- --- Don Roberts - [EMAIL PROTECTED] http://www.drscripting.com http://www.freakingidiot.com '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
