I have a batchmacro that I use in Ruby with Word 2003. I converted to Word
2007 and now it doesn't work. Can anyone tell me how to change the code?
The code is below:
# batchmacro.rb
# Ruby script for batch running Word macros
require 'win32ole'
# Launch new instance of Word
wrd = WIN32OLE.new('Word.Application')
wrd.Visible = 1
# First argument to script is the name of the macro
macro1 = ARGV.shift()
# Everything else is a document on which to run the macro
ARGV.each do |file|
doc = wrd.Documents.Open(File.expand_path(file))
wrd.Run(macro1)
doc.Save()
doc.Close()
end
wrd.Quit()
I'm not sure I can help, but I'm interested in what you're doing. However,
you didn't provide details of the failure(s); please do so.
Craig
···
On 8/22/07, Inge Zwart <inge@ttimed.com> wrote:
I have a batchmacro that I use in Ruby with Word 2003. I converted to
Word
2007 and now it doesn't work. Can anyone tell me how to change the code?
The code is below:
# batchmacro.rb
# Ruby script for batch running Word macros
require 'win32ole'
# Launch new instance of Word
wrd = WIN32OLE.new('Word.Application')
wrd.Visible = 1
# First argument to script is the name of the macro
macro1 = ARGV.shift()
# Everything else is a document on which to run the macro
ARGV.each do |file|
doc = wrd.Documents.Open(File.expand_path(file))
wrd.Run(macro1)
doc.Save()
doc.Close()
end
wrd.Quit()
Inge Zwart wrote:
doc = wrd.Documents.Open(File.expand_path(file))
I'm assuming the same code ran on the same files (or copies of) using
Word 2003, and so the only change has been the version of Word.
I am not running Word 2007, so I couldn't test this, but I couldn't find
any evidence/discussion online of changes to the Documents.Open method
for 2007.
The Microsoft Word 2007 documentation for the Documents.Open method is
here:
http://msdn2.microsoft.com/en-us/library/bb216319.aspx
Just guessing, but you might try passing optional parameters, such as:
doc = wrd.Documents.Open(File.expand_path(file), false, true)
David
···
--
Posted via http://www.ruby-forum.com/\.
Also, even though it looks like you have a good idea of what you're doing
with the Word object model, these articles at the Ruby on Windows blog might
be helpful:
Craig
···
On 8/22/07, Craig Demyanovich <cdemyanovich@gmail.com> wrote:
I'm not sure I can help, but I'm interested in what you're doing. However,
you didn't provide details of the failure(s); please do so.
Craig
On 8/22/07, Inge Zwart <inge@ttimed.com> wrote:
>
> I have a batchmacro that I use in Ruby with Word 2003. I converted to
> Word
> 2007 and now it doesn't work. Can anyone tell me how to change the
> code?
> The code is below:
>
>
> # batchmacro.rb
> # Ruby script for batch running Word macros
>
> require 'win32ole'
>
> # Launch new instance of Word
> wrd = WIN32OLE.new('Word.Application')
>
> wrd.Visible = 1
>
> # First argument to script is the name of the macro
> macro1 = ARGV.shift()
>
> # Everything else is a document on which to run the macro
> ARGV.each do |file|
> doc = wrd.Documents.Open(File.expand_path(file))
> wrd.Run(macro1)
> doc.Save()
> doc.Close()
> end
>
> wrd.Quit()
>
>
Craig,
Thanks for your e-mail. It is stopping at the Open command - it opens Word
but then doesn't load the first document.
I'm running a macro on a bunch of Word documents that sets the paper trays
for printing.
Thanks again for your help.
Inge
Inge H. Zwart, RN, BSN
TeleTrans, Inc.
Medical Transcription Specialists since 1989
Phone: 623-505-4423 / 877-495-9041
Fax: 623-505-4423
···
-----Original Message-----
From: Craig Demyanovich [mailto:cdemyanovich@gmail.com]
Sent: Wednesday, August 22, 2007 2:34 PM
To: ruby-talk ML
Subject: Re: Ruby & Word 2007 help
I'm not sure I can help, but I'm interested in what you're doing. However,
you didn't provide details of the failure(s); please do so.
Craig
On 8/22/07, Inge Zwart <inge@ttimed.com> wrote:
I have a batchmacro that I use in Ruby with Word 2003. I converted to
Word
2007 and now it doesn't work. Can anyone tell me how to change the code?
The code is below:
# batchmacro.rb
# Ruby script for batch running Word macros
require 'win32ole'
# Launch new instance of Word
wrd = WIN32OLE.new('Word.Application')
wrd.Visible = 1
# First argument to script is the name of the macro
macro1 = ARGV.shift()
# Everything else is a document on which to run the macro
ARGV.each do |file|
doc = wrd.Documents.Open(File.expand_path(file))
wrd.Run(macro1)
doc.Save()
doc.Close()
end
wrd.Quit()
David,
Thanks for your help. I tried changing the Open code and this is the error I received:
Batchmacro.rb:16:in 'method_missing': Open (WIN30LERuntineError)
OLE error code:800A1436 in Microsoft Word
(C:\/daily%20print%20batch/Corzo%20Jr...)
HRESULT error code:0x80020009
from batchmacro.rb:15:in 'each'
from batchmacro.rb:15
Inge H. Zwart, RN, BSN
TeleTrans, Inc.
Medical Transcription Specialists since 1989
Phone: 623-505-4423 / 877-495-9041
Fax: 623-505-4423
···
-----Original Message-----
From: list-bounce@example.com [mailto:list-bounce@example.com] On Behalf Of David Mullet
Sent: Thursday, August 23, 2007 6:48 AM
To: ruby-talk ML
Subject: Re: Ruby & Word 2007 help
Inge Zwart wrote:
doc = wrd.Documents.Open(File.expand_path(file))
I'm assuming the same code ran on the same files (or copies of) using
Word 2003, and so the only change has been the version of Word.
I am not running Word 2007, so I couldn't test this, but I couldn't find
any evidence/discussion online of changes to the Documents.Open method
for 2007.
The Microsoft Word 2007 documentation for the Documents.Open method is
here:
http://msdn2.microsoft.com/en-us/library/bb216319.aspx
Just guessing, but you might try passing optional parameters, such as:
doc = wrd.Documents.Open(File.expand_path(file), false, true)
David
--
Posted via http://www.ruby-forum.com/\.
The documentation for Documents.Open lists two required parameters. The
first one is FileName, and the second is Format. What's strange, though, is
that Format is listed both as optional and required. Is that just a typo,
since the description for each listing of the Format parameter is very
similar?
···
On 8/23/07, David Mullet <david.mullet@gmail.com> wrote:
Inge Zwart wrote:
>
> doc = wrd.Documents.Open(File.expand_path(file))
>
I'm assuming the same code ran on the same files (or copies of) using
Word 2003, and so the only change has been the version of Word.
I am not running Word 2007, so I couldn't test this, but I couldn't find
any evidence/discussion online of changes to the Documents.Open method
for 2007.
The Microsoft Word 2007 documentation for the Documents.Open method is
here:
http://msdn2.microsoft.com/en-us/library/bb216319.aspx
Just guessing, but you might try passing optional parameters, such as:
doc = wrd.Documents.Open(File.expand_path(file), false, true)
David
http://rubyonwindows.blogspot.com
--
Posted via http://www.ruby-forum.com/\.
I don't have Word 2007 here, so I can't duplicate your environment. However,
here are a couple questions that I'd ask myself at this point.
Has the Word object model changed in Word 2007 in some way that doesn't work
as expected but doesn't cause a noticeable error message?
Might there be a file format conversion dialog that simply isn't being shown
in front of Word and which is waiting for you to answer?
If I think of anything else, I'll reply again. Good luck.
Craig
···
On 8/22/07, Inge Zwart <inge@ttimed.com> wrote:
Craig,
Thanks for your e-mail. It is stopping at the Open command - it opens
Word
but then doesn't load the first document.
I'm running a macro on a bunch of Word documents that sets the paper trays
for printing.
Thanks again for your help.
Inge
Inge H. Zwart, RN, BSN
TeleTrans, Inc.
Medical Transcription Specialists since 1989
Phone: 623-505-4423 / 877-495-9041
Fax: 623-505-4423
-----Original Message-----
From: Craig Demyanovich [mailto:cdemyanovich@gmail.com]
Sent: Wednesday, August 22, 2007 2:34 PM
To: ruby-talk ML
Subject: Re: Ruby & Word 2007 help
I'm not sure I can help, but I'm interested in what you're doing. However,
you didn't provide details of the failure(s); please do so.
Craig
On 8/22/07, Inge Zwart <inge@ttimed.com> wrote:
>
> I have a batchmacro that I use in Ruby with Word 2003. I converted to
> Word
> 2007 and now it doesn't work. Can anyone tell me how to change the
code?
> The code is below:
>
>
> # batchmacro.rb
> # Ruby script for batch running Word macros
>
> require 'win32ole'
>
> # Launch new instance of Word
> wrd = WIN32OLE.new('Word.Application')
>
> wrd.Visible = 1
>
> # First argument to script is the name of the macro
> macro1 = ARGV.shift()
>
> # Everything else is a document on which to run the macro
> ARGV.each do |file|
> doc = wrd.Documents.Open(File.expand_path(file))
> wrd.Run(macro1)
> doc.Save()
> doc.Close()
> end
>
> wrd.Quit()
>
>
Inge Zwart wrote:
David,
Thanks for your help. I tried changing the Open code and this is the
error I received:
Batchmacro.rb:16:in 'method_missing': Open (WIN30LERuntineError)
OLE error code:800A1436 in Microsoft Word
(C:\/daily%20print%20batch/Corzo%20Jr...)
HRESULT error code:0x80020009
from batchmacro.rb:15:in 'each'
from batchmacro.rb:15
Double-check the filename string that is being passed to the
Documents.Open method. It may be getting mangled somewhere along the
line, with regard to backslashes and/or spaces.
David
···
--
Posted via http://www.ruby-forum.com/\.
Craig Demyanovich wrote:
The documentation for Documents.Open lists two required parameters. The
first one is FileName, and the second is Format. What's strange, though,
is
that Format is listed both as optional and required. Is that just a
typo,
since the description for each listing of the Format parameter is very
similar?
I suspect that it is a typo, for the reason you mentioned. Also,
required parameters are usually (in my experience) near the front of the
list.
David
···
--
Posted via http://www.ruby-forum.com/\.
Just a quick hint, since it's saved me a few times when the MSDN site
didn't have good info, use the ole_get_methods, or its analog
ole_methods.
The help method, ole_method_help(), usually doesn't do much other than
return the name of the method in my experience, but heck, try it 
maybe you'll have more luck.
--Kyle
This problem has captured my attention. I downloaded and installed a trial
of Office 2007. Since the error was that the Documents.Open method was
missing, I focused my investigation around it. I determined that the method
exists and is available to call. Therefore, I decided to write a small
program that tries opening a document that is specified in a few different
ways. First, here's the program.
require 'win32ole'
word = WIN32OLE.new('Word.Application')
word.Visible = true
#doc = word.Documents.Open('C:/Documents and
Settings/Administrator/work/test.doc')
#doc = word.Documents.Open(File.expand_path(ARGV[0]))
doc = word.Documents.Open('C:\Documents and
Settings\Administrator\work\test.doc')
sleep 5 #seconds
word.Quit()
Now here's the output of the three runs that I did.
C:\Documents and Settings\Administrator\work>ruby opendoc.rb
opendoc.rb:5:in `method_missing': Open (WIN32OLERuntimeError)
OLE error code:800A1436 in Microsoft Word
(C:\//Documents%20and%20Settings/Admin...)
HRESULT error code:0x80020009
Exception occurred. from opendoc.rb:5
C:\Documents and Settings\Administrator\work>ruby opendoc.rb test.doc
opendoc.rb:6:in `method_missing': Open (WIN32OLERuntimeError)
OLE error code:800A1436 in Microsoft Word
(C:\//Documents%20and%20Settings/Admin...)
HRESULT error code:0x80020009
Exception occurred. from opendoc.rb:6
C:\Documents and Settings\Administrator\work>ruby opendoc.rb
C:\Documents and Settings\Administrator\work>
Notice that the two times that the path was given with forward slashes, once
hard-coded and once from calling File.expand_path() on a file name passed to
the program, the program failed. However, when the path was given with
backslashes, it succeeded.
I'm not sure what to do next, since File.expand_path() returns a path with
forward slashes on Windows. Nevertheless, I hope that this information
allows the next step toward a solution to be taken.
Regards,
Craig
···
On 8/23/07, Kyle Schmitt <kyleaschmitt@gmail.com> wrote:
Just a quick hint, since it's saved me a few times when the MSDN site
didn't have good info, use the ole_get_methods, or its analog
ole_methods.
The help method, ole_method_help(), usually doesn't do much other than
return the name of the method in my experience, but heck, try it 
maybe you'll have more luck.
--Kyle
Mr Masaki,
The solution you suggested works!
I replaces the line:
doc = word.Documents.Open(File.expand_path(file))
with the three lines you suggested.
Thank you,
Mick
Masaki Suketa wrote:
···
Hello,
In message "Re: Ruby & Word 2007 help" > on 07/08/24, "Craig Demyanovich" <cdemyanovich@gmail.com> writes:
I'm not sure what to do next, since File.expand_path() returns a path with
forward slashes on Windows. Nevertheless, I hope that this information
allows the next step toward a solution to be taken.
How about GetAbsolutePathName of Scripting.FileSystemObject?
fso = WIN32OLE.new("Scripting.FileSystemObject")
path = fso.GetAbsolutePathName("test.doc")
doc = word.Documents.Open(path)
Regards,
Masaki Suketa
--
Posted via http://www.ruby-forum.com/\.
