I am actually a beginner in OPC world. I want to design an OPC client using VB.Net, so in this regard i want some documents regarding automation wrapper. Also i have collected some codes from internet and stuck in some command like additems etc (Need some explaination regarding fuction of OPCAutomation Class), so i need some documents which can help me in this regards.
View 3 RepliesI am not an expert programmer and am just getting familiar with .NET office automation. I have two questions:
1. For me to create word documents from my code on a server, does word have to be installed on the server? My test server does not have word installed. Is there a way to have the code open word on the user's machine in this case?
2. I am trying out some code for creating word documents. It works fine on my machine. However, when I try to run it on server it gives me an error.. "Cannot create ActiveX component." Is this a permissions issue or related to the fact that the server does not have word installed?
A word document has several pages. How to split this pages into separate documents using VB.Net ?
I wish to automate this process.I used ms tutorial for basic learning: [URL]..But i do not know how to find page breaks in a document and move content of that page to separate document.
how do i use the webbrowser to display the word or excel docs. just like the pdf viewer... i tried the webrowser1.navigate but it didnot work, if it does its opening a new window, im using office 2010..
View 4 RepliesHow do I use the webbrowser to display the word or excel docs. just like the pdf viewer. I tried the webrowser1.navigate but it didnot work, if it does its opening a new window, I am using office 2010.
View 1 RepliesI have a website. In it, I have a button which will export some data from a SQL database to Excel. I want to open an excel workbook on the client and paste the data there. This all works fine locally, but when i publish it, I get this error:ActiveX component can't create object.[code]Have searched the net, and it seems the problem is permission related. Can anyone explain to me how to configure my server so that I can use clientside Excel?
View 2 RepliesI have a vb.net 2.0 winforms project that is full of all kinds of business reports (generated with Excel interop calls) that can be run "on-demand". Some of these reports filter through lots of data and take a long time to run - especially on our older machines around the office.I'd like to have a system where a report request can be made from the client machines, some listener sees it, locates a server with low-load, runs the report on that server, and emails the result to the user that requested it
View 2 RepliesI've been asked to get the page counts for documents stored as tif files. What I have now is looping through our third party software to open them and then get the page count. I can't stop the image from flashing and it is very slow. Does anyone know of a way to loop through them quickly and can the page counts (one image can have many documents)?
View 5 RepliesWe are creating a Who wants to be a millionaire style game in VB. Our server is pulling information such as questions and answers from a Access Database and sending them to the contestants (Clients). All transfer of information is directly from the server to each client. One of the "Life Lines" we want to use is "Ask a friend", where one client is able to Instant message another client for a short time to get help on the question.
[Code]...
i am developing one automate application for tht i hav done some coding i dont know how to proceed further can any one guide me if possible? [code] I am using SHDocVw for IE. Now i need to know how to do. [code]
View 4 RepliesI have written an automation addin in Excel with C# (addin.dll). To use the addin, I need to 1. register it using "regasm /codebase c:...addin.dll"2. select in ExcelOptionsAddInsExcel AddinsAutomation the respective addin from the list
I would like to automatize 1) and 2), so that the user just needs to run an exe-file in order to use the addin. 1) should be no problem, but how can one automatize 2)?
Ok basically what I need to do is the following:Read FirstExcelDoc (attached)For every row in that: Retrieve data from sql server db based on info in the Orange columns of FirstExcelDoc Let's say I retrieved data elements A, B, C, D, and E from sql server. Then I need to enter those same data elements A, B, and C in another excel spreadsheet (which has formulas etc) After inputing A, B, and C in that spreadsheet, read a couple of calculated fields and compare those results to data elements D and E retrieved originally from SQL Server DB. Finally, output the results in the Blue columns of the FirstExcelDoc spreadsheet for that row.Loop through and do the same thing for row 2 of the FirstExcelDoc and keep on until you see "END TEST" in the FirstExcelDoc.
I'm looking for a method of doing this efficiently. I have read several articles over the past few days as well as those from Mike R. but just need some direction to get started on this.To start of I'm looking for whether to read the entire FirstExcelDoc spreadsheet or just read the info for first policy number(2nd row) and process it and write out the blue column info for that row and then loop through and come back and read the second policy number (3rd row) etc... Please attach a code snippet for either way of reading the data.
I'm using excel via interop in application.Sometimes users kill application that created excel instance and that results in excel instance sitting in memory without any chance of disposing it.First I tried to tackle this using ROT(running object table) looks like not all instances of excel are registered there.Than I tried to somehow mark excel process after it is started via interop.[code]This works as long as excel is visible but in my case excel window is invisible.All I need is to somehow mark process that started via automation with the parent PID, so that later I can kill it if parent does not exist.
View 19 RepliesI have successfully automated a PowerPoint Metrics presentation with VB.Net. However, since there were many complicated calculations, it took quite some time to make the 120+ slide presentation - so I recently tried to revamp the application to be multi-threaded.
[Code]...
I've got VS2008 and Office2010, but I don't have Office2007. Therefore, I have the Word14 Object Library but not the Word12 Object Library. Will the code that I create for Office2010 automation also work where clients only have Office2007 or will they have to upgrade their office suites?
View 1 RepliesI have been pulling my hair out trying to fix this.
[Code]....
We have a vb program which is run on our server by scheduled task every day. The program opens about 30 excel files, refreshes the data connections, pivot tables and then saves the document in another location.
This may run fine for a couple days but sooner or later the process starts crashing, usually with this error: RPC_E_SERVERFAULT.
My question is, Is it expected that continually opening/closing/refreshing workbooks will inevitably cause the Excel object to crash at some point.
I know what is the actually DLL wrapper and how to create? I'm actually want to use a DLL which is written in Delphi and I try to do some search on the internet and I came across the term of wrapper.
View 1 RepliesI'm having an issue where my excel.exe process doesn't close until I close my .net application. I'd like to avoid using Process.Kill() if at all possible.
Code:
Private Sub WriteRowsToXls(ByVal rows As DataRowCollection, ByVal xlsPath As String, ByVal showStatus As Boolean, Optional ByVal AddTotals As Boolean = True)
Dim xlsApp As New Microsoft.Office.Interop.Excel.Application
[CODE]............
This method references a couple of other methods I use for repeated formatting tasks, I'll include those methods below. (I added the FinalReleaseComObject into the other methods after reading Mike's thread but the issue persists)
Code:
Private Sub SetRangeValidation(ByVal rng As Range)
With rng.Validation
.Delete()
[CODE]..............
Method SetRangeAllBorders does about the same as these other methods but my post is too long to add it. The only other things not shown in these code snippets are a few string variable that are defined in the class, studentWS, studentsWSPW, paymentsWS and paymentsWSPW My App creates an instance of the class, loads some data, runs the method above, and then sets the class to nothing. I'm using .NET 3.5 automating Excel 10
I wrote a simple Automation Addin using VB.NET and .NET 4 and want to distribute it's dll to a
computer with xp sp2 and Office 2007 (Excel 2007) without I install .net on that computer, is it
possible?
This might seem a ridiculous question but I just want to make 100% sure before I start committing any funds to software purchases. Can I use VB2008to develop automation routines to control Office2010 applications or must I absolutely use VB2010 to do so?I ask this because I installed an Office 2010 pro on my station which already has VB2008 and I do not have any Word14 reference in the COM section of the list of references...
View 1 RepliesI have created my webpage in asp.net in 1024*768 resolution, my problem was that when i change my monitor resolution then the controls in my webpage will be displayed in unmanaged manner .
How to arrange items in my webpage which support multiple resolution ...
Whatever the resolution of my monitor the controls in my webpage will display as it is as managed in 1024*768 reolution !
I need to call functions of "well documented" C++ dlls from a VB6.0 application. how to create VB6.0 callable C++ wrapper.
View 3 RepliesSo I have a some code I've been using for quite a while and it has worked fine. This project is rather large so I'm using a detailed namespace and I can't get it to work.[code]...
View 1 RepliesI'm trying to add a control on my form and each time an error pops up : "Failed to import the ActiveX control. Please ensure it is properly registered". I'm currently upgrading from VB6 to VB.NET (VB2010 running on Win 7).I installed vb6 on my win 7 PC and i can still add that control on any form - so definitely the OCX is properly registered. My guess here is that VB.NET is unable to create a COM wrapper for that OCX.
View 1 RepliesI seem to have reached a limit on the size of the form. I cannot make the form longer and I need to add more fields. Is there a limit on how many fields can be included in a form?
View 1 RepliesI'm using the Wolfram Alpha API wrapper for .NET at this location http:[url]......However it's written in VB.NET and written for version 1.0 of the API. It's unusable.
View 1 RepliesHow do I make my own word wrap function for strings? I want each line to be no longer than 50 characters and respect existing CRLFs.
View 2 RepliesI would like to create a .exe wrapper for a Flash Player using VB.NET. I am having a few problems.1.I seem to remember being able to import Flash Player as a control into Visual Studio (2008 Pro). For some reason, I can't seem to VS to import it anymore. (I tried using the OCX from Visual Studio) Perhaps I'm looking for the wrong file. What file am I looking for?
2.Is including Flash inside of a VB program legal?
3.When a control is included in a VB.NET program (such as Flash) does the control need to be distributed in a separate file, or will the compiled application contain it in the ".exe"?
I was able to import the control as the Flash10b.ocx from c:WindowsSystem32Macromed directory as a COM component. Question 2 and 3 still remain.Is there documentation on the ActiveX control? I am trying top figure out the API for ExternalInterface.
Flash in the IE 64bit web browser wrapper?
View 3 Replies