Work With Different Versions Of Excel From VB?
Jun 10, 2009
I have a dataset that I export to xml (using ds.WriteXml) and then use an instance of Microsoft.Office.Interop.Excel.Application to open and manipulate the xml data, then save it as an .XLS file.I have office 2007 (why don't they have help/about in an easy to find place... man I hate those stupid office ribbons and the person who developed them...)Anyway, this code works fine for me. But when I put this on a machine that has office 2003 installed, it crashes.So, what do I need to install, reference, buy, etc. so that I can do the same thing on machines that have 2003 (or before) installed? No, I can't install office 2003 (my first thought).
View 8 Replies
ADVERTISEMENT
Mar 25, 2012
I've read about revising the File Version (and Assembly Version) to ensure that an updated file does replace an older/previous file when a WI update installation is carried out, but I don't understand the four-part construction of the File Version ... and my re-versioned files sometimes refuse to transfer to the target computer.
For example, a .exe I have recently updated had it's File Version set to 1.0.0.0 (it is resident now in my Program Files (x86)/MyApplication folder) and File Date 23/03/2012, but even now with the File Version set to 2.0.0.10 and a File Date of 24/03/2012 when I use WI to install the new program over the original the 1.0.0.0 file remains in place and the new 2.0.0.10 file does not get installed instead.
[Code]...
View 2 Replies
May 10, 2012
Is there possible to built application which is automating something with some cain of interejs that provide to switch any version of excel? I just want to built universal code for any cain of excel 2000/2003/2007/2012 and just could switch in code if u know what I mean..
View 5 Replies
Mar 2, 2009
The application was developed with Excel 2000 but doesn't work with 2003 or 2007. The save isn't working. Everything I have googled shows this to be a common problem. I just haven't found a solution that works. [code] We the willing, led by the unknowing, are trying to do the impossible for the ungrateful.We have done so much for so long with so little we are now qualified to do anything with nothing.
View 10 Replies
May 13, 2011
I have a small application where I am importing different versions (2008, 2010) of Excel sheets and saving them in SQL server. My program will find the 2008 versions but for some reason it will not find the Excel 2010 versions. I am not sure if my code for the Connection String is correct. Perhaps someone could have a look at my Connection String code?
Imports System.Data
Imports System.Data.OleDb
Public Class DBHelperClass
[code].....
View 2 Replies
Aug 19, 2010
To the board: Lately I've been getting Runtime error 3447 ("The Jet VBA file (VBAJET.dll for 16-bit versions, or VBAJET32 for 32-bit versions) failed to initialize when called. Try reinstalling the application that returned the error") when attempting to open a certain program (not one that I designed, just downloaded and installed). I installed this program in January 2009, but this error began happening only this past July. someone else to information about the files vbajet32.dll and expsrv.dll. One site said that the problem was probably caused by the file expsrv.dll being absent, but I checked my System32 folder, and it's there. As far as I can tell, it has always been there (the computer was made in 2008, and as I said the program had always worked before). Vbajet32.dll is also there. I tried uninstalling and reinstalling the program, but error 3447 still occurs. I also tried uninstalling the program and installing an older version, but 3447 is still there.
I tried replacing expsrv.dll, thinking it might have been corrupt, but that didn't help, and I cannot register that dll anyway. I can't figure this thing out. Both of the files are there, and I didn't change any settings or anything anywhere between last January and this July. By the way, I am on Vista.
View 1 Replies
Jan 20, 2009
I'm using comboboxes in my user form in Excel. I have two boxes, FromCombo and ToCombo, the first of which I have assigned values to using [Code] Now, my problem is getting the second combobox to work. I want it to drop down a range of values depending on what the user picks for the FromCombo. I have named the ranges List1, List2. Say the user chooses "KA 1&7" from the FromCombo, how do I populate the ToCombo with List 1? I thought it would be easy to use if statements and compare the value in the FromCombo so I use this Code: If FromCombo.Value = "KA 1&7" Then but its not comparing. So how do I compare the value in the FromCombo box?
View 4 Replies
Sep 1, 2010
I am using vb.net 2005 and my laptop has a reference to excel 8.0. I have created a progam that uses excel 8.0's reference. While excel works fine on my laptop, it does not work on my pc because I have excel 2007 installed. My question is, is there a way to obtain the reference to excel 2007 for my laptop in order to use it in the .net project. I do not want to upgrade my laptop right now and my pc does not have vb.net installed on it.
View 4 Replies
Feb 25, 2009
I am trying to get an Excel reference working and it will not go. I had the working on an xp computer but I got a new laptop with Vista Premium (64 bit), and it is not working here; and I got it from the references and com. In the intelliSense I get only up to "Imports Excel = Microsoft"
View 2 Replies
Oct 1, 2009
I have worked with Visual Basic in the past, but never using it with Excel
View 3 Replies
Sep 28, 2010
I am getting a null value error on the " oSheet.Range("A1").value = "1"" Line:[code]
View 1 Replies
Jan 23, 2010
In cell A1 of Sheet2 I have the following text [code]how to I get VB to recognize that the 4<sup>th</sup> character of the string has character code 63?
View 3 Replies
Jan 22, 2009
I have created a C# .Net DLL add-in for Excel.When I try it on my home machine with WinXP and OfficeXP 2003 it works as expected. When I try it on a couple of machines at work with WinXP and OfficeXP2002 it does not work.I have spent 2 days solid reading up on this subject in general and I still cannot get to the bottom of the problem. As far as I can work out what I am trying to do should work with Excel 2002.
Some details:
- I am using Visual Studio EXPRESS 2008 (C#).
- The assembly is signed with a Strong Name Key File.
- I have installed the OfficeXP (2002) PIAs.
- I have created a class DLL in accordance with many MSDN and other internet posts.
- I have registered the DLL using RegAsm.exe and GACUtil.exe.
- I have added registry entries for Excel for CURRENT_USER so Excel should know about the DLL.
The DLL adds some Automation functions (Tools-Addins-Automation) which can be accessed in cells within Excel (for example you would enter =MultiplyFirstBySecond(2, 3) in a cell and get a result of 6) and also implements the IDTExtensibility2 methods so that when Excel is opened it creates a button on the toolbar which when pressed pops up a message box. It it this functionality (adding buttons with code behind them) that I want to expand on.I have attached the zips of the batch and registry files I have created to register the DLL in the GAC and in the registry. I have also attached a zip of the complete project. I would like to know if there is anything I should check with my machine's setup or my project or my registration/installation of DLLs, PIAs etc in order to make my DLL work on my Excel 2002 machine.
View 9 Replies
May 4, 2012
I will know how do I work with the opened excel instance, when I use multiple userforms. I have on my form1_load open a excel file. Then I observed that on my next userform, was unable to write to that file again. Project have no instance of APP.workbook.
View 8 Replies
Jul 29, 2011
When I try to record a macro that envolves a graphic at Excel 2007 nothing appears at the code...
Does anyone knows how to fix it?
View 1 Replies
Aug 17, 2009
I have an application that I originally wrote in MS Basic. It has since migrated to VB6 and then to VB Net. It works, but recently I have been unable to rebuild the project and an attempt to convert from VB6 has produced an error on converting and MSMaskEdBox as an array.
The most recent problem arises from the line of
Friend ExcelGlobal_definst As New Excel.Global
This enables me to pass data to an Excel spreadsheet from my project. If I leave a blank after New, VB Net presents me with a drop-down list, which includes I have recently tried to convert the project on my laptop and the above line of code produces an error. When I try to add a property(?) after New, Excel is not in the list of those available.
View 1 Replies
Dec 12, 2009
I have been looking for a good Example of Code to Compare 2 worksheets in the Same work book I have not had much luck. The Goal when complete is to compare Sheet 1 to Sheet 2 Then the Difference Recorded on Sheet 3 as a complete row with a date Stamp in A . If it is just a change then it is color coated Orange. If total new entry that was not on the sheet then it would be green If a Row is deleted in would be Pink.
View 7 Replies
Oct 21, 2008
This code no longer works in ver 2007:' Obtain max resources available for Excel
[Code]...
View 3 Replies
Nov 13, 2009
I unfortunately downloaded and installed Visual Studio 2010 and upgraded all my programs to .Net 4. I am really unhappy with the way 2010 runs. My computer keeps locking up for hours, programs take a long time to compile... Those are a couple of major issues.
View 3 Replies
Mar 2, 2009
I thought would be a simple google search but apparently I am not searching correctly - or something...
Does anyone know if I can do this? I would like to start working with 3.5 however all the projects I am doing are still in 2.0
View 8 Replies
Dec 22, 2010
I am developing a plugin into a third party control. They ship a SDK dll with their application to allow you to do this. However I am writing the plugin using version 1.1.0.0 of their SDK, but when trying to run the application on a clients machine that has a new version of the software the SDK version is 1.4.0.0 and my app throws the following error:
System.IO.FileLoadException: Could not load file or assembly 'MyDll.dll, Version=1.1.0.0, Culture=neutral, PublicKeyToken=764d581291d764f7' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
When the dll is referenced into Visual Studio I have changed the Specific Version property to false, however this has not made any difference. The dll is not reference from GAC.Is there a way that I can tell my application to just use the version of dll that is on the users machine? I have checked with the 3rd party vendor and the functionality that I am using has not changed in any of the versions as they use a back-ward compatibility approach to their software.
View 1 Replies
Jun 22, 2009
I have an application that uses a Microsoft DLL (Microsoft.ComponentStudio.ComponentPlatformImplementation.dll) which is used for OS deployment and accessing the catalog files. Version 6.0.0.0 is specific to the Windows Server 2008 catalog files. The newer version 6.1.0.0 is specific to Windows Server 2008 R2 catalog files. Attempting to access a catalog file with the incorrect version results in an exception.
My application (VB.NET using VS2005) needs to be able to access either version of these catalogs - I'd be happy with two executables (one for each catalog version) but obviously I don't want to maintain two sets of source code for each. Specifying both sets of DLLs in the project reference is not possible as the DLL names are identical. I'd rather not have to manually add and remove the DLL references each time I want to a build. As far as I know the interfaces etc are effectively identical between the two.
View 2 Replies
Sep 7, 2011
Any best practices on how to deal with different versions of base classes.We have made significant changes to the base class but still have lots of code inheriting from the old base class. Could you recommend how we introduce new base class.We'd like all new code to use the new base class. But, we would like the option to have old code still inherit from old base class so we have time to switch and test old classes with new base class.
View 11 Replies
Nov 17, 2010
know where I can get a list of the differences between VB.Net versions? For example, in which version were generics first introduced, and when did the "Using" keyword come into being?
I've tried googling it and all I seem to get are the differences between VB6 and VB.Net, which isn't what I'm after.
View 2 Replies
Feb 1, 2012
I work for an FDA regulated company, and they are obviously very particular about keeping track of any software changes. If I build a Windows application and then later wish to make a change to that application, does Visual Studio provide a way to save the source code for the old version of the app and the new version in separate locations?
[Code]...
View 1 Replies
Sep 1, 2009
I'm reasonably familiar with the various forms of VB that existed prior to .NET (VB6, VBA, VBScript...), but have yet to delve into The Sweet New Flavor that is VB.NET.
View 6 Replies
Feb 5, 2011
I have a program that works in Windows XP Pro, Visual Basic 2005 and Excel 2007 that does not work in Windows Vista, Visual Basic 2005 and Excel 2007.The program takes Excel data from an already opened Workbook on the desktop and moves it to the Visual Basic program.The error occurs when I try to open the Excel Application in Visual Basic:[code]Is there a different code to define an Application in Vista?The "Open" Application will not work on a Excel App already on the desktop.
View 1 Replies
Jan 4, 2010
I have a .net Application that writes text to a serial COM port, a POS reciept printer to be more exact. i am using the Rs232 class library to write and read to a serial device.My problem is now with some clients that have updated their operatingsystem to WIN7 64bit version, have trouble to create a connection to the COM-port. the com-port seemes to get occupied with some other process and that blocks my application to opening a new connection. so for my question, does anyone know how i can close all connections to a com port? or see whats blocking it? once again this seems to only to affect win7 and 64bit users.
View 1 Replies
Aug 13, 2009
I have a pretty complicated project with lots of class files, code modules, etc. There was a changed to one of my referenced DLLs that requires an isolated change in a single Sub within my solution. Unfortunately, this new Sub is not compatible with most of my clients' configuration but is required by some of my other clients. So now I must keep two versions in Source Safe of my solution - which I do not want to do. What I would like to do is to be able to determine which DLL is running and flip a switch to use the either the old Sub or the new Sub. Currently the sub is in a class, but I could break it out. Is it possible to determine which assembly version DLL is running? Also, if I reference the new DLL, the old Sub will not build. If I reference the old DLL, the new Sub will not build. So is there a way to keep both Subs in the same project?
Can I use reflection to know what is the assembly version of a loaded DLL?
View 3 Replies
May 28, 2009
ASP.NET pros out there can answer this question. I have a single web application that contains a website and a web service - both have several assembly references in common (data access layer, utilities, etc) - however, recent changes made to the web service will require different versions of the common assemblies, versions that the website won't work with (in case you're wondering, the website is some legacy 1.x .NET code that explodes when using the newer version assemblies.)
allow my web service to reference one version and have my website reference another? I can obviously have only one version with the same name within the bin folder.(P.S. - It just dawned on me that I could probably compile and reference the common assemblies with a different name, and place those in the web app's bin folder - but that sounds really fugly...)
View 4 Replies
