I have created a Customized Excel template for Office 2007 using VSTO. currently i am showing this template under my templates. is it possible to show under Installed templates?
like we have in office 2007 Billing Statement, Blood Presser Tracker, Time Card , etc. Is it possibe to show the template which is created by me; under Installed templates?
I recently installed Visual Studio 2008 Professional (Finally!) and I was going to use it for XNA programming. (I know XNA is C#) and my problem is that the templates for XNA aren't showing up in VS, how do I fix it?
View 5 RepliesTutorial 2 asks me to create a new project using ObjectARX Wizard. I have installed this & tried to create a new project. The problem is that the wizard doesn't appear as an option under Installed Templates ! Create a new project using the AutoCAD Managed VB Application Wizard
[Code]...
i was wondering if someone could give me the final explanation on what i might be doing wrong here.I spent a lot of time reading around the net and the forum about how to add Threading capabilities to a VB project.
Nos, i've got .NET 4 installed, and i've added the system.tsr and mscorlib.dll files as reference in, say, Excel 2007 (see screenshot).However, when i try to make a thread with anything as basic as "Dim Thread1 As System.Threading.Thread", i get a user-defined type not found error.Indeed, when i use the object browser to see what's in the System file, theres nothing remotely linked to any Threading, and in the mscorlib file, nothing under "Threading" either, just a few Thread related functions, but nothing defining a data type
I have both Excel 2003 and Excel 2007 installed on my system. When I call oExcel = CreateObject("Excel.Application"), Excel 2003 is used in the context in my .NET code instead of Excel 2007 (which I need to be used). I have referenced the "Microsoft Excel 12.0 Object Library" but when the code runs, the 11.0 version is used.
Is it because I am using Visual Studio .Net 2003 that Excel 2007 cannot be correctly referenced or do I need to change a reference or setting?
I used the code previously added by Mike Rosenblum but Excel is still not closing, Here is my code:
Imports Microsoft.Office.Interop
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Runtime.InteropServices
Private Sub Check_For_Xcel(ByVal filename As String)
Dim varpath As String = ""
Dim varvalue As String = ""
Dim xlapp As New Excel.Application
Dim xlbook1 As Excel.Workbook = xlapp.Workbooks.Add()
Try
varpath = filename
xlbook1 = GetObject(varpath)
xlbook1.Application.Visible = True
xlbook1.Windows(1).Visible = True
xlbook1.Application.WindowState = Excel.XlWindowState.xlMinimized
For irow = 2 To 65536
For icol = 1 To 4
Select Case icol
Case 1
read_date_time = xlbook1.Worksheets(1).Cells(irow, icol).Value
Case 2
read_plate = xlbook1.Worksheets(1).Cells(irow, icol).Value
Case 3
read_plate_state = xlbook1.Worksheets(1).Cells(irow, icol).Value
Case 4
read_location = xlbook1.Worksheets(1).Cells(irow, icol).Value
End Select
Next
If read_plate = Nothing Then Exit For
Check_IF_Present(read_plate, read_plate_state)
Next
If Not xlapp Is Nothing Then
GC.Collect()
GC.WaitForPendingFinalizers()
GC.Collect()
GC.WaitForPendingFinalizers()
Marshal.FinalReleaseComObject(xlbook1.Worksheets)
xlbook1.Close(SaveChanges:=False)
Marshal.FinalReleaseComObject(xlbook1)
xlapp.Quit()
Marshal.FinalReleaseComObject(xlapp)
End If
xlbook1 = Nothing
xlapp = Nothing
GC.Collect()
GC.WaitForPendingFinalizers()
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "Error at Check for Xcel")
End Try
End Sub
I've managed to work out how to read EXCEL cells via static values. Ideally I would like my application to check the third column of the EXCEL sheet and if there are no entries on a given row, it should display the coresponding row of colums 1 and 2...for example if (C,3) contains no entry then get values of (A,3) and (B,3)...then mark (C,3) as pending by writing a value to (C,3). Here is my code at the moment
[Code]...
I have an application that browses through Excel-files, changes color in some cells if they are in a wrong format etc.When my application is saving the changed file I get this alert about compatibility issues that can occur, and this alertbox has to be agreed or cancelled to move on to the next file. How can I disable this compatibility check programmatically? Or is there any way to ensure there are only Excel 2003 compatible colors in the document before saving?
View 13 RepliesI have an issue which has successfully busted my head all weekend. I created a COMAdd-in, in VB.NET (VS 2008) for Excel 2003. We now need to work the solution out for 2007 and since the layout and objects are a little different we had to make some critical Interface changes.Instead of a floating CommandBar we are now going with RibbonBar, which looks good but it doesn't work. Whenever I open Excel Workbook (which is the primary application). The Add-in successfully recognizes it and opens it up properly (bunch of Macro calls, layout settings etc). Anyway, after it opens, if I click on any button (on the new ribbon tab) I get "Application not properly initialize. Program will now close" and excel object is lost.
View 1 RepliesI have used Visual Studio 2008 (VB) to create a custom tab and button group with custom buttons. When any of those buttons are clicked, I simply want to run a macro (add-in) that will already be loaded when Excel is launched. The main examples I've seen create an Excel object in the VB code and then call the macro, but that seems like unnecessary overhead, since the custom buttons are are already loaded into Excel.
[Code]....
I added the reference and the "Imports" line, and I get the folowing error on the line
Code:
Dim oApp As New Excel.Application
Dim oWB As Excel.Workbook = oApp.Workbooks.Add()
Dim oWS As Excel.Worksheet = CType(oWB.Worksheets(1), Excel.Worksheet)
COMException was unhandled
Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
Basically in visual basic 6 I could access word tables in existing templates with the code owordactivedoc.tables(1).select() where owordactivedoc refers to the active word document and tables(1) refers to the first table in the template.Trying the same code in VB 2003 just leads to errors. Secondly how do I access bookmarks or alternatively word variables.Furthermore how do one deploy web.services. For example the current program I am building is for another computer. Simply copying the web service to Inetpubwwwroot dont work because it is not picked up by the Internet Information Services program. I have to create the web service in vb2003 on the other computer change msconfig manually. Copy and paste the existing service vb file in the created folder replacing the empty vb file.
View 3 RepliesI was wondering if anyone knows how I might be able to find out through VB.Net if the Save as PDF add in is installed for Office 2007?
View 4 RepliesIt appears that when one creates an instance of Excel, using CreateObject, (Late binding), the suggested Excel closing function (with GC.collect etc) does not work. I have tried several suggestions, and the only one that works is process.kill method. Do you see any problem in using this? BTW: the reason we are using late binding is that we cannot use Office PIAs....not sure which version of Office would be installed on the client site. We work with O2003, but the client might still be at 2000 or 2002.
View 7 RepliesI installed the API redist [URL] for Office 2010 (Office 2010 was already installed). Then I tried to use code from MSDN [URL] just to see how it worked. I included the code here, since it's short. At the top of the file:
Code:
Imports Outlook = Microsoft.Office.Interop.Outlook
... and in the class:
Code:
Private Sub SendSalesReport()
Dim mail As Outlook.MailItem = CType(Application.CreateItem( _
Outlook.OlItemType.olMailItem), Outlook.MailItem)
[code]....
Unfortunately, VS2010 balks at the very first line, not recognizing the namespace. What do I need to do?Oh, and I can't find Microsoft.Office.Interop.Outlook.dll anywhere, either. Shouldn't that have been installed?
I 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 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.
Does vb.net allow use of function templates like in C++, so that the function can be generic?
View 3 Repliesi am using vb.net 2008 express edition. I want to create a report using crystal report but there is no crystal report in my vb.net.
View 2 Repliestell me the difference between the different project templates, or examples of when to use each? Or is there a good place I can find explanations? The short descriptions in the statusbar don't really explain well enough for me to clearly understand.
View 2 RepliesIm working on a Winforms application that reads an XML file containing html templates and generates some html to send to another application.Each template will have about 25 values to replace.I thought about using the String.Replace method for this but wanted to get some ideas from the people here.
View 10 RepliesI have VS 2008 installed and cannot seem to get the form template to show when I try to add a new item to a project. I have tried the dev /installvstemplates from command line and I checked my zipfiles are in the 1033 folder, I think that is where they are meant to be but still no form showing in add new item?
View 9 RepliesI am working on a project that will entail connecting to a SQL server. I have been looking at different ways of doing this, and was attempting to connect via Linq to SQL, but found that when I click on the Project menu, and select Add New Item, I do not have anything regarding Linq in the templates.
View 6 RepliesI started trying to do this... [URL]...and quickly ran into a problem because I don't have a Windows Class Library project template. The option simply isn't there.[URL]So I start a Windows Application and try adding an Inherited User Control to the project, and I get this error.[URL] Building the current application does nothing for this. I tried browsing to system.windows.forms.dll and nothing happened.
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 am developing an application using excel automation.The worst thing is the client's side doesn't have excel installed.What is the solution for this case?
View 17 RepliesHow do I add Visual Basic templates to Visual Studio 2008
View 2 Replies