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. They also do not support Office being installed on a server because it is not designed to work on a server.
Here is a...
I have a windows form application written in VB.NET 2005 which opens Excel, imports a text file into a worksheet and e-mails it to the end-user.
Everything works fine when it is on my own system, but when I put the executable file on the server along with all the other files in the bin\release...
Thanks for your help. I couldn't get your solution to work, but your feedback is appreciated.
I found a solution at:
http://gotdotnet.com/Community/MessageBoard/Thread.aspx?id=363074&Page=1#363383
Thanks again.
Lost in the Vast Sea of .NET
I have the following code in Excel VBA that I'm trying to convert to VB.NET:
Workbooks.OpenText(Filename:= _
"C:\temp.txt", Origin:=437, StartRow:= _
1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, TAB:=False, Semicolon:=False, Comma:=True _
...
I tested this and tried to type once this code was executed and had no luck.
I put a breakpoint in to the program above the suggested logic to make sure it was being executed.
It is being executed and it is the last line of code other than an End If and a End Try that is being executed.
Any...
Usually I go back to the code and make sure every Sub has Try Catch logic. Usually you can find out where your application is failing and the program will report the error under your control.
In my catch I do the following:
Catch ex as Exception
dim strRefInfo as string
strRefInfo =...
I want the cursor to actually be in the cell as if the user was to start editing it.
DataGrid1.CurrentCell = New DataGridCell(0, 1) doesn't do this.
I want the client to click on the treeview entry and after I load the appropriate data from SQL into the datagrid, I want to put the cursor in...
With the datagrid I get the message "'Rows' is not a member of 'System.Windows.Forms.DataGrid'"
Thanks for the suggestion.
Lost in the Vast Sea of .NET
Visit my website at www.komputing.com
Here is the code I've used which works.
DataGrid.CurrentCell = New DataGridCell(0, 0)
SendKeys.Send("{TAB}")
SendKeys.Send("{TAB}")
SendKeys.Send("{TAB}")
SendKeys.Send("{HOME}")
Like you said, this just doesn't seem like the best way to get focus on a datagrid.
Does anyone have a better...
I have an application that has a treeview setup. Depending on the node selected on the treeview a datagrid is loaded with appropriate data from SQL.
At this point the treeview shows with the node highlighted and the datagrid is displayed with the data.
I want to have the cursor positioned in...
Thanks for the suggested link, but I'm not subscribed to experts-exchange so I can't see the solution. The article looks like it is more geared towards changing the color of the item selected.
I'm actually interested in having the drop down list show active employees in the list as bold and...
I have a program which reads a series of employee names and ID numbers into a dataset and then sets the datasource of a combobox to that dataset. Below is some of the logic:
.cbxEEName.DataSource = ds.Tables("EmpmastTbl")
.cbxEEName.ValueMember = dt.Columns("EmpID").ToString...
Microsoft has been working with us for a few days with a MSDN call. The information that has come out of their research is that service pack 6a along with framework 1.1 and the patch for 1.1 is not enough. The version of user32.dll (which contains the win32 ComboBox) is not up to date to...
Yes, we've actually double checked the framework service packs and they are the same as the XP machine. The NT image is 4.0 SP6a with framework 1.1 and all the patches.
Any other suggestions?
Lost in the Vast Sea of .NET
Visit my website at www.komputing.com
I have coded a combo box to auto complete based on a collection of names that I load. The combo box is working great in Windows XP, but when we run the same application in NT the events for the combo box don't seem to all work. Are there some events that do not work in NT but work on 2000 / XP...
Thanks for the sample!! It was a little more complex than what I really needed.
I found some good advise and samples that I used from gotdotnet.com. Here is the link:
http://www.gotdotnet.com/Community/MessageBoard/Thread.aspx?id=309355&Page=1#310071
All the samples everyone gave me and the...
I have a combobox populated with 1300+ names. I want to make it easier for my data entry clerk to enter the last name, and it pulls from the list.
I found the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;320107
This knowledgebase article lists some code that...
Well, I’ve posted my question on two message boards and received several suggestions. First of all Thanks for all your feedback and help!!
Below are the two approaches that I’ve received and I’ve tweaked them to get the result set I was looking for. Table one includes everyone on our...
I'm new to SQL and trying to understand what is most likely a simple question.
I'm trying to use UNION to pull together a result set of Name and Employee Number. Unfortunately there are duplicates in the two tables. The UNION syntax is supposed to weed out duplicates, but I have this situation...
This might be a simple question, but I can't seem to find an answer...
I have a tree view with several parent nodes and three child nodes under the last parent.
For all the parents I can change the individual forecolor using the following:
.Nodes(1).ForeColor = System.Drawing.Color.Black
How...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.