Whenever the code invokes the open dialogue box statement of the VB6.0 code, the application gets terminated.It is expected to open the dialogue box to provide the file path. I'm also having MS Office 2007 enterprise edition. If I do not have MS office 2007 enterprise edition installed, then it is working fine without any problem. So any suggestion/remarks to work on MS office 2007 enterprise edition?
View 1 RepliesI 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))
This is a Visual Studio forum but can you help me regarding Visual Basic 6.0 Enterprise Edition? I cannot find the CRYSTL32.exe in Visual basic 6.0 Enterpise Edition installation cd. I already some articles and it says that i can find it through this path CommonToolsVBCrysReptCrystl32.exe I alre cd.I saw in my installation cd this path (when I open the cd) Common/Tools... and there is no VBCrysReptCrystl32.exe VBCrysRept so that i can run the Crystl32.exe? I'll be needing it for my programming project which has Official Receipt issuance and somebody told me that i can use crystal report for pie Chart. Is that true that I can use Crystal report for pie Chart? Please also help me to find tutorial regarding crystal report. I am using Visual basic 6.0.
View 1 RepliesWe are using VB.NET 2008. This program must run on a 32 bit operating system.
The machine where the program is running at is a 24 core machine which has 16 Gig of RAM.
It has a Win Server 2003, Enterprise Edition SP2, x86 based PC.
When the VB.NET program VM Size reaches about 1.3 Gig, it says "Exception of type 'System.OutOfMemoryException' was thrown."
When I go to Task Manager and check the Processes, "Mem Usage" for this program is about 300 Meg and "VM Size" is 1,341,300.
These are the information from Accessories - System Tools - System
Information:
Total Physical Memory is 16.37 Gb.
Available physical memory is 14.46 Gb.
Total virtual memory is 17.74 Gb.
Available virtual memory is 15.73 Gb.
Can my VB.NET 32 bit program access more than 1.3 Gig of VM in Win 2003 SP2 Enterprise edition ? How can it do that ?
According to [URL] the memory limit on this kind of machine with x86 is 64 Gig.
I want to know how can i update my visual basic 6.0 MSDN library.
View 1 RepliesWhat is the difference between professional vs enterprise edition of visual studio.
View 2 RepliesI am having trouble while installing Visual Basic 6.0 . Setup gives message
View 5 RepliesI have to insert/update shipper information and I wrote a stored procedure like this:
IF EXISTS (SELECT * FROM sysobjects WHERE name='usp_Nucleus_LSS_AddShipperInfo' AND type='P')
DROP PROCEDURE usp_Nucleus_LSS_AddShipperInfo
GO
CREATE PROCEDURE dbo.usp_Nucleus_LSS_AddShipperInfo
[code]....
I am using VB.Net 2.0 and SQL Server Enterprise edition.
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 Repliesi 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 am looking for a way to modify the default values in windows vista and or 7.
Examples:
* The default directory for the save/save-as dialog box.
* The size of the window.
* The "favorites" list on the left of the box.
I have been looking for a while and the only thing I can find is to edit the group policy but this will only affect programs that are using the xp dialog box.I am sure this is actualy pretty easy but I cannot find anything for the life of me
I am working on a MSDN project from 2007 it calls for a Common Dialog Control but I can not find it. Has this been deprecated and/or is there something to replace it? If not how can I access this in VS 2010 for a VB project?
View 16 RepliesIm trying to write a few scripts for use in AD in VBscript I thought it would be nice and straight forward to be able to open csv files and the like by using a Browse For File Window so the help desk can simply find browse for the file but i am not having much luck.
[Code]...
I did this before but can't seem to remember how. How do I include a .COM tool into my IDE (like Common Dialog)?
View 2 RepliesI'm sure most people on here have opened an OpenFileDialog or SaveFileDialog and set the SelectedPath property to point to some directory...
Has anyone done this on a Windows 7 machine and been able to point the thing to a Library? If so, what do you set it to?
I'm trying to use common Worksheet functions found in Excel 2003 (average, standard deviation, etc) from within VS 2008. See thinned down sample code below:
Code:
Imports Microsoft.Office.Interop
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
When ran it returns "New cannot be used on an interface". Removing "New" returns "'WorksheetFunction' is a type in 'Excel' and cannot be used as an expression."
I've added a reference to the Microsoft.Office.Interop.Excel library v11.0.0.0, which I'm using in other places in the code with no complaints.
i have a vb script that is imbeded in an html page (hta). when i use the common dialog flags = cdlOFNAllowMultiselect the file list is present in the filename object and are separated by a space. however when i use dialog flags = cdlOFNAllowMultiselect Or cdlOFNExplorer the files that i selected on the dialog box, are not present in the filename object. the only thing that's there, is the path to the files. here's the code:
Const cdlOFNAllowMultiselect = 512Const cdlOFNExplorer = 524288Set ObjFSO = CreateObject("UserAccounts.CommonDialog")ObjFSO.Filter = "All Files|*.*"ObjFSO.FilterIndex = 1
ObjFSO.InitialDir = "c:" ObjFSO.Flags = cdlOFNAllowMultiselect or cdlOFNExplorerinitFSO = ObjFSO.ShowOpen selected_files = ObjFso.FileName msgbox selected_files
how can i get the files names?
I am not able to add records in an Access 2007 database using VB 2010 Express Edition. I have read other posts and followed them but still I am not sucessful. I have the connection to the access database as MS Access Database, therefore it has the OLEDB connection (not the Jet 4.0). I am using the project instance in binding the text boxes to the fieldnames in the Access database. Did I miss something? I am also using Windows Vista Ultimate.
Below is the code.
Private
Sub
cmd_Save_Click(ByVal
sender As
[code]....
I have created a PowerPoint addin using the steps from this article: Using RibbonX from Visual Basic
The plugin works fine when I start the project using F5 in Visual Studio 2005. But if I try to use the installer created by the setup project that is automatically added to the solution, the plug-in won't show when I run powerpnt.exe
Is there something I missed? Do I need to make some modifications to the installer?
this is my vs:but i want to get the office 2003 and 2007 add-ins in it.i am using the professional edition of vs do i need to install some components?
View 5 RepliesI have an Excel file endowed with a macro written under Office-2007.This file can be opened by Excel-2003, but the macro can't run because 2007-objects can't be recognized.My question is: does it exist a library or some trick to allow the macro running under Office-2003?
View 1 RepliesI Am about to buy a new office, and I must decide between 2007 and 2003.
I'd like to buy 2007 (same price where I live) but I cannot stand the UI.
Is there a way to make it look like 2003 (for me Word/Excel is enough) ?
[URL]
i have a question i need to copy email message from folder to another with VB.net 2008
View 1 RepliesI have a application VB.net which is working fine for office 2003.But one of the user has installed office 2007.I dont have the knowledge of BindingRedirect .
Old references
Interop.Access version 11.0
VBE.Interop version 11.0[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 have installed the Microsoft Office 2007 addin to convert to PDF. Now I try to do the following code from VB to convert a word document to PDF it gives me the error Invalid Procedure call argument. Below is the code
Private Const Fname = "C: est.docx"
Private Sub Form_Load()
Dim obWord As Object
[code].....
It is my first time to code vb2010 with an application of database. I am doing my inventory system project and i do not know how to start my project. Can somebody help me to find a tutorial in visual basic 2010 and New Microsoft Office Access 2007 Database? I would like to use vb2010 and New Microsoft Office Access 2007 Database... Is this possible to use for my project?
View 10 RepliesOffice 2007 Ribbon in VB Express 2008?
View 8 RepliesI have print HexaDecimal u0081 which prints a unchecked box in a WORD document. When I used the following in Office 2003 environment : WdSelection.TypeText("u0081") It printed the required checkbox. but when I use the same line in Office 2007 its not printing anythings(empty space). Does not throw any error. Request to help to fix the issue around TypeText() parameters in Office 2007.
View 1 RepliesI have downloaded the official office 2007 UI ribbon .dll, but now what? I am coding in VB.net. I do not know where to place this .dll, and I do not see any additional controls anywhere at all. The readme explains how to license your copy, which I have done.Now what? I am hoping to magically see the ribbon control in the list of components I can add somewhere, but its just not there....Is there even a way to use this as a drag-n-drop component with the WYSIWYG Design View?
View 4 Replies