|
I called Microsoft using one of our MSDN incidents. Basically Office is designed for interactive usage and they do not recommend automating it with an unattended application. Like you said, you need to have Excel installed, but they do not support Office being installed on a server because it is not designed to work on a server and cause unexpected results.
Here is a link showing their “Not supported” statement and their “at your own risk” workarounds:
http://support.microsoft.com/?id=257757
I used the workaround towards the end of the article related to “How to configure Office applications to run under the interactive user account” and I put the application on a client PC using scheduled tasks instead of on a server.
Thanks for you help Dave!!
Lost in the vast sea of .NET
|
|
|
|
|
Hallo, I'd like to to get help on the following subject:
I use a BackgroundWorker control in a form and i'd like to show intermediate results from the BackgroundWorker in a control on the same form (before it has finished its work). I tried accessing the control by reference but an exception occurred stating that the control's property (Text) cannot be changed from another thread.
thank you.
|
|
|
|
|
Make an event to which your form that will display the progress will listen.
And then fire that event from the working thread whenever you wan't to update the status (you can pass the status information in the event arguments)
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
It's correct. You can't access UI controls from any other thread other than the one that created the control (known as the UI thread).
The BackgroundWorker exposes a ProgressChanged event that you can use to update your controls. Of course, your worker code has to be able to send some kind of usuable progress!
' Setup the BackgroundWorker object and start the work somewhere...
BackgroundWorker1.WorkerReportsProgress = True
BackgroundWorker1.WorkerSupportsCancellation = True
BackgroundWorker1.RunWorkerAsync()
Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, ByVal e As DoWorkEventArgs) Handles BackgroundWorker1.DoWork()
' Get a reference to the BGW that called this
Dim bgw As BackgroundWorker = CType(sender, BackgroundWorker)
' Do some long running task about a million times...
For I As Integer = 1 to 1000000
' Check to see if we've been cancelled
If bgw.CancellationPending Then
e.Cancel = True
Exit For
End If
' Do something useful here...
bgw.ReportProgress(i / 10000) ' Reduce i to the range of 0 to 100.
Next
e.Result = whatever ' Return whatever the result of this work is supposed to be.
End Sub
Private Sub BackgroundWorker1_ProcessChanged(ByVal sender As Object, ByVal e As ProgressChangedEvent) Handles BackgroundWorker1.ProgressChanged
' Do something usefull with the progress
ProgressBar1.Value = e.ProgressPercentage
End Sub
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
thank you for your answer, it was really helpful.
|
|
|
|
|
Hello. I'm writing a program to store passwords. I would like to allow the user the option of sending the username and passwords to the website by just clicking a button. Can anyone help me? Thanks in advance.
|
|
|
|
|
In most cases, you can't do that. You'll have to load the login page, find (NOT EASY!), then fill in the fields with the data, then submit the login page back to the server. You can't just send a username and password to the web server and expect it to work. It just doesn't work that way.
On top of that, this is already built into Internet Explorer...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 14:52 Monday 6th March, 2006
|
|
|
|
|
Okay I realize this is probably quite an easy questions however it has me stumped right now. I am trying to use a rich text box to display output data in three columns. The columns are lined up using tabs and everything looks great on the screen. The problem is when I go to print the data all of my tabs are lost! I have used vbtab and chr(9) coding. I don't want to hard code spaces since that way is very unpredicable and can cause problems if the font every gets changed.
Can someone please explain what the hell I am doing wrong?
Thanks
|
|
|
|
|
That depends on how you're printing the contents of the box... An explaination of how you're doing this might help.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am using the PrintDialog tool right out of the box from Visual Studio same as I am doing for OpenDialog, PrintPreviewDialog, etc.
Maybe a better explanation is that I am using a for next loop to write two arrays of data to the rich text box. After each element I insert a number of tabs so that I end up with columns of data (there are three columns in total). Like I said in my original message the form looks fine when it is run. When I go to print or use print preview all of the data is squished together. For some unknown reason (at least to me) my tabs have been removed.
|
|
|
|
|
Your tabs are getting reduced down to the size of a single space character, since in GDI+, they don't have a width, and there is no such thing as a tab stop. Printing with the PrintDialog, and the other objects you're using, isn't WYSIWYG. If you really need to do this in a RichTextBox, you'll have to modify the RTB by creating your own, supplying all the formatting and printing code.
Fortunately for you, someone ahs already done this, here[^]. I hope it works for you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks Dave. I'll read through the article you pointed me to and see if this helps.
|
|
|
|
|
could someone tell me how i could link forms together such as if i click a botton on one form the another form would open up.
-- modified at 10:34 Monday 6th March, 2006
|
|
|
|
|
You would have a click event handler for the button, and that code would create an instance of the second form and call ShowModal on it.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
how do i get the event handler
|
|
|
|
|
Well, I would respond with a bit of general advice. More so than ever, there are people downloading VB Express, looking at the IDE and deciding they can write a windows program. Most of these people will fail. If you want to learn to code, you need to learn the language before you play with it's frameworks, write console apps before windows apps. It seems to me that it's likely you're at this level, and should take a step back.
The easiest way to create an event handler for a button is to double click on it in the design view.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Stop, backup, and learn the basics[^] before you beat us to death with easy questions.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I've been trying to implement the autocomplete functionality on Pocket PC application but I can't get arround the framework restriction.
Can anyone help?
Thanks.
|
|
|
|
|
What Framework restriction???
Also, your question would be better handled in the Mobile Development[^] forum.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dave Kreskowiak wrote: What Framework restriction???
I can't use the Findstring methods or the selectionstart and selection lenght properties in the Compact Framework
|
|
|
|
|
Hi all
In my app i am creating a thread and cheking the status.
When i tried to check the status of the thread after the execution of the method that it is reffering, It is giving that thread state is Stopped.
what doest it mean.
Is that the thread object is still alive.
1) If so how to destroy the thread object once its state is "Stopped".
2) The other issue is how to restart a thread which is in stopped state.
|
|
|
|
|
varmag wrote: 1) If so how to destroy the thread object once its state is "Stopped".
You don't have to do anything. The GC will collect the Thread object once it falls out of scope.
varmag wrote: 2) The other issue is how to restart a thread which is in stopped state.
Not possible. Once a thread is stopped, there's no restarting it. You have to create a new thread is you want it to run again.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I have a DataGridView (using VB.NET 2005) which is filled with data from a DataSet. When I doubleclick on a row of the DataGridView (FullRowSelect is enabled) I want to copy the values of the row into Textboxes on the same form.
Can someone please help me on this one? Urgent ...
Thanks!!
G72360
|
|
|
|
|
textbox1.text=datarow1.selecteditem.text or something like that
SelectedItem.text
SelectedValue.tostring
Need a counter two...
Dim i as Integer
For i=0 to datagrid1.selecteditems
txt'put them in textboxes
Next
i dont know...
FeRtoll Software.net
--------------------
I fertoll@net.hr I
--------------------
|
|
|
|
|
datagridview has no selectedItem or selectedValue ...
|
|
|
|