Search:

anyone?

I have ~ 1 page how to that is currently in a text file which I want to add to a richtext box.

I am just wondering if there is some way I can just copy/paste it so it keeps its formatting etc.

My ninja edit was a little slow. Anyways I figured it out:


''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
...

Sorry, I should have given you my actual code, not just something similar.


For i = 0 To (ListView1.CheckedItems.Count - 1)
description =...

Sorry, I am a little confused. I read the database like this:

Using connection1 As New SqlConnection(Form1.ConnectionString)
Using command1 As New SqlCommand("SELECT...

Well I have something in my database like:


JobNumber Hours Employee Exported
1 3 Joe 0
3 5 Bob 0


I read that and and write it to a .csv...

So I do something like this:


ListView1.Columns.Add(" First Name", 150)
ListView1.Columns.Add("Last Name", 150)
ListView1.Columns.Add("Week Number", 50)
...

So when I export a database entry I want to change a value from either Null or 0 to 1. I have found tons of example on how to add entries, but I am not sure how to edit one.

I currently I am...

I have a table that has lots of entries. I want to delete all the entries.

I tried this but it doesn't work.

Using connection As New SqlConnection(Form1.ConnectionString)
...

Thanks, that seemed to work. My boss has the same Office products installed as me, so is there any other reason why it didn't work for him?

2008 express.

When I go projects-> add reference there is no "Microsoft Excel 11.0 Object Library" under the ".NET" tab.

I use the COM version cause thats what I read I needed and there is no .NET version.

Not sure what you mean by installer or xcopy.

I don't know if it will be possible to install the PIA's on every computer running the app. I will need to include it with the app.


If I look under my references, and choose properties for the...

There is no dll files there.
edit: this is not a webserver, just a file server.

I have a program that reads data from excel.

I use:
Imports Microsoft.Office.Interop
as well as a Reference from the "COM" tab called "Microsoft Excel 11.0 Object Library"

I built my program...

So I have a connection string which is read from a basic text file. This string contains a password. Is there anyway to encrypt this text file so that anyone can't just open it up and read it. The...

I took it out and just use the value directly (without declaring it)

''''' Timesheet Table ''''''
If nameexists = True Then

Using connection...

Dim aWeekNumber As Int32 = WS.Range("I4").Value was the problem.

Thanks so much.

Ok, I have done some rigorous testing and have some new info.

If the database is empty then excel quits as expected.
If the database is not empty then excel does not quit until the program exits....

sweet, thanks.

So I have something like this:


For Each Entry In CheckedListBox1.CheckedItems
SheetName = Entry.ToString()
Form2.Show()

Next

but I don't want to continue the loop until Form2...

Again this didn't work. I don't think it is a problem with how I am closing it (because it works other places), but something else must be the problem, or maybe the workbook itself because the close...

I did monitor the task manager. As soon as I hit my button an excel.exe appears. I then hit another button which opens up the same spread sheet and does similar stuff. Another excel.exe pops up, but...

any other ideas?

I need to display 3 columns and a varying amount of rows (typically around 50) in a windows form, kinda like excel. What would be the best way of going about this? The data will likely be longer than...

That does not help either.

I am starting to think I am closing it right, but there is something else that is causing it to stay open because it closes fine in another function.

If I add:

WS.Close() above WB.Close() then I get a "MissingMemberException was unhanded"

Ok, I changed it to this:


' Close Excel
WB.Close()
Marshal.ReleaseComObject(WB)
excelapp.Quit()
'excelapp = Nothing
...

So I have a little gui that will read a given spreadsheet and list all the "valid" sheets. This happens when a user presses a button.

here is my code:


Private Sub...

Thanks guys, I just want to share the code with my friend, so I need to be able to copy it.

I just tried fooling around with a "windows forms" project, and I would like to see the code that creates the form. How would I go about looking at that?
I can only edit the code that would occur...

Ok, it turns out the problem is merged cells. B4 was just a sneaky little bugger and was merged in a fashion which can only be described as "ninja like".

I dunno if you guys know a work around for...

You code doesn't work, I get the same error.

Also I don't think the range is off because the cell B4 is clearly there and says "Employee", and that is where the error occurs. If I comment out the...

Maybe I should explain better. I pasted the code into word, then saved as a .htm file. This works fine, but it is super long and complex with tons of redundancy (to be expected from an auto generated...

@ techgnome the error comes on the if xxx cell = yyyy lines

thanks to pradeep, megalith

well that works great until I put it in <pre> tags. Ohh well.

Basically I am checking several cells in different spreadsheets to see if they contain the correct value. On one sheet I get an error saying: "NullReferenceException was unhandled"

I checked the...

darn, thanks anyways.

great, thanks guys.