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
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 RepliesI 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 RepliesI 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].....
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.
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...)
I am developing an application using VB.Net which is a simple executable which is to be run from a network drive of our company servers. Most users can access this executable without issue - others however can open the executable but have no connection to our database (even though when running the executable off a local drive such as C:, the database works no problem).
From some posts I have seen this might be a CAS issue - however our IT department suggest the issue might be down to different version of the .NET Framework being to blame. Firstly, is this the issue? Secondly, how can I develop my application to work with different versions of the .NET Framework? Surely this doesn't mean developing many different executables?
I do have an application distributed with click once. I want this application to be installed (and thus distributed) two times on the same computers. One time as production version and one time as deployment version. When trying to do so, I get the folloging error:
"Unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for this application or uninstall the preexisting application."How do I modify the manifest version in a way that allows my easily to switch between "Production" and "Testing"-Version?
how I can go about having a ini type file so my.settings don't get over written when I load newer versions of my application?
View 3 RepliesI am converting several VBA projects to Windows form applications. The only problem I have is that some of the functionality of Excel is essential to the application, such as R1C1 formulas. I do not want to instantiate the Excel application or access saved worksheets. All of the data is retrieved by querying Oracle databases. 2-Dimensional arrays are not an option because the columns contain differing datatypes, and DataGridViews are too slow to work with.
I thought simply dimming a Microsoft.Office.Interop.Excel.Worksheet object would be enough, but the program kept failing and upon inspecting the object's elements in debug mode, I found that every value says this:
{"Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.WorksheetClass' to interface type 'Microsoft.Office.Interop.Excel._Worksheet'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D8-0000-0000-C000-000000000046}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))."}
I want to encapsulate the use of Excel Interop to make it easier to use somehow in a reuseable library.So far, I have written some tests that work good altogether, except that between each test, I force Excel to quite so that it does have handle on the test file no more in order to be able to delete.Once I quit the application instance between after each of my tests, Excel seems to be no longer responding, causing Windows to display "Excel has stopped working and is looking for a solution"
message. This message lasts a few seconds, meanwhile Excel is closing, causing the hang on the file to occur and my tests to throw an exception like "Cannot access file because it is being used by another process..."
[Code]...
i'm trying to save an excel file after I open my excel application. This is what I have so far:
'Opens the report
xlPeakDemand.Visible = True
xlPeakDemandWorkbook.SaveAs("C:Documents and
[Code].....
When saving as an xls it works fine but when saving as a htm its a disaster Just a bunch or symbols and stuff. BUT if I go into my xls document and Save As webpage from there, it works fine!
how I can use excel 2003 and excel 2007 on my application. I add a reference to Excel 12.0 Object but this one is not compatible with Excel 2007 and i think if i add Excel 11 Object it will not run on excel 2007.
Is there any solution that I can use so that my project can be used with either excel 2003 and 2007?
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 RepliesI 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
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.
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.
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 Repliesknow 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.
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]...
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 RepliesI 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 RepliesI 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?
I have some project that written in .net 3.5 environment. But there still some dependency to .net 2.0 .How I can find this dependence parts of the code that use the old API ? I just want to update all code to 3.5 version.Project written in vb.net.
View 4 Replies<edit> On 27th January, 2011.If you are using VB.Net 2005 or earlier then please see my 14th post in this thread.</edit>I saw a post earlier on which reminded me about Extension Methods.This led me to create the following code which acts on the base class
[Code]...
Compatibility Between the 32-bit and 64-bit Versions software of .net2010
View 2 RepliesThe software I design is for Win XP and older versions such as Win 98, ME, 2000 etc. I currently use VB6 and Win XP for development and packaging, the problem I encounter is that if I use the deployment wizard in XP, the setup will only work on an XP machine and I need to copy all my source to an older machine and use the wizard again to create another setup file which will only work on the older operating systems. Is there a way to rectify this in VB6? If not, does the new VB account for this and be able to make a setup file for older operating systems as well as XP?
View 2 Replieshow is it possible to get the CD TOC with Visual Basic 2008? Is there anywhere a tutorial about this?I have found some links but all is described with older Versions (VB 6).
View 1 RepliesI am having problems using the GetWindowRect statement I've searched many forums and used the API text viewer to obtain the declaration statement of which there are a few different versions, a couple being :
View 3 RepliesI don't think this is possible but thought I'd just double check...
I have a class library project (i.e building this project results in a DLL being created) and I add a reference to this DLL in several of my other applications. This DLL project targets .NET Framework v2.0.
However, some of these apps that use the DLL target .NET 2.0 (or 3.5) and some target .NET 4.0. But because .NET 4.0 does not include 2.0 and 3.5 in it, its possible for someone to have .NET 4.0 installed but not .NET 2.0, therefore meaning that they won't be able to run my app because of the reference to a DLL that requires .NET 2.0.
So the solutions as far as I can see are: 1. Include .NET 2.0/3.5 as an additional prereq for my .NET 4.0 apps... ewww. 2. Create a copy of this DLL project and make it target .NET 4.0 then in my .NET 4.0 apps add a reference to that rather than the .NET 2.0 version.
So far I've been using the second option, which is working fine but its just very annoying having to remember to copy and paste any changes I make in one version of the DLL project into the other one.
So is there any way I can have a single DLL project but have it build 2 versions of the DLL, one targeting .NET 2.0/3.5 and one targeting .NET 4.0? As I've written this down I've just realised I could always build the solution, copy the DLL out to another folder, then change the target framework and build it again to get the new DLL but that's still not ideal.
Using VS 2010 Ultimate by the way in case that makes any difference to the options I've got available
