Solved

Automating Word - Error on Users Machine, Can't Duplicate On Mine

Posted on 2012-03-09
5
253 Views
Last Modified: 2012-08-14
I am developing an application that creates (from scratch) a Word document.  I'm developing using VB.Net 2010 (Pro).  I have on my machine MS Office 2010, the user has Office 2003, so I'm using late binding.

Here is the block of code that's failing
    Dim shp As Object = oTable.Cell(1, 1).Range.InlineShapes.AddPicture(sBMPFile)
    With shp
        writeLog("Adjust Image Size", "clsReport", "writePage05")
        .LockAspectRatio = 1
        Dim fOldWidth As Single = .Width
        writeLog("Adjust Image Width", "clsReport", "writePage05")
        .Width = m_oWord.InchesToPoints(4)
        If .Height > m_oWord.InchesToPoints(4.5) Then
            writeLog("Adjust Image Height", "clsReport", "writePage05")
            .Height = m_oWord.InchesToPoints(4.5)
        End If
    End With

Open in new window


Specifically, I have localized the error to occur at the "LockAspectRatio" line, or the line after.

The error that's thrown is this:
See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentException: The specified value is out of range.
   at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateSet(Object o, Type& objType, String name, Object[] args, String[] paramnames, Boolean OptimisticSet, CallType UseCallType)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateSet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean OptimisticSet, Boolean RValueBase, CallType CallType)
   at STR_Tower_Mapping_Report_Maker.clsReport.writePage_05()

Yada, yada, yada

Open in new window


I'm fairly certain the issue is the fact that the "LockAspectRatio" value should be "msoTrue", but since I'm late binding I'm merely guessing at the actual numeric value.

Any ideas?
0
Comment
Question by:Clif
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 6

Expert Comment

by:Patrick Tallarico
ID: 37703521
My suspicion is that it may be calling this from a vba library that your users may not have loaded.  Open the VBA console, and go to 'Tools' -> 'References' and check to make sure that the libraries you have on your machine are checked for your users.
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 37703548
0
 
LVL 40
ID: 37703659
If the error is on line 5, remove it, you do not use that variable anywhere in your code.

You might want to provide the use with Word 2003 with a Debug version of the application. You would get more information out of the error report.

However, as it is, it gives a clue. Look at the last line, this is typically the line that triggered the error:

at STR_Tower_Mapping_Report_Maker.clsReport.writePage_05()

What is that STR_Tower_Mapping_Report_Maker?
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37703731
The constant msoCTrue has a value of 1. msoTrue is -1, so that is the value to use

msoCTrue produces the error on my 2003 version.
0
 
LVL 10

Author Closing Comment

by:Clif
ID: 37729726
Sorry it took so long to get back, but the user was out of the office for a few days, so they couldn't test it.

The change from 1 to -1 did the trick.

Thanks.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question