Fred Malone's Q&A profile

• Visual Basic Can't Make A New WorkBook In Excel From VB2005

  When I try to make a new workbook from excel it doesn't work and returning the following error: System.Runtime.InteropServices.COMException was unhandled   ErrorCode=-2147319784   Message="Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"   Source="Microsoft.Office.Interop.Excel"   StackTrace:        at Microsoft.Office.Interop.Excel.Workbooks.Add(Object Template)        at The_TestMaker.Form1.Command1_Click()        at The_TestMaker.Form1.Check_Click(Object sender, EventArgs e)  & ...Show All

• Visual Basic Using Assembly Binding Log Viewer

  I am a begginer. :) I have been reading about assemblies, versioning, side-by-side execution.... So I thought to use the fuslogvw.exe to see what is actually happening. Maybe I thought of using it as a self teaching tool. So I'm using 2005 fuslogvw.exe. But did my coding in vb.net 1.1. I hope this did not mess things up. But where I work we are just about to embark on using 2005 and have 1.1 code lying around. Anyway: I wanted to try to see a simple Private assembly binding. So I riped out some quick code: An Private assebly with this code: Dim myAssemblyName As System.Reflection.AssemblyName = _ [Assembly].GetEx ...Show All

• Windows Forms How to activate a jscript link with WebBrowser Control

  Hi! I'm trying to navigate in a website, but my problem is: The website doesn't have the "normal" links like <a href="link.html">linktext</a> but rather: <a href=void(vxLoadpage('link.shtml'));"> linktext </a> INFO: before the void there is javascript:  (I don't know why it's missing, when I send my post... So how do I navigate on this link with the webbrowser-control   Thx, Alex ...Show All

• Visual Basic ByVal variable passing

  didnt know where to post this, so i decided here was a suitable spot. anyways lets say i have an OCX that has variables defined.  the OCX, we will call "HMM" example given: Private Sub HMM_NAMEHERE(ByVal Latency As Long) now "Latency" is already declaired in the OCX as a changing variable that depends on the user that is connceted to a server.  so its not set. now im trying to pass that variable to a "Private Sub ListView_MouseMove".  the Latency variable in the HMM sub contains the true value, and i just want to pass that value to the ListView sub i have listed. how would i go about doing that here is an image, if it ...Show All

• Visual Studio Express Editions Need Help Iterating Through DataSet to Return Data...

  This is probably a real stupid question... I have a dataset that gets created programatically (no connected database, no TableAdapter, no datagrid - just a dataset used to store a ton of records temporarily in memory). I have the dataset bound to a couple listboxes to filter information and everything works exactly as I want it to. Now, I'm creating a report based off the information in the dataset. The stupid question is... If I want to query the dataset to get back a single item for the report, how do I do it To make it simple to understand, the dataset has 6 columns and probably 150 records. If I know that I want to retrieve ...Show All

• Visual Studio Express Editions two problems - one is driving me nuts

  Ok, I posted this question in another forum but I thought I'd try here, too. I have an sql database with one table, I set the primary key on the table to ArticlesID. It is configured as the primary key. However, when I use a GridView control and try to add the sql to it, the Advanced SQL Generations are greyed out. I get the same result with a DetailsView thing. Any ideas as to what I'm doing wrong Do I need to change something in the web.config or the code or what Also, how do I import excel data into this table Tony, I recommended the post because it relates why clear topic names benefit both you ...Show All

• SQL Server DtsConnection -- Consuming DTS DataReader In Code w/ Parameters

  I am trying to pass a parameter into the DtsCommand object, but always get the error "a requested parameter does not exist in the package".  I have a variable defined at the top scope named EmailPromotion so I tried the following command.Parameters.Add(new DtsDataParameter("User::EmailPromotion", 1)); and command.Parameters.Add(new DtsDataParameter("EmailPromotion", 1)); no luck either way It seems for the variable to be configurable by DtsClient, it has to be in DtsClient namespace. Create a variable DtsClient::EmailPromotion, and use the short name "EmailPromotion" when constructing the parameter ob ...Show All

