I have office 2007 installed on my development PC but would like to include Office 2003 Object library in the project as a COM reference. Can I download the required files from anywhere for this or do I have to install Office 2003? |+--JDMils|+--VB6 & XL VBA+--VB Dot Net 2K8|
View 14 Replies
I am having trouble developing an asp.net page. I can create custom collections and use them in win apps, but when i reference the system.collections namespace, the page response hangs up. No exception info is passed back or anything. The page just freezes. Is this a common problem. I am wondering if its due to the assembly not being present (but am unsure why an exception wouldn't indicate this.).
View 1 RepliesI have a software package with a bunch of libraries and header files that I am trying to use in a VB.net application. The software help file states the following: The MIL DVD includes MIL libraries that support the Microsoft Visual C++ .NET 2003/2005/2008 (unmanaged) compiler under Windows Vista/XP. The DVD also includes ActiveMIL ActiveX controls for Microsoft Visual Basic .NET 2003/2005/2008, Microsoft Visual C# .NET 2003/2005/2008, and Microsoft Visual C++ .NET 2003/2005/2008 RAD tools.
To compile a MIL application program, you must include the mil.h header file, in addition to the required standard C include files. After you have compiled your application program, you will have to link it with the appropriate libraries or import libraries for your operating system, compiler, and target board.
[Code]...
I'm trying to implement the XACT engine in a VB.NET project. I'm pretty new to this stuff, but I can set up and use the normal DirectX libraries fine. However, I can't for the life of me work out how to set up/reference/import/include/whatever the XAudio2 and XACT libraries. All the dlls in the Aug2009 DX SDK say they can't be used as references in the project, and the only tutorials I can find are in C++ and use the .h headers, which, if I'm not mistaken, I can't use at all for VB.
I'm tearing my hair out over this because there literally seems to be no way that I can find to use the new sound stuff in VB! I'm imagining MS wouldn't actually allow that to be the case, so if someone can tell me what basic thing I'm doing wrong.
So I have this error.
[Code]...
So I'm guessing it has something to do with the fact that I don't have office loaded on my computer. Now I have another laptop, with office that I loaded this project on, and it works fine. So do I have to load office on this computer, or can I just reference something?
[Code]...
I have moved this post to the office development location.
View 1 RepliesI have a problem when creating installer for my project. My project is utilizing Powerpacks 10 and will be deployed on XP machines. These machines do not have internet connection.When I create the installer, can I include the Powerpacks 10 to be installed offline? Currently I have no idea to make the installer to include the powerpacks and install it offline - it always downloads the required files from internet.I looked it up on Microsoft websites and they only offer Powerpacks 3.
View 3 RepliesI'm working on a VB2008 project that references two Access databases using Provider=Microsoft.Jet.OLEDB.4.0; It would seem if the user does not have MSOffice on their machine, the program crashes with a "XXX stopped working" on startup on Vista and Win7.I thought that Windows had XP and above had Jet functionality built in?
View 1 RepliesI have a function in my application which exports data to excel. It works fine when it is installed in a pc where office is installed. How can I run in a pc where Office is not installed? Do I need to install full Office in user computer? Are there any redistributables which makes my work done??
[Code]...
I 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 RepliesI am building a windows form application using visual basic (visual studio 2008). The idea is to query a MySQL DB and export the results to an excel document. I managed to do this using this code (I will just show the export to excel part):
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.IO
Imports System.Data
Imports MySql.Data.MySqlClient
Imports System.Configuration
Imports System.Runtime.InteropServices
[Code] .....
And it works fine on my laptop (which has office 2003 installed), but when I create the setup package and install it on the server where I am going to use it (which does not have office installed), I get this error:
"Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154."
And for the record, I need the excel file, not a CSV.
I am working on a legacy VB.NET application that uses Microsoft.Office.Interop.Word, with Office 2003 installed on the server. When I publish my site, even though my config file clearly shows v11: The site will crash saying v12 couldn't be found: Could not load file or assembly 'Microsoft.Office.Interop.Word, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Note: I currently have Office 2003 & 2007 installed on my dev machine, also, when looking @ references I am given the option of selecting v11 or v12 (so v11 is def. there). Within a page on the site the page does an import statement for Microsoft.Office.Interop.Word. Is it possible to specify the version at this point, or any way to force it to use v11 without me uninstalling my v12?
I am building a windows form application using visual basic (visual studio 2008).The idea is to query a MySQL DB and export the results to an excel document.I managed to do this using this code (I will just show the export to excel part):
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.IO
Imports System.Data
[code].....
I 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'm looking to add reference object libraries relating to excel and none are available to select from my directory. I have Microsoft Office Excel 2010 Express installed. Where can I retrieve this object library (and others?). Looking to import and export data to/from excel.
View 7 RepliesI have a WinForm program developed in VB.Net with Visual Studio 2005. The program needs Microsoft Office Runtime installed atleast on the computer to allow the application to run without any errors.
Is their a way to check the computer to see if the minimum of the Runtime or Microsoft Office is installed on the computer? If either isn't I would like to display a message to the user on the startup of the application that states to atleast go to Microsot's site (I have full link to Runtime Download) and download the runtime for free.
Or is their a way to include the runtime as a component with my install for the application so if it isn't installed on the computer already it will install when the application is installed?
I have a software that writes data to Excel sheet. I'm using Microsoft Excel 11.0 Object Library for this. Everything is working fine so far, but apparently the drivers require Microsoft Office installed onto the computer.
Is there a way to write data to Excel format without having Microsoft Office installed?
Question: How do I programmatically determine which provider to use (Microsoft.Jet.OLEDB.4.0 vs Microsoft.ACE.OLEDB.12.0) when my app runs as a 32-bit process on a machine with Office x64 installed?
I'm developing a VB.net WinForms app in VS 2010 and targeting both x86 and x64.The app processes data from xls, xlsx, mdb and accdb files using System.Data.OleDb:Dim oConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=...")
The x64 version of the program works as expected. The x86 version works as expected on a system with Office x86.When I run the x86 version on a machine with Office 2010 x64, I get the following exception when trying to open a connection:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.I believe this is because I'm running Office 2010 x64 so the x86 data access components are not installed.I can get it to work for Office 2003 files (*.mdb and *.xls) by changing the provider to Microsoft.Jet.OLEDB.4.0.
How do I figure out which provider to use when running as a 32-bit process on a machine with Office x64 installed?Ideally, I'd like a function:If ProviderIsAvailableFor("Microsoft.ACE.OLEDB.12.0") Then
Else If ProviderIsAvailableFor("Microsoft.JET.OLEDB.4.0") Then
Basically I've coded an Excel 2007 project in VB.NET 2010 that allows you to create charts with a fair amount of interactivity. I want the user to be able to save and reopen this workbook and still have that interactivity in any already-created charts, so they don't have to re-create them.
When I create the charts, I use Sheet1.Controls.AddChart(...), which returns a Microsoft.Office.Tools.Excel.Chart with which I can handle events and such. However, when I reopen the file and look through the Sheet1.Controls collection, there are no Chart objects. Accessing the charts through Sheet1.ChartObjects.Chart gives me Interop Charts, when I need the Tools Charts.
I am looking for away to include a power point slide show inside a form in vb.net 2005. Office 2007 will be installe on all of the client machines which run the program. I have found ways to launch and control a power point slide show in an exteral window, but no way to attcah it and place it on the form window.
View 1 RepliesI have used VB6 to create controls for robotic devices via serial/usb ports... and I already figured out the serial port.I create a graphic gauge for showing data by making a shockwave flash file for example: analog1.swf I then load and use the movie by setting the frame number. In short, 100 frames, 60% would be frame 60, etc. It looks like an analog gauge, makes the program look great.In VB6 I had the file specified as app.path & "/analog1.swf" then when I built the file I would click on the swf file when asked if there was anything else I needed to include... and it would be included in the build. I figured out most of the issues; how to include a shockwave flash object and I found a replacement for app.path... after experimenting. I found that Application.StartupPath() pointed to the DEBUG folder.so if I place the analog1. swf file in the DEBUG folder, I could do something like...[code[ when I tried to build the file in VB.NET, the SWF file wasn't in the publish/SWF1 folder I made. (I selected install from CD so everything should go into one folder as I understand it.) This means that if I distributed the install files... the person would not see the graphic, just a white box where it should be.
I read some more here on the forum... and I found out that I could do the following to add a resource...Click - Project on the toolbar.Click - Add Existing File from the drop down menu.Pick (analog1.swf) from someplace on my hard drive.Okay that got it into the program resources and I presume VB.NET will make a copy in some folder someplace... but I'm not seeing it right now. (Possibly because of the next issue...)How do I specify it in the code? if I create a shockwave object and call it "flash" what goes here.And is there anything special I need to do so that when I click BUILD and/or PUBLISH so it actually includes the SWF file in the finished product so the person installing it sees a gauge instead of a white box?
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?
following error message:
Method not found: Void Excel.Range.set_Value(System.Object,System.Object)
I am messing around with some Excel Automation just to get my feet wet and want to call some specific cells in my spreadsheet just for testing. I have one form in the project including a button. My question is how do I tell the button where to navigate to the cell to be tested?
My code for my Excel class is as follows:
Public Class Waybill
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oExcel As Object = CreateObject("Excel.Application")
Dim oBook As Object = oExcel.Workbooks.Open("C:\TesterXL.xls")
[Code] .....
My program I wrote is using Outlook 12.0 lib for Outlook 2007. I have referenced this in the project. This exe will only be installed on computers that has Outlook 2007 on it. So with this being the case, do I need to bother including any of the lib files? Or just my exe?I have this in my form:
Imports Microsoft.Office.Interop
Imports System.Reflection
Imports System.IO
Imports System.Text
[code]....
So I assume the Interop is all part of the object lib? I know this sounds crazy but I tried coding it using late-binding with many examples but just had too many problems. So I'm going to make three different exe's for versions 2003, 2007 and 2010.
I am using VS .net 2003 and developing a program that calls Excel. The development computer only has Excel 2003, and the target machine only has Excel 2007. Would it be possible to install Excel 12 Object Library in the development computer without installing Excel 2007?
View 4 RepliesI want to create some custom shapes for MS Office which we can use in house.
For example I want to create a shape named "carton box" which have three - four default places where user can add some text. It is same as other shapes or I would say just like shapes (line, flowchart, arrow etc) in MS office 2007.
Is there any way to create and reuse such a new objects, also if user don't have these shape in their toolbox and get a document which includes these shapes; he should be able to see it (defiantly in read only).
Background - I am a .NET developer and also having small knowedge of MS office development in .NET.
I have a simple COM add-in for office that I am developing (for access specifically). I have added a custom commandbarbutton item to the context menu that pops up when you right click on an object in the navigation pane. This works fine. The debug code I added runs (currently just a msgbox command). The one thing I cannot figure out how to do though is get an object for the object bound to the context menu.
I would like this to happen; I right click on a module in the navigation pane, select my new menu option, and then a message box appears with the name of the module that is currently highlighted. How would I go about this? This is how I am currently handling the event:
[Code]...
I am new to this forum - and while I have programmed in VB.Net for some time, I am also new to Office Automation - so please bear with me We are creating a Metrics presentation in Powerpoint 2003.Currently, the presentation is manually created. We are automating this through VB.Net. I figured out how to add the slides from the template. I can modify text boxes and other objects other than the MS Chart objects. I can modify MS Chart objects - but find that after updating the chart, saving it, and closing the application - it apparently doesn't save correctly. When I reopen the presentation, it originally shows up with the changed data. Once I double-click it, however, it doesn't keep the modified data.
I looked at the properties of the graph in VB.Net - and it looks like the chart shape is read-only. I thought of two solutions - one: copy the chart, modify a local copy, and paste it over the original, or two: make the read-only chart writable. Problem is - I'm at a loss for how to complete both of these.As far as the copying of the chart, I found some information about using the .Copy() command, so I cam up with the code
[Code]...
I set a range with a function like this:
Code:
Public Function GetRange(ByVal strCellRange As String) As Microsoft.Office.Interop.Excel.Range
Try
[Code]....
