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...
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.