open and read and write and save to Excel and word documents in a program if the machine that is being run on does not have either of thies apps installed. Are there files that I can include in my application that it could be worked on in my application and not need word or excel?
View 3 RepliesI'm facing a problem reading .csv file into datatable. The machine on which i install my window service ( which reads the csv ) is Windows Server 2008 R2.The error i get is : The 'Microsoft.Jet.Oledb.4.0' provider is not registered on the local machine
Below is the code i use to fill the dataset from .csv file :
string connstr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + System.IO.Path.GetDirectoryName(arrFilesName[iCount].ToString()) + ";Extended Properties = 'text;HDR=YES;FMT=Delimited'";
OleDbConnection conn = new OleDbConnection(connstr);
[code]....
I also looked at the other option i.e. Micorosft.Office.Interop.Excel but that also needs Excel installed.So, I would like to know that, is there a way to read a .csv file without having Microsoft Excel install on the machine.
I've created a small app in VB that creates Word documents from data stored in Access, which I plan to distribute for non-commercial purposes. I'm using VB 2005 and Office 2007.
All the target machines are either Windows 2000 or XP.
1) I know that if I use mdb file for Access, I don't need to install Access on these machines. Is it true for accdb files as well ?
2) Is a Word installation required on each of these machines ? Or, can I make VB to create an exe that takes care of this ?
why this code doesn't work?
Dim s As String
For Each s In PrintDocument1.PrinterSettings.InstalledPrinters.ToString
MsgBox(s)
Next
what happens if I use a font in my WinForms app that isn't available on the target machine - does it use a font in the same family or just Sans Serif or something else?
View 1 RepliesI am using mshtml to parse HTML in my ASP.NET-MVC application. Works great on my development machine, which has VS2008 Professional installed. Works great on my staging machine, which has VS Express 2008/WebDev installed. But it throws a FileNotFoundException when trying to load the COM object on the production server, which has no versions of Visual Studio.
Exception type: FileNotFoundException
Exception message: Could not load file or assembly
'Microsoft.mshtml, Version=7.0.3300.0,
[Code].....
I don't want to install Visual Studio on the production box. I have read a suggestion that running C:Program filesCommon FilesMerge modulesvs_piaredist.exe solves this problem but this directory does not exist on my production box. How can I use mshtml on the production machine?
I'm looking on the Internet but not found anything about how to detect what the frameworks are installed. Someone I can provide that code to VB. Net? TcoUpLoad (work with Vb6 and VbNet)
View 3 RepliesWe have a certain application installed on a single machine. I would like to enable/disable a button based on the existence of this application. Is there a way to check for its existence from asp.net?
the app is currently on an XP machine, but want to code for Win7 as well. VS2008 3.51. Asp.net
I have a Windows application written in VB.NET in Visual Studio 2005.The application opens a form to perform some measurements and to present data.
The application works fine when i run it om my "development computer" in debug mode. Also when i install in and run it on my computer.
But when i install it on the customer computer and run it i get a form that is smaller in size (not as wide as in my computer) and the result is that lots of graphics components are located outside the form and therefore not availible for the user.
I installed VB Express 2008 on my machine and it went without a redistributable file. It got download during the install. Anyone knows where I can download the redsitributable file from, so I can give it to my students?
View 2 RepliesI'm creating a WindowsForm application and I need a code to check target's machine installed version of DirectX.If the reg key doesn't match with provided one >>> load the form and launch the DX installer "redistdirectx_Jun2010_redistDXSETUP.exe"If the reg key matches with the provided one >>> launch other application "Setup.exe"
Provided version:
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftDirectX]
"Version"="4.09.00.0904"
I am developing a software and i need to make it save a text document, I can make it save it by writing the path of my document on my machine but it wont work on other machines when installed, how can I make it do this?
View 2 RepliesI am generating PDF file using Crystal report ExportToDisk method in VB.NET 3.5.
Locally and on integration environment generated PDF file is much readable i.e.font size is good. But the PDF file generated on production environment is different in formatting.The lines are wrapping and font size is also little small. There is not Adobe installed on integration.
I have read some of the other posts on this and seem to be a little different than my situation. Trying to print out some reports into an excel document on the clients machine - of course it works fine on my local (heard that before right). I went in and set my references Ms.Office.Core and Ms.Office.Interop.Excel to 'Copy Local' = True so the .dll are in the servers bin folder.
[Code]...
I have a project that has a need to display a Excel file in second window, but because other controls are needed, simply launching excel is not sufficient. Right now I do not know if the target machines have excel installed but I know with certainty that if they do it would be 2010, is there any method or library that allows you frame your own form around an excel window?
View 1 RepliesI am uploading an excel file to my app and want to read it. Do I need to have excel loaded to read this?I am getting an error of Object reference not set to an instance of an object.
Public Function GetExcelData(ByVal ExcelFilePath As String) As DataTable
Try
Dim OledbConnectionString As String = String.Empty
[code]....
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
I tried to read excel file using the method i found here [URL] But i get an error on ADODB.Connection saying "Type 'ADODB.Connection' is not defined" in the following code:
Code:
Private Function GetExcelConnection(ByVal Path As String, _
Optional ByVal Headers As Boolean = True) As Connection
Dim strConn As String
[Code]....
Its was used in VB6... do i need to do something special in Visual Studio 2010?
I need to export Chart(image) and grid (tabular) row data into excel file. I can not use automation because Office tools are not installed in my server. I've found a bunch of free/proprietary tools like:
NPOI
MyXLS
ExcelWriter (softartisans)
JetCell (DevTrio)
Aspose.Cells (Aspose)
But I do not know which one is better for my needs. I need to export not only grid row data but also Chart (image), thats why I am thinking about.
I have been doing a lot of reading on this topic and most folks seem to agree that having Excel is required to use the COM Interop libraries. However they are never specific as to where that should be installed. Does it need to be installed on the machine I am developing on or does it need to be on every machine that I deploy to?
Edit: I should mention that this is desktop development/deployment targeted for all Windows machines.
Is there a way in VB .NET to create an Excel file without having Excel installed?
View 7 RepliesI'm trying to code a spelling checker into VB.NET 2010.It'll check the RichTextBoxFindandPrint (my version of RTB) control.However the solutions on the internet require Word to be installed. [URl]..
View 26 RepliesHow would you programmically check if Microsoft word and at least a pdf reader is installed on a machine?
I need to figure out some way if the machine can read a particular file. If it can read a pdf or word file.
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?
Need to install a font on all user's machines that will use the application I am writing which creates custom documents in Word. It's a barcode font.I've successfully added the font to my solution and set its build action to Embedded Resource and have also successfully written code to check if the font is already installed on the user's system.
View 3 RepliesMy application is in VB.NET and environment is Window XP. We are using WebBrowser control to display data of Word doc files i.e. we are opening word files always inside the WebBrowser control and then modifying word file using bookmarks by VB code.Our VB code is perfectly working. We are doing following changes in window registry via VB.NET code for temporary basis:1)..HKEY_LOCAL_MACHINESOFTWAREClassesWord.Document.8updating BrowserFlags value to H800000242)..HKEY_CLASSES_ROOTWord.Document.8
View 3 RepliesMy application is in VB.NET and environment is Window XP. We are using WebBrowser control to display data of Word doc files i.e. we are opening word files always inside the WebBrowser control and then modifying word file using bookmarks by VB code.Our VB code is perfectly working. We are doing following changes in window registry via VB.NET code for temporary basis:
[Code]...
Now we are migrating environment from WinXP to Win7. I have following query for Win7 environment We do not have rights to change registry on Win7 machine , so without changing values of BrowserFlags and EditFlags , how word docs files will always open inside webBrowser control? Currently I am getting below popup dialog box
I 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 have a windows form application that when it starts needs to see if the user has Excel installed on the computer and if not display a message informing user that part of functionality will be disabled.
Is their an easy way to perform this check?
Working in Visual Studio 2008 with VB.Net
I've been tryin' to develop macro, that can find table in the word and then copy it into the excel. Now it works, the only problem is, that is only the first row, that get copyed...
example (cell /w three lines in it):
Today is great day
Today is not a great day
Today, it is outrageous day
and with the code bellow, I get only Today is great day
Code:
For Each tTable In ActiveDocument.Tables
n = 1
With tTable
[Code].....