Adapt A 32-bit VB6 Application To Work With 64-bit Office?
Dec 1, 2011
I have an application developed in VB 6.0 and VBA that uses latest Office 32 bit version. But since this application is 32 bit, it does not run on systems where 64 bit Office versions are installed. What is the best strategy I have to adopt to port this application to 64 bit. We have a mandate to use VB.NET and minimal (as much as possible) code modification from VB/VBA to .NET 64 bit. Please suggest the best option I can use so that I can leverage all best practices for this porting.
View 2 Replies
ADVERTISEMENT
Jun 16, 2011
how do I adapt the my application area to the user's monitor resolution?I have created a winForms application on 1280*768 resolution monitor and the application is generally used on smaller laptops (10inches). Now I need to a scrollbar on my entire application so that the spacing remains the same as I have designed. For this, there has to be a scrollbar (Both Horizontal and Vertical) on the application.
View 1 Replies
Apr 18, 2011
How to make a 32 bit VB.Net com add-in work with 64 bit Office 2010?
View 10 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 23, 2009
I'm trying to compile some source code that uses microsoft office task panes and to work with some speech recognition.Code is from the following article
Enabling Speech Recognition in Microsoft Word 2007 with Visual Studio 2008 -
[Code]...
View 3 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
Jun 28, 2010
After searching, I've discovered this code:
Public Sub ResizeImage(ByVal scaleFactor As Double, ByVal fromStream As Stream, ByVal toStream As Stream)
Dim image__1 = System.Drawing.Image.FromStream(fromStream)
[code].....
View 2 Replies
Mar 18, 2010
I am creating simple mail without any atach using Microsoft.Office.Interop.Outlook. Mail is successfully created and opened, but after this button 'Attach File' does not work (it could be clicked, file could be selected but it is not attached). Here is simple code:
[Code]..
View 8 Replies
Apr 12, 2010
I have the following code to generate combinations of string for a small list and would like to adapt this for a large list of over 300 string words.Can anyone suggest how to alter this code or to use a different method
[Code]...
View 2 Replies
May 17, 2010
Is it possible to use/show office assistant in my vb.net application?
(without using excel/word or showing excel/word)
View 11 Replies
Jan 4, 2012
I have an VB.NET 2010 application using framework 4 that has issues with reading and writing to cells using command similar to 'RequiredSoftwareVersion = EmployeesSheet.Cells(37, 4).value'. The big thing is I can open/close the workbook, select which worksheet in the workbook. On some computers it works fine, on others I get a pop-up that asks if you want details, continune, quit. All the computers have Office 2007 installed.
View 4 Replies
Mar 24, 2009
I would like to open a file in an application using vb.net 2008. I am unsure which namespace to use. I do not want to assume it is the current associated application. I believe there should be a way to...
Dim app as something
Open a file in that app
View 5 Replies
Jul 30, 2009
I know how to program this task easily using vb.net, only because i had to do a similar task a few seasons ago. However, when I confronted this task last week my previous solution did not work.Here is my code.Code:'using VS 2005 so i added the COM reference: Microsoft Excel 10.0 Object LibraryDim xlApp As Excel.ApplicationDim xlWorkBook As New Excel. the .Net Office Automation forum
View 8 Replies
Oct 3, 2009
I am trying to add Office Ribbon Controls in windows application project from VS ToolBox under Office Ribbon Controls Tab. but i can't because it appears as dissabled. i tried with several different projects like wpf and other projects too. how should i use this controls with win app project?
View 5 Replies
Jun 4, 2010
I have this function which evaluates the contents of a textbox (or combobox or maskedtextbox) control and, in conjunction with a KeyPress event, will either allow or disallow the input. It is quite useful for dates or textboxes for which only numeric input is valid. It allows a set number of digits after a single decimal point, if specified in the function call. It also allows the backspace character if the textbox is full.
I would like it to allow me to input what would otherwise be valid text when the textbox is full but one or more characters are highlighted (and would therefore be replaced by the keypress character.
[Code]...
View 1 Replies
Jul 30, 2009
how to open Ms office files in web browser with windows application. but its working in office 2000 its not working office 2007
[Code]...
View 2 Replies
Sep 21, 2009
how to make an application look like windows office 2007?
View 16 Replies
Mar 9, 2010
Application' is ambiguous in the namespace 'Microsoft.Office.Interop.Excel
View 12 Replies
Oct 3, 2011
I 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?
View 1 Replies
Apr 15, 2009
I have an application, running multiple threads, and in many of these threads, Outlook is being called, some mails read, attachments downloaded, and then the outlook instance closed. But it is possible that there are a number of threads trying to do the same thing at the same time. There is of course a lock at the beginning and end of the process, so that no two threads try to access the outlook application at the same time.
"Sometimes" i get an error message : Creating an instance of the COM component with CLSID {0006F03A-0000-0000-C000-000000000046} from the IClassFactory failed due to the following error: 80010108
View 3 Replies
Apr 27, 2012
I need a third party API to convert *doc, docx, rtf, txt, xls, xslx, pdf into HTML/HTM * format without using MS Office component(MSWORD/EXCEL) in backend. This API must support RELATIVE path for images as I will use it in ASP.NET Web based application
View 2 Replies
Dec 9, 2009
It says .Application ambiguous Error6'Application' is ambiguous in the namespace 'Microsoft.Office.Interop.Word'.
Imports Word = Microsoft.Office.Interop.Word
oWord = CType(CreateObject("Word.Application"), Word.Application)
oDoc = oWord.Documents.Add()
View 5 Replies
Jul 13, 2010
I am using visual studio to create an application that opens an excel file and then for each entry in the first column the entry in the second column is stored in an array. Then excel opens two other workbooks and for each entry in the first column it searches for a match in these other two workbooks and stores the corresponding value in an array.
Anyway, the problem is closing excel afterwards. I have used the thread: [URL] to work through the basics of cleaning up. I used the cleanup code provided and added the WithEvents caveat. I do not have strict option on.
I believe the problem is the fact that I have three workbooks open.
This is my cleanup code: (wrkbk, wrkbk2, wrkbk3 are the workbooks; datasheet, datasheet2, datasheet 3 are the worksheets; excel is the application)
Code:
GC.Collect()
GC.WaitForPendingFinalizers()
GC.Collect()
[Code]....
I got the impression that order was important in the cleanup procedure so I have tried some variations of moving the workbooks and worksheets around.
View 1 Replies
Dec 14, 2010
I have written an application which uses the Outlook object library to send an e-mail with information from a textbox. I programmed this on Windows 7 and Office 2010, which was a mistake as most of the clients will be using Windows XP and Office 2007. I am getting an error when running the application on Windows XP/2007:
Could not load file or assembly 'Microsoft.Office.Interop.Outlook, Version=14.0.0.0 .... etc
I understand that this is because I have not loaded the Outlook 12.0 assemblies, however I am having trouble adding the assemblies on my Win7/2010 programming machine. I have downloaded the standalone Office 2007 PIAs however the Outlook 12.0 doesnt appear on the list, and when I try and add just the Office 12.0 I get an error.
is there a way to standardise and make the application work with both 2007 and 2010 outlook machines? I think it is possible, I have read some articles making the application choose the correct version, however cannot figure out how to.
View 4 Replies
Nov 10, 2009
We have currently upgraded our development machines to Windows 7 and Office 2007. We have a vb 2008 app that references 2003 Office components to use for mail-merging to word.We loaded up our app in the vb environment today and were instantly greeted with missing components/functions which are related to the 2003 Office components. We can update these to use the Office 2007 components/functions instead, however we are unsure whether after doing this our vb app will work with machines only with Office 2003 on. can machines with Office 2003 on work with our vb app that references Office 2007 components?
View 5 Replies
Mar 28, 2011
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
View 2 Replies
Feb 15, 2011
I've developed shared addin for Microsoft Word. I distribute this addin with my application and using Inno setup for installation. The Inno setup installs my application and then runs "myAddin.msi" file in order to install addin.
how to uninstall this addin programatically?
Right now, in order to uninstall addin, the user has to to it manually through control panel.
View 2 Replies
Apr 30, 2010
I am working on a VB2008 Express application that makes used of the office interop access. The exact code is:
[Code]...
View 2 Replies
Jul 25, 2010
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 Replies
Nov 27, 2011
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, I am using office 2010.
View 1 Replies
