My problem is that when trying to print out a excel worksheet, after it has just beeen printed out onces. It gives me this error: "Object reference not set to an instance of an object", when trying to open the existing worksheet(the template)
I've really tryed to fix it, I think that the problem is that after the first print, i need to clear the worksheet and the excelapp.[code]...
How can I kill the excel.exe process in SSIS during the data flow task when it fails? There could be multiple instances of Excel.exe running from other packages that are perfectly valid so I don't want to loop through all instances killing them.My problem is that during the data flow task the process will sometimes fail due to a sheet that is named incorrectly or missing columns. This keeps an instance of excel.exe running which is now an orphan task eating up resources so it needs to be killed.At the same time there are other SSIS packages running that are accessing their own excel.exe process and aren't having any issues. So how can I kill the orphan excel.exe process without impacting the other excel.exe process?
View 2 RepliesI want a program where the user can browse to a particular folder, select it, then the program will print all .xls files within that folder. More specifically I want it print on the sheet named Turn-In within the .xls file. Is this even possible, seems like it should be.
View 6 RepliesI created this code to export from DGV to Excel and it worked with me. I tried to print the data from DGV to specific cells in worksheet but I don't know.
[Code]....
I have a template in an excel worksheet. I can successfully insert data into the worksheet and print it out with backend coding.
The problem I am facing is, the reverse empty space for the header and side is too much.
Is there any possible way to reduce the empty space?
I am trying to download chinese data from database to excel. But data is coming with different charecters in Excel like this Here is the my code for download excel. I don't understand what's wrong in my code.
[Code]...
I need stop printing and paper feeding in the middle of printing in dot matrix printer.(Like a POS Printer - When wrote 'End Doc' on POS printer can stop paper feeding)
View 4 RepliesI am using VB 2008 & Access Databases for creating WinForm Applications. Also i am using Crystal Reports for Report solution. my question is How do i created reports such a way that they can be printed in faster Ascii Format on any DotMatrix printer. The default true type fonts make printing very slower.
I tried to use "Draft 10 cpi" font which come to available me after i installed a correct driver for my Epson printer. which also helped me overcome this problem. however it wont be the scenario with all my clients i.e. they might have different printers having different Make with different drivers installed. i have tried to open such project on there PC but the printing wont come in Draft instead the fonts get expanded too much & the print wont come right.
I basically have an application that generates reports in a .html file, I use a .html file for the ease of making tables and formatting text.Now I would like to introduce a way of printing the reports from my program. Because I use a .html file, the formatting would not the correct if I was to print it directly from my application (as far as I know). For this reason, I would like to print it just like my web browser would have in order to keep the tabular data intact and the text formatting.
View 1 RepliesI'm creating an application which has an scheduler to print and it checks if there is a pending job on the print queue before it prints the next file. I use a timer which checks if there is any file to be printed on my database. Example, the timer ticks and selected 10 files to be printed, it should print the 10 files 1 at a time, if there's no print queue, that's the only time the next file should print. I think another timer is required which will keeps on checking if print queue is done. How will i do this?
View 2 RepliesI am setting up printing (to a printer or file) in my application, and it doesn't seem to print out any new lines that I specify. Here's some of my printing
' Loop through all of the text in the array
For i = 0 To 9
If i Mod 2 = 0 Then
[Code]....
When I print the output to a PDF file using PDFCreator, it stacks all of the letters onto each other rather than creating new lines at the places I've specified. I've also tried using vbNewLine instead of vbCrLf, but I haven't had any luck. I searched the web for this but couldn't find anything about it.
I need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Diagnostics
Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
I have a VB program that I'm trying to deploy. On my machine (the app works fine straight from VS), when I try to install it from the webpage, it asks me to setup .net. I only have a choice of repairing or uninstalling .net. I've tried both but both fail at the moment. The problem with the repair is, although it goes through the entire repair procedure, it then asks me to restart my PC, but when I hit 'restart', nothing happens. So I restart manually, but when I try again, I just have to go through the same procedure again.
View 2 RepliesAll 3 statements below do NOT download the file; BUT also do not create any error msgs! owever, when pluggingFTP://localhost/QMSpathFTP/Prozess Akquisition.doc directly into the IE the .doc is shown correctly! I.e., to me, the virtual directory 'QMSpathFTP' is correct!
View 2 RepliesWhy is hi failing to even hit the event? This should be htting the event, I see no reason why it would not hit this event when I press the enter key, instead I get a beep sound.
Private Sub Browser_1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown
If e.KeyCode = Keys.Enter Then
WebBrowser.Navigate(tb_Address.Text)
End If
End Sub
I'm trying to write a program to control input. Unfortunately, thing always seems to fail.
The thing always comes up with "Application Defined or Object Defined Error". It doesn't help that I can't find the complete listing of error codes[code]...
The following code works fine in Access 2007 but VB 2005 Dataset refuses to see it. 2 questions Why? and how do I call a function in a Tableadapter query? "sizecats" is a function that extracts a substring depending on the length of ContainerRef.
SELECT sizecats([ContainerRef]) AS [Size], Count(tbl_Bookings_Containers.ContainerUsageID) AS CountOf
FROM tbl_Bookings_Containers
GROUP BY sizecats([ContainerRef]);
I use vb.net to backup sql '05 - '08 databases. It works great on smaller databases. but when it comes to large databases it fails at 30 or 40 percent with the error: The backup or restore was aborted.
Dim objBackup1 As Backup = New Backup() With {.Action = BackupActionType.Database, .Database = Common.DsSettings("DataBase", Nothing), .Initialize = True, .Checksum = True, .ContinueAfterError = True, .Incremental = False, .LogTruncation = BackupTruncateLogType.Truncate}
objBackup1.SqlBackup(objServer)
I am trying to flatten a multi-dimensional array with ConvertAll but I can't get it to work:
Private Function Flatten(ByRef a As Object) As Object
Dim elements As Integer = 0
Dim size As Integer[code]...
Why does it throw NullReferenceException?
I wrote an application on windows XP using visual studio 2008. Based on the .net framework 3.5. For some reason that I do not understand the application refuses to run on windows 7. You would think that if the .net framework 3.5 was installed on the windows 7 machine it would run.
View 10 RepliesI'm catching the following error in a publishing script (VB.Net) I'm running:
Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
The code that fails is:
My.Computer.FileSystem.WriteAllText(path, content, False)
It runs fine for most of the files but some have a '~' in the path and those ones are all failing.
Just to clarify: i am using the full path an example of the path i am having problems with is "c:/websites/xml/myfile~test.xml" the ones that work are "c:/websites/xml/myfiletest2.xml"
I currently have this line of code which has been working for the past 6 months:
If IsNumeric(txtProductID.Text) Then
...do stuff
Else
Dim msg As String = "Error!"
End If
All of the sudden, no matter what kind of entry is put in txtProductID (including plain numbers), it fails! Is there reason for me to be going crazy over this?
I am currently using the AsyncFileUpload in my VB.NET web app. Locally it works perfectly, however on the server it fails to upload a small file (<9k). I can't even seem to debug this as in JavaScript handlers I have no idea as to how to get the error reason.
function uploadError(sender,args) {
$get("<%=LabelErr.ClientID%>").innerHTML = "Unable to Upload file for the following reason: ", "<span style='color:red;'>" + args.get_errorMessage() + "</span>";
[code].....
A VB2010 program fails to build because it doesn't recognise left() and right(). mid() works, though.
Microsoft.visualbasic.left() works ok.
Yet, in another VB2010 program, left() and right() work ok.
I have just finished my application using VB in Visual Studio 2005 and it works fine on my Win 7 development machine. But when I install and run it on an XP machine it fails with an unhandled exception:System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E8D851FA-9967-4ADF-9644-0183B9B1EA68} failed due to the following error: 80040154.
I've googled the error message and the solutions seem to be 1) compile as x86 (was doing that anyway), and 2) register the dll on the machine But firstly I'm not sure which dll I need to register, and secondly I don't want to be going around registering dlls - the whole point of the installation programs is that it should just install and configure everything automatically..
I am getting one issue while working with DTS Package using VB.Net application. I am using the following code to execute the DTS package.
[Code]...
I am trying to insert a picture in the RTB but my system hangs when I try to do it... No error message... it simply hangs... I also get a tough time calling the Task Manager to end it...
This is the code that I am using...
Is it going into an infinite loop?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles Button1.Click
[Code]....
RegQueryValueEx function fails in this program
Module
Module1
Public Const HKEY_LOCAL_MACHINE = &H80000002
Public Const KEY_ALL_ACCESS = &HF003F
Public Const REG_OPTION_NON_VOLATILE = 0
Key is preserved when system is rebooted
[Code]...
I am using the following function to backup a SQL Server database using SMO.. but the backup fails... I have no idea, why does it fail...
[Code]....
I am developing a vb script to query an Access 2000 database and return the data to a recordset and place it in to an Excel Spreadsheet. However I am not able to Complete the CopyRecordSet to the Excel spreadsheet I receive the runtime error "Microsoft VBScript runtime error: Class doesn't support Automation" at line "xlWs.Range("A1").CopyFromRecordset rs " [code]
View 6 Replies