Printing using the Microsoft Office Document Image Writer printer and C#

ISV Open Discussions

Index ‹ Microsoft ISV

- Previous
  - 1
    - MS Office document and image writer print driver I am having a similar problem... I am missing the Microsoft Document Image Wrinter Port: But I have the driver. Anyone know how to re-install the port Thanks! Jeremy Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 2
    - What is the VBA code to insert an Object into an Excel File When utilising this code I received the Expected bject or Variable error against the CD1.ShowOpen code I have inserted the Microsoft Windows Common Dialog 6.0 Any ideas Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 3
    - Saving a pic I think you have pasted ALL the code into the userform code module. The first part goes in a standard code module. The code after the line in the userform module: goes in the userform code module. Sorry I should have made that more clear. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 4
    - Setting a header to all pages except the cover sheet Also, as an advice. You can rename a class of the Sheet named "Cover Sheet". Enter VBE -> click on the sheet (something like this: "Sheet2 (Cover sheet)") -> at the properties window select "(name)" property (at the top) -> replace existing text with a new one ("CoverSheet"). Then you code needs to be changed like this one: Code Block Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim WS As Worksheet For Each WS In Worksheets 'REV number and date in RHS footer on all except cover sheet If Not WS Is CoverSheet Then WS.PageSetup.RightFooter = CoverSheet.Range("B55").Value & _ CoverSheet.Range("L35").Value & _ CoverSheet.Range("B56").Value & _ CoverSheet.Range("L35").Value & _ CoverSheet.Range("A55").Value & _ CoverSheet.Range("L35").Value & _ CoverSheet.Range("A56").Value 'Document number in LHS header size 14 WS.PageSetup.LeftHeader = CoverSheet.Range("A10").Value 'Tab name in RHS Header BOLD fontsize 20 WS.PageSetup.RightHeader = "&B&25&A" 'Page number in Central footer BOLD size 14 WS.PageSetup.CenterFooter = "&B&14&P" End If Next WS End Sub But your code must be executable too. Try to copy sheet name from the sheet label at the bottom of the excel window and paste it into the Worksheets(" Cover sheet "). I had some mistakes because in russian letter "C" (spells like "S") and english letter "C" have the same way of writing. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 5
    - Possible to run code after Word closes? that is not a bad idea, but I want the original template document to remain empty, so saving the data in it is not acceptable. I guess I'll have to clear all the form elements in the document and then save it Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 6
    - Bucket ID 8 Saar, two more questions for clarification (sorry). First, you say that a bucket ID of 8 means that our crash reports were rejected by the servers. I assume this means that those crash reports will never show up on the Winqual site, no matter how long we wait for any processing to complete, right Second, you say that those crash reports may have been of an unexpected event type, which would lead to rejection. When you say "event type", are we talking about the event type parameter that is passed in the call to WerReportCreate() Code example: Code Snippet PCWSTR eventType = L"werapitest (eventType)"; HREPORT hReportHandle; if (SUCCEEDED(pWerReportCreate(eventType, WerReportCritical, &werReportInfo, &hReportHandle)) { ... } If that is the event type we're talking about, which value should I use as the event type to make sure my crash reports are accepted The mysterious APPCRASH_EVENT constant from werapi.h maybe If "event type" means something different, what exactly is it, and how can I fix it so that my crash reports come through Thanks, Claus Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 7
    - ISV application supported by vista Hi i want to know the list of LOB's, ISV applications or third party applications which runs on VISTA with out any compatible issues. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 8
    - runtime 2465 can't find field "|" referred to in your expression runtime 2465 can't find field "|" referred to in your expression. Here is the code. I know that the fields exists in the table and the object exists on the form. Private Sub Command32_Click() Dim db As Database, Tools As Recordset Set db = CurrentDb() Set Tools = db.OpenRecordset("tblCodedCuttingTool", dbOpenDynaset) Do Until [tblCodedCuttingTool]![ToolCode] = Forms![frmCodedCuttingTool]![ToolCode] Or Tools.EOF If [tblCodedCuttingTool]![ToolCode] = Forms![frmCodedCuttingTool]![ToolCode] Then MsgBox "Tool Already Exists", vbInformation, "Error" Tools.MoveNext End If Loop End Sub Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 9
    - asynchronous communications Group, I need to be able to have a top level gui in excel make calls asynchronously to another excel where I am doing my modeling. During this calls, I need to keep the gui alive and well for interaction. I can't find much info on this. I am an experienced multi-thread programer in C++ and Java, but I need to do this in VBA. Can you point me to some examples in Visual Basic for Applications in Excel where I can cut my teeth Thanks, The elephantwalker Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 10
    - vlookup hello all, MYPath is a variable which contains the name of the excel file i want to open for vlookup. it is in a different folder and not in the one where the original excel is (the one i am writing macro in). can you now help me with why this error. namrata Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 11
    - Mouseover event on shapes (Excel 2003) Can I set a mouseover event in VBA on a shape (copied picture) I have a module that copies an inserted image from one sheet to another sheet based on cell values denoting the placement of the copied image. The copy is then handled as a shape to set Name, Alt Text, and so on and the sheet is saved as a web page for browser viewing. Is there a way to set a mouseover event for a Shape object so that when someone points at the image on the web page, the image changes Code Snippet ' Go to the Display sheet and paste the copied image into the cell referenced Sheet1.Activate Sheet1.Range(pRange).Select ActiveSheet.Paste Application.CutCopyMode = False ' Set the AltText and Name to match the server network name Sheet1.Shapes(Sheet1.Shapes.Count).Name = sRange & "-" & namePicture Sheet1.Shapes(Sheet1.Shapes.Count).AlternativeText = namePicture ' Format picture by calling washPicture() from module3 washPicture ' Put the picture name in the cell one over to the left and hyperlink it ActiveCell.Offset(0, -1).Range("A1").Select ActiveCell.FormulaR1C1 = namePicture ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ namePicture, TextToDisplay:=namePicture Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 12
    - VBA ADO Error Handling Method I am using VBA in Excel to take the information in Excel, place it in an array, and insert it into a database. The operation completes successfully, however, I'd like to record any ADO errors that come up in the operation. The code is shown below. It first opens the database connection, then it creates a worksheet to add any errors that come up during the add new operation (errors if a record in another table does not exist or if duplicates exist in the array). The code then adds the data in the array into the table. If an error occurs, it should put the information into the 'Errors' worksheet, including the error description. During execution, the data is correctly inserted into the database, however, the 'Errors' tab ends up with twice as many records in it than it should. The information as far as which records show up there are also off. It seems as though it is not returning to the loop correctly, although I've never tried to build error handling in before. Any help is greatly appreciated. ' Open tblUser_Roles to add records rs2.Open "tblUser_Roles", conn, adOpenKeyset, adLockOptimistic, adCmdTable ' Row Counter Dim MaxRow MaxRow = 1 ' Worksheet Tab for Errors ActiveWorkbook.Sheets.Add After:=ActiveSheet ActiveSheet.Name = "Errors" Set q = ActiveWorkbook.Sheets("Errors") ' ADODB Error Handling On Error GoTo myErr: ' Add Data to Database from the Array For r = 1 To p_maxRole rs2.AddNew rs2("AUserID") = Data(r, 1) rs2("RoleID") = Data(r, 2) rs2("Priority") = Data(r, 3) rs2.Update Next r 'Error Handling Procedure myErr: If Err <> 0 Then q.Cells(MaxRow, 1).Value = Data(r, 1) q.Cells(MaxRow, 2).Value = Data(r, 2) q.Cells(MaxRow, 3).Value = Data(r, 3) q.Cells(MaxRow, 4).Value = r q.Cells(MaxRow, 5).Value = Err.Description MaxRow = MaxRow + 1 Resume Next End If Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 13
    - text parsing in excel I am collecting data that another person has done in excel to be used in a access database. The problem is that a lot of the cells have 5 spaces before the actual text. how do i write a macro to first check if there is a space at the beginning and then to delete the spaces. If there is a space, it is always 5 spaces. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 14
    - Combobox behaving oddly! I have a combobox embedded in an Excel worksheet, who's source is a named range. The named range is dynamic and can change in size if data changes. I have set my combobox to pick up this range by setting its ListFillRange property to the range name. This is done at design time, rather than in code. It has been working fine up until the range changed size. At this point, the values in the combo were all over the place, even containing blanks, duplicate values etc. I managed to cure this by setting the AutoLoad property of the combobox to True. However, what I find is still happening is the ListCount of the combo doesn't change if the range gets smaller. It displays the available values in the newly sized range, but the 'slack' is taken up by blanks. I hope I'm making sense. Can anyone help Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 15
    - Possible to run code after Word closes? that is not a bad idea, but I want the original template document to remain empty, so saving the data in it is not acceptable. I guess I'll have to clear all the form elements in the document and then save it Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 16
    - how to get the hyperlink value from an excel sheet cell Peter I don't program and can't understand the post. I have 5,000 cells in one column. 90% contain hyperlinks. I need to correct the hyperlink information using data from another cell in their individual row. How can this be done Just having the ability to display the hyperlink in an empty cell on the row and then sorting would be nice. Having the ability to globally change the hyperlink to the correct data would be heaven! Robert Tag: Printing using the Microsoft Office Document Image Writer printer and C#
- Next
  - 1
    - Complex report generation from datatable..challenging one plz help I have created datable which normally has 5000 records upto 1 lakh records depending on runtime value....i want to display rows of datatable to user in particular format... 1] odd rows with yellow back ground 2] even rows with green back ground 3] if value of cell in odd rows is not eqaul with value of cell in even row then both cells's text should be bold and with red color given pic is view that report should look like right now i am doing by putting that data in excel programatically using excel object but it is very slow....it takes hell lot of time ....15-20 minutes just for 300 rows only then i tried to write those data as html table format and generated .html file and i opened it with excel....got happy that it is done in some seconds but when opening with excel i found that it gets hanged if it has more than 10000 rows....so now i am totally stuck is it possible to get it done using xslt transformation and how will color font color in xslt at run time by matching data or any other way to represent table content with same formating but in any other file format please help.... Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 2
    - importing data from an ODBC datasource using a filter How can I use a filter on an import table into my Access database Do I use SQL statements in a module or VBA Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 3
    - VBA help with a conditional Subscript out of Range Hey everyone, Hopefully this one will be an easy one. I am asking VBA to pull information from an access 2003 database, and place it in an array. There are cases when I know that I will get a "Subscript out of Range" Error, and have to ask for a different set of values, due to having 0 values in the database for the parameters I asked for. IE no values in this table for that date range. So I will have to query a second table. Is there a way that I can make VBA catch that with an IF statement I tried If(ResultsTrend), and If(Not ResultsTrend). But neither of those worked. Basically I need it to analyze wether the array got populated with anything at all, and if not, go do this instead. Here is my code so far for this block. Code Snippet ResultsTrend = GetTrendData(Server, Username, Password, TrendStartDate, TrendEndDate, 0, 0, OverrideTemp(k).Range("F1").Value, Status) If (Not ResultsTrend) Then ResultsTrend2 = GetTrendData(Server, Username, Password, TrendStartDate, TrendEndDate, 0, 0, OverrideTemp(k).Range("F2").Value, Status) For i = 1 To size OverrideTemp(k).Cells(EventStartTime.Row, EventStartTime.Column).Value = ResultsTrend2(i) OverrideTemp(k).Cells(EventStartTime.Row, EventStartTime.Column).HorizontalAlignment = xlCenter OverrideTemp(k).Cells(EventDuration.Row, EventDuration.Column).Value = ResultsTrend2(i + 1) OverrideTemp(k).Cells(EventDuration.Row, EventDuration.Column).NumberFormat = "0.0" OverrideTemp(k).Cells(EventDuration.Row, EventDuration.Column).HorizontalAlignment = xlCenter Set EventStartTime = OverrideTemp(k).Cells(EventStartTime.Row + 1, EventStartTime.Column) Set EventDuration = OverrideTemp(k).Cells(EventDuration.Row + 1, EventDuration.Column) Next Else Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 4
    - 2 Small Macro problems. Try this: Sub CloseOtherFile() ' ' CloseOtherFile Macro ' Macro recorded 3/13/2007 by Gary Beckwith ActiveWindow.ActivateNext ActiveWindow.Close SaveChanges:=True End Sub Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 5
    - MSDN Download Hi, I found out at microsoft download site that the latest version of MSDN could be downloaded free of cost. Has any body tried downloading the image file and is the MSDN fully functional Or is it an evaluated version which will expire after some days Please find the link to the page below. http://www.microsoft.com/downloads/details.aspx familyid=94596AF5-CC58-45AF-A14B-DF627A31E783&displaylang=en Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 6
    - some mp3 play some others don't thanks, for moving my request, I really didn't know were to get help. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 7
    - Access Data Project - Selecting Data What are the best pratices on selecting single values from SQL Server tables (ADO) in VBA code in an Access Data Project The command.execute method returns a ADODB.Recordset so a SQL SELECT statement can be executed and moving to the first record of the recordset to get the value. But seems a little extreme to lookup one value. The DLoookup methods used for Access tables (DAO) are not available for ADO. In .NET there is a sqlcommand.executescalar which returns a single object. What is the recommended method to select a single value from a SQL table Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 8
    - Vlookup in VBA Hey eveyone, I'm have a lot of difficulty using a vlookup in a macro I'm creating. If anyone could help it would be greatly appreciated. Here is the code: '********************************************************************** Sub proScoreCard1() Dim rng As Range Dim tradeDate As Date Dim confirmDate As Date Dim t1mDate As Date Set rng = Range("H2") tradeDate = rng.Value confirmDate = rng.Offset(0, 4).Value Do Until IsEmpty(rng) t1mDate = Application.VLookup(tradeDate, _ Worksheets("Lookup").Range("A2:E62"), 3, False) If confirmDate <= t1mDate Then rng.Offset(0, 5) = "X" Else rng.Offset(0, 5) = "" End If Set rng = rng.Offset(1, 0) Loop End Sub "*************************************************************************** The error I am receiving is "Runtime error 13: Type Mismatch" Thanks in advance! Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 9
    - common dialog not returning file names. Hi everyone. i have a vb script that is imbeded in an html page (hta). when i use the common dialog flags = cdlOFNAllowMultiselect the file list is present in the filename object and are separated by a space. however when i use dialog flags = cdlOFNAllowMultiselect Or cdlOFNExplorer the files that i selected on the dialog box, are not present in the filename object. the only thing that's there, is the path to the files. here's the code: Const cdlOFNAllowMultiselect = 512 Const cdlOFNExplorer = 524288 Set ObjFSO = CreateObject("UserAccounts.CommonDialog") ObjFSO.Filter = "All Files|*.*" ObjFSO.FilterIndex = 1 ObjFSO.InitialDir = "c:\" ObjFSO.Flags = cdlOFNAllowMultiselect or cdlOFNExplorer InitFSO = ObjFSO.ShowOpen selected_files = ObjFso.FileName msgbox selected_files the variable "selected_files" should have the file names. but it only shows path. any ideas why this is and how can i get the files names thanks so much. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 10
    - Writing result in Excel Hello, I have the folowing code: Public Function DgrMinSec2DecDgr(Angle As Double) As Double ' * -------------------------------------------------------- ' * Program not yet working ' * -------------------------------------------------------- ' * Variables Dim grd As Integer Dim min As Integer Dim sec As Integer Dim calc As Double ' * Values grd = Angle \ 1 calc = (Angle - grd) * 100 min = calc \ 1 calc = (calc - min) * 100 sec = calc \ 1 DgrMinSec2DecDgr = grd + (min / 60) + (sec / 3600) DgrMinSec2DecDgr = Round(DgrMinSec2DecDgr, 4) ' should I round this result ' * Write - problem in writing in cell 'Debug.Print Round(DgrMinSec2DecDgr, 4) 'ActiveCell.Formula = "Write" & DgrMinSec2DecDgr ActiveCell.Select: Selection.FormulaR1C1 = calc '"Write Sel" '& DgrMinSec2DecDgr End Function I will be extremely gratefull for your answers. Thank you. V. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 11
    - Inserting Comments in Excel...from a Beginner I managed to get your error by selecting a range containing numerical values, which I assume is what you were doing. I guess by passing a numerical value into the String argument of the AddComment method, it wasn't liking it. I have amended the code to explicitly convert a cell's value to a string as it passes it to the AddComment method. I've also added code that deals with Cancel button being clicked on the input box, just to make it more complete. Give it a try. Code Snippet Sub AddComments() Dim dataRange As Range Dim cell As Range 'Prompt user to define range containing values in Sheet2 and set dataRange accordingly On Error Resume Next Set dataRange = Application.InputBox("Select range containing the values to convert into comments", Type:=8) On Error GoTo 0 If dataRange Is Nothing Then Exit Sub 'Loop through each cell in the specified range, ignoring blank cells For Each cell In dataRange.SpecialCells(xlCellTypeConstants).Cells 'Add a cell comment in the corresponding cell in Sheet1 Sheets(1).Range(cell.Address).AddComment (CStr(cell.Value)) Next Sheets(1).Select End Sub Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 12
    - About SAP MM and SD Hi, I'm a Mechanical Engineer from Chennai, India, with about 2 years experience in Project Engineering. I worked with the order management team of an MNC and handled inquiries on design, material and manufacturing, co-ordinated with vendors and clients, and have also done post shipment analysis. I just want to know if studying SAP - MM or SD will be a good career option for a mechanical engineer. I also want to know if I'll get a job immediately after studying SAP and what are the technical skills that IT companies expect when they recruit people. It would be nice if someone with a similar background explains his/her experience about the selection process, the interview and career growth pattern that one can expect in this field. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 13
    - Excel-Capture the sum of Highlighted Range I'm trying to capture the sum of a highlighted range in an Excel Marco without using a loop. After selecting a range, I can capture the cell count with the following command: X = Range(Selection, Selection.End(xlDown)).Count Wondering if there is way to the sum as well. Excel can show the sum highlighted range, so it seems I should be able to replecate in VB. Thanks, Neil Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 14
    - LCS 2005 Not Showing Options in Administrative MMC I recently installed Live Communications Server 2005 Standard on a Windows 2003 Server which is a member of our domain. Everything seems to be working correctly with Messenger 5.1 however when I try to Use the Administrative snap-in it only shows the text Live Communication Server 2005. It does not give me a tree structure with options and nothing appears under the actions menu options. I logged in as the domain administrator to see if maybe it was a permissions problem but still no luck. Any suggestions Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 15
    - adding text to cell with vba script Wow, no wonder everyone uses &. + adds the numbers. Anyway, I don't use variant, so I have to cstr() all the time, otherwise a runtime error ocurres. Tag: Printing using the Microsoft Office Document Image Writer printer and C#
  - 16
    - How to test Com Addin for ISV test Per the VeriTest expert (I asked if there were any pre-tests that you can do on your own before submitting to VeriTest) : Not for the Platform Test. If they would like to do pre-testing, I would encourage them to do it on their own before sending us their product. I have attached a document that goes over the test methodologies for you to forward. As I can't post any attachments to the forum, please email me at budsup@microsoft.com and I'll email you the attachment. -brenda (ISV Buddy Team) Tag: Printing using the Microsoft Office Document Image Writer printer and C#

humble.apprentice

Hi all,

I am trying to print, without user interaction, a PDF file to the Microsoft Office Document Image Writer. If use System.Drawing,Printing.PrintDocument, I'm able to set the destination file but when it gets to printing the file, I can't since it has to know how to render the PDF file. Now, I tried using the print command in the command prompt but when I want to specify the Microsoft Office Document Image Writer it says it can't initiliaze the printer. Can anybody give me a hand on this one I want to do it either way.

For those who don't know the print command do the following:

Go to Start
Click on Run
Type cmd if you are using XP
Type print in the command line

Thanks in advance,

Top