• Visual Studio 2008 (Pre-release) WCF vs WSE 3.0

  I enjoyed reading Aaron Skonnard article, especially the part where he answers the question: What features does WCF provide for developers that ASMX 2.0 and WSE 3.0 don't But... I didn't understand - Since WSE 3.0 runs on .NET 2.0, in what scenario (if any) should one use WSE 3.0 over WCF Is there any feature inside WSE 3.0 that is not inside WCF (emphasize on security) Thanks. If you stick with the ASMX 2.0 programming model when using WSE 3.0, you'll have a pretty smooth migration path. This means using the ASMX attributes and factoring service contracts into interfaces. Then use WSE 3.0 to enhance those servi ...Show All

• Visual C# How to get the display information from a website?

  How to get the display information from a website For example, when i click a button, the system will get the fixed deposit rate from a certain bank website. How can i get the value that display on the website Can anyone help to solve my problem Hi You wanna to access the information that resides on a diffrent web server. Try to search a web service if the Bank have, and acces the information to display on your page. Or Try to get the page through System.Net.WebClient ... and parse the page to extract your information and then display that. Or If you are stronger in Java Scripting or any web scr ...Show All

• Software Development for Windows Vista Calling CreateProcessAsUser() from service

  According to some MS documents (e.g. http://www.microsoft.com/whdc/system/vista/services.mspx), it should be possible to use CreateProcessAsUser() API in a Vista service to create a process in user session. I am trying to achive this, but the function returns error code 1307 (ERROR_INVALID_OWNER) = "This security ID may not be assigned as the owner of this object." Does it work for somebody Many thanks in advance. The same code works for us on Vista as on XP, etc. The service is running as the Local System. 1. use WTSGetActiveConsoleSessionId to get the ID of the current active Windows session ...Show All

• .NET Development App.config problem

  hi all, I've developed an application in which the connection string is provided in the app.config for dymanic changes to be made. but now the issue is the changes which i do for the sql connection string is not accepted as i thought. < connectionStrings > < add name = " DatabaseConnection " connectionString = " Server Name=netbiz/sqlexpress;Data Source=Net;Database=Airwaves;uid=sa; " /> </ connectionStrings > now i will change the string with another connection string but dats not happening i.e it doesn't read the changes even . Please help me out. i tried installing a ...Show All

• Windows Forms Screenpoint question

  hi all i hope that someone can help me with this thing: i have a form with on that a panel with on that my custom control if you hover over the custom control, a new form appears at the exact location of the control  so i have to know the screen coordinates of the customcontrol butif you do newform.location = customcontrol.location, its all wrong i&nbs ...Show All

• Microsoft ISV Community Center Forums won't recognize DisplayControl Property

  The below is from another forum, where I have posted my question - and from the answer I got I assume that I cannot do what I want to do in Acces 2003, does anyone have an alternative solution _____________________ I am trying to change the property DisplayControl for a field in a table, but keep getting " runtime error 3207 - property not known" when running the code . Can anyone identify where I go wrong I have no problems creating the table or identifying a field in the table, the error is only in the very last line where I try to change the property. Thanks Jenny my code: Bruger = UCase(Environ("USERNAME")) 'Cr ...Show All

• Visual Studio 2008 (Pre-release) X509SecurityTokenParameters Vs. X509SecurityToken

  Hi, What is the relationship between these classes I can't find anything significant in the doc, so I am probably looking in the wrong place. I'm trying to bring a sample up to date with the latest version and I've hit a block. There is a call to SamlTokenCreator.CreateSamlToken()  which now requires TokenParameter types instead of  Token types. I have been able to change the types throughout the sample. In the original sample, the X509SecurityToken was created from the X509Certificate, but I don't see how to get the equivalent information into the X509SecurityTokenParameters instance so that it gets passed along the ch ...Show All

• Visual Studio Tools for Office ActionsPane And The Disappearance Act (When Toggling Excel Spreadsheets)

  Greetings, I have a, hopefully fairly easy, question regarding the ActionsPane.  The problem occurs when I have my VSTO application running and I launch another Excel (non-VSTO) spreadsheet and subsequently switch back to my app.   The ActionsPane disappears despite my futile call to show it when my app is activated:         private void ThisWorkbook_ActivateEvent()         {             ActionsPane.Show();         } Any ideas Kind Regards, Dima Kher ...Show All