Re: open xml output in word

Reference: http://support.microsoft.com/kb/210565

2000,2003

Reference: http://office.microsoft.com/en-us/word/HP101640101033.aspx

2007

Depending on what version of word you will need to navigate to the proper
folder and the use the winword.exe...

example :xp_cmdshell 'C:\Program Files\Microsoft Office\Office\Winword.exe
/a /w'

Problem is, I do not believe you can pass in an XML file for 2000 or 2003.

In 2007 you can use the /pxslt sitch but you will have to save the xml and
the xslt as a file first.

--

/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Jane" <Jane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC26E85E-CFFC-4A63-9989-C361B84634E0@xxxxxxxxxxxxxxxx
I has a sproc that creates xml output using 'Select ... for xml', but I
want
my code to automatically open it in Word, so the user will see the output
in
word and can save it whereever they want. I tried the xp_cmdShell (after
enabling it) - either I'm not using it correctly or something.

This is what I'm doing:
declare @RV as integer
exec @rv = uspCatalogtoXML
xp_cmdshell 'word.exe ' + @RV

but I know the xp_cmdShell line is wrong.

Anyone help?




.

Relevant Pages

  • Re: Referencing your other assemblies in projects
    ... Yeah, I know it seems weird, but I still put winforms applications under the ... I set the working folder ... My company sets up a "Release" folder for commonly used assemblies. ... the dietcoke manager can relatively reference ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Existence and presupposition
    ... The passage from Johnson suggests that the word "reference" had no ... The word "meaning" was first used by Long and White. ... For Frege singular terms, proper nouns and definite descriptions, name ... logic to natural language, who seek formal translations ...
    (sci.logic)
  • Re: Auto Referencing in Word Documnets
    ... *much* faster than browsing a folder structure. ... are still a large number of organizations using the hard-copy based system ... behind the coding may help me to think differently in an entirely ... when the reference number identified the physical file. ...
    (microsoft.public.word.docmanagement)
  • Re: VBA References Problem
    ... a compile error was received. ... When i reviewed the error message it indicated that a reference was missing. ... Mapping" and placed it within the program files folder on the other users PC. ... version of the control; the most understandable description of this is ...
    (microsoft.public.word.docmanagement)
  • Re: Need Help, Trying to learn WCF
    ... private to the class, which worked great. ... reference the new Function. ... the folder where i was saving the application once this was brought to my ... itself, subclasses, and all classes in the same package or directory. ...
    (microsoft.public.dotnet.framework.webservices)
Loading