at the moment I have a small application and need to take information from an object and display it into an excel file, using the Microsoft.office.interop class I've been able to write to the file, and it shows one by one the records being added, however about once every 3 times I try it, the spreadsheet stops filling somewhere between the 300th and 600th record, I have 6,000 in total and it's not breaking every time, I put a check after it finishes to see whether the last record is filled in but the code never reaches that point and I'm unsure of what's happening I also don't know how to debug the problem as it'd mean going through 6,000 loops to check for it stopping... which might not even happen?
I am in the process of converting VB6 in to Dot.Net 10. Phew. Fast way to learn a language
Currow value=24 in this instance
Arsheet2b = ObjExcelB.Sheets(1).Range("A2:L" & curRow).value <error> System.InvalidCastException was unhandled Message=Unable to cast object of type 'System.Object[,]' to type 'System.String[]'. </error>
I can restrict the sheet from A1:A24 (contains 2010) and I get the same error.
I have a psychology experiment that has users respond to specific text or pictures by pressing either a button for "similar" or a button for "opposite" and then the program records the time from the presentation of the stimuli to the time they press one of the buttons as the latency. I have the information ans some other data successfully exporting to a text document but would like to have just the latency data also go into an excel spreadsheet for easier analysis. Here is the code for one of my buttons that currently writes to the text document:
[code] objExcelAppDataSheet is the excel application's object and strTemplatePath is the path of the excel file.This excel file is like a template that i am using in my application. In this file some cells are merged. After copying to the new sheet the formatting of the sheet does not remain same. Columns sizes are changing. Why this problems occurs? Is this MS office versions issue??
i developing a application in vb.net using third party tool Farpoint Spread control i need to set the position of spread while we enter in another spread cell?
I'm looking to sell some Applications i have made. What's the best way i can protect my applications from being spread around easily? I know there's no Sure-fire way of protecting my App.. but there must be a good program or something that will give me a helping hand.
I need to copy data using Vb.net if possible from one excel spreadworbook to another and place the data into the correct columns in the existing excel spreadsheet. The column titles of the spreadsheets match up, I have several templates I need to place data into and the order of the columns is different in each template so I need a way of searching for a column header in the template and then copying the data into that column.
My app is a fairly simple and im sure with the right knowledge this would take 2 minutes.. but sadly iv been at it for hours. So my scenario here is a huge network with 20+ file servers all with data spread out across them it can take hours to find the folder required.
Hence this app.. so it consist of a input box, progress bar and a button, using FileSystemObject I plan to interrogate a directory to see if a folder exists (folder specified by user input) however it need to check multiple directories, in my old app I used a list box which wrote to a text file allowing the user to add additional directories then using if statements proceeded through the servers.. however they have added that much that my IF's have ran out really because i know it should have been a loop
Imports System Imports System.IO Public Class Frm_main Private Const FILE_NAME As String = "C:directories.txt" Dim objReader As New System.IO.StreamReader(FILE_NAME) Dim Lines() As String = IO.File.ReadAllLines(FILE_NAME) Dim Dir As String
I have a bunch of Excel files full of research data. Everything is strait forward: rows of research categories and columns of research parameters. I want to create a simple search form that allows opening any of the spread sheets that contains the type of data that I specify. For example, I would choose a parameter
Basically,I had a button in my form1,when I click it,then form2 will be display...Now I would like to lock form2 until a button in form2 had been clicked,then only I can do anything in other forms...I means form2 must be closed before I can remain to form1.
I have a form and its filled from a VIEW of two tables on SQL server. When its opened i dont want other users opening that customers details from either table.I know SQL itself prevents writes if its opened but i want to stop people opening the record in the first place.[code]...
I then tried writing these values to the db on the form loading but it doesent work - it just sends back NULLs. I tried the same code in the on load event into a button and it works fine there. So im thinking i should do this as a Trigger on SQL itself, but im unsure how i could get the users computername or Windows Login name, or even username from the front end im building.
What I want to do is to lock the file so that no other process can use the file. If a process wants to use the file, I also want it to wait and try again until file is available.
Using vb.net 2008 to create an Excel ss. I am trying to add a new sheet and it does but it puts it out of order. It puts it as the first sheet. I need it as the last one ( furthest to the right).
Code: With xlWorkBook .Sheets("Sheet1").Select() .Sheets("Sheet1").Name = "config"
I have created a connection to an excel file. This is the code i created to select the data in the excel. But i want to make the [sheet1$] to be dynamic, which means it will get the sheet name depending on what is in the excel workbook. This workbook has only one sheet. This is to make sure that there will be no error when the sheet names are different. [code]
But not my application.A app i use refuses to be brought forward, so wondered if there was a way for a vb app to run in the bg that can force a specified application to stay on top, & even maybe set its screen position and lock it there???
In my project i am using begin transaction commit or rollback changes. but this causes lock to the tables in that particular functionality.
So if the any other user does any other functionality those locked table are not available until the transaction is completed. I want to know if there is any alternative to transaction which insures data security but the tables are not locked out.
