I have developed an application which requires reading data from Excel file and performing some calculation. However for some reason the Excel file is always locked at the end of the computation after I close the application.
View 3 Replies
My program splits a mulitpage tiff file (batch of purchase orders from Sage MMS)into separate files by doing OCR and using the MODI functions.My code has three main loops. 1st loop goes through each of the pages and splits the tiff into separate tiff files based on order number and stores them in a directory. for each order i also create an array of information by doing OCR from the tiff ie. order number, customer etc etc. 2nd loop goes through the array. for each order number in the array checks to see if there is another tiff file existing in another directory. This could be a separate sheet which needs to be attached to the main purchase order and comes from a document scanner in another office.If there is an additional file i merge that tiff file with the current tiff file. 3rd loop goes through the array once more and uses the microsoft faxcomexlib to faxed the files using my server 2003 fax serverthe 3 loops work perfect and very fast and i can send the faxes no problem.
I also add all the array information into an access database so historical purposes.My problem:In the first loop i need to check that the fax has not already been sent. (users can reprint orders so need to be careful that fax isnt sent more than once) I do this by getting the order number and querying the database. If the order does not exist then i can proceed else i prompt the user to refax yes or no.i have put the database connection and sql in a function which returns true or false. however when i add the function to my main loops i get a file lock on the current order. If i remove the function my code works perfect.
Dim conn As New OdbcConnection(constr)
Dim cmdselect As New OdbcCommand
' Get status from current job
[code].....
here is the situation i am using the combobox with the databound dataset..i produce two combobox for that one field because i need to display the selected data in separate tabs... the combobox 1 is working perfectly i can select all data i want to but in the combobox 2 i can only see those data and when i select data on it, it will not display the selected data.. it still remain on the previous displayed data...
View 8 RepliesI'm using vb.net 2005, I've got the following code running a thread to download a file. However, the process fails sometimes when trying to read the local copy of the file. I think I may need to unlock the local file somehow but I'm not sure how to do this.[code]
View 1 RepliesHow could I lock any file in my PC from others access? I am trying to lock some my video, picture, Excel and Word file in my PC by using Visual Basic. I am using Visual Studio 2008 to develop this application but I am unable to do this job. It'll be something like security utility application. Actually without me, some other people also using my computer and I am trying to lock their access in my personal file. And I wish to know the tools which I can use for this job. I am just a Beginner on this development field.
View 4 RepliesSimple question. I have a log of actions that is in XML. When some action occures, the XML log is updated. I am using:Dim xmlData as XElement = XElement.Load( "DataLog.xml" )
to load the existing data. I then create a new XElement (NewData) and use:xmlData.AddFirst( NewData )Which puts the latest item at the beginning of the log. And finally, I write it out using:xmlData.Save( "DataLog.xml" )Ok, that all works fine. But there is no testing to see if anyone has (or is) updating the file ("DataLog.xml") during the process. This may result in lost data. Is there an accepted way to implement some sort of file locking structure that can be used to prevent this potential loss?
I have some code based on some previous posts that just won't work right.The code all runs without error.
-' strErrorLog holds a valid file name with full path
-' xmlNewError holds a valid xElement value
Using holdFile As New IO.FileStream(strErrorLog, IO.FileMode.OpenOrCreate, IO.FileAccess.ReadWrite, IO.FileShare.None)[code]When I step through the code, everything works.There is no error on the xmlError.Save call.However, the actual file is NOT updated.If I remove the "Using" commands and change the save to "xmlError. Save(strErrorLog)", then it writes just fine..It's got to be something really simple, but it's frustrating that I don't get an error message.But it does unlock the file..
I'm currently having issues with the following scenario:
1. I will build several DLLs with "Generate XML Documentation" set.
2. The DLL and XML files are copied onto another server (the build drop).
3. The copy will fail as the XML files are being locked by other users referencing these DLLs from their open Visual Studio projects.
Note that this also occurs on a local computer; open up two Visual Studios and use reference paths to reference the Binary folders. You'll find that the refrencing instance of Visual Studio will lock up the XML files causing the first Visual Studio to have problems compiling.
1. Is this a bug in Visual Studio 2008? Why is it holding exclusive locks on these files from the other computers? Is there a fix for this?
2. Is there a way to "package" the XML file into the DLL? I've noticed a lot of other .NET DLLs in the world that include all of their comments INSIDE of the DLL. No XML files necessary. (unless they're not .NET dll's).We're doing a lot of framework development here and it's imperative to include the XML documentation... unfortunately we've had to disable it to allow new builds to trickle through.
I'm writing a log parser which is reading a log created by a game. This log can be written to many times a second. My problem is that my program is preventing the writing of the log at times. Is there anyway I can read the log file without locking it?
Sub readLog()
If readyToRead Then
If FileInUse(fileName) Then Return
readyToRead = False
[code]....
I'm having some trouble setting up binding sources to these types of files, not sure if I'm selecting the correct driver in the wizard. Tried the generic ODBC and .NET drivers but it doesn't work, the dataset is created and adds a table but there's no data retrieved. The design object being used to display the table is a datagridview. Can't find documentation on dealing with files, only databases.
View 1 RepliesOn my computer I've VB.net 2005. and also office 2007. I try to open an excel file like that
Imports Excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
I have an excel file which I attached for ref. My intention is to copy the rows which start with the string "sarah" in column A & paste them to a new excel file, save it; copy the rows which start with the string "mike" in column A & paste them to a new excel file, save it.
View 11 Replies[code]I load a text file to a list box and if I try to modify or save over that same text file I get an access violation error. How can I load a text file and release all permissions/holds on that file?
View 4 RepliesHow to import an Excel file into SQL Server 2005.
View 7 RepliesI am using late binding to automate excel. How should i set the password of the new excel while which i create.
View 8 RepliesI m developing an application, where I would like the user to open an existing excel file inside the Application itself (Form)
View 1 RepliesI'm not sure if this is the right forum or not for this, but I'll post here until I hear otherwise. This had really become a problem for me and I can't seem to find an answer. A lot of my programs will export data to excel. When the wokbook is saved it will popup a save dialog box with a progress bar and a cancel button. The problem is the dialog box loves to steal focus. This causes a problem when for instance right now it is modifying several work books and when I'm typing I could end up hitting the space bar when the dialog box steals the focus and it will cancel the save. Is there some way to prevent the dialog from showing?
For an example this is some quick code I threw together. I have several workbooks that have more data than I need to archive. So it goes into each one and deletes those excess rows. The workbooks are in 2003 format, but I'm running 2007.
[Code]...
I am trying to open an excel file and write to it as data becomes availableI can create an instance of excel and write to the selected worksheet once. But, I can't seem to write back to the existing file. I keep on getting a null reference error when I try to send new data to the file.The function I am using will run once, but when it returns to the main form, I lose the values of xlApp and xlWorksheet. It appears that going in to the function makes the original values null.
View 2 RepliesI have to attach an excel file to a MSSQL 2005 database, using a project written in VB.NET 2005.
View 1 RepliesI have created an vb.net application in which ,I want to export sql table data to excel.
On form I have used one button namely "Export to Excel".
How to import data from excel file to my sql2005 @ vb.net?
View 4 RepliesI have a data in my listview and I just want to save it on excel. My code goes like this loading to listview.
[Code]...
I need my app to create a excel file, but I am getting a error running this code. While running this in debug, on the line "xlWorkSheet.SaveAs("C:vbexcel.xlsx")" there is a error saying "ComException was unhandled" and "Exception from Hresult 0x800A03EC"
Imports Excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object,_
ByVal e As System.EventArgs) Handles Button1.Click
[code]....
using FreeFile and OpenFile functions to find file-locking user name over network
View 12 RepliesI have an client.exe, through contextmenu in windows explorer i run this client.exe. is working fine. How to prevent , if user clicks same client.exe while its already runs.
View 5 RepliesHow should I generate an Excel File with this rule?Should not be able to paste an invalid value to a validated cell from other worksheet.
View 1 RepliesHow do I load or display an Excel file located on the hard drive in vb 2005?
View 2 Repliesi need to create an application(VB.net or VBA) which will convert text file contents into excel. u the contents fromt he text file have delimiters(special characters).The condition is while converting it should remove all the delimiters and paste teh content between two delimiters in to one cell.For Eg:
Text fiel content
|WGS|123123123|[Rxxxxx~CXXXXXCCCC~ADVANCED PPPPPPPP ASSOC
Excel sheet content:
WGS 123123123 Rxxxxx CXXXXXCCCC ADVANCED PPPPPPPP ASSOC
is there a way to detect if the text in a textbox contain code for Sql Injection?
View 2 RepliesI would like help with a script component in Visual Studio 2005 to take a text file as a source and convert it to Excel file (output). The text file uses a ~ (tilde) as the column delimiter.Also, can this be done without installing Excel on the server? Any and all suggestions are welcome. Below is sample I am having a problem with in the script component:
[Code]...
I keep getting an error stating that Excel.Application is not defined and I also get Option Strict On requires all vairable declarations to have an 'AS' clause. Can someone point me into the right direction?
