Answer Questions

• Tech G-nome vba in excel

  You can change the 30 in the code (2 as I posted it) to a variable of type long, the below line sets variable nEndRowIndex to the last non blank row in column A. It effectively does the same as pressing End then Down in A2. nEndRowIndex = .Range("A2").End(-4121).Row In my code the filename is changed using letter corresponding to the line number, change this to strFileName = "C:\Files\" & ColumnLetter(lngRow) & ...Show All

• Frank Mestdagh Application Error

  Hi experts, We have an application written in VBA. The application is failing with the following log entry in the event log. Faulting application: appname.exe Faulting Module: VBE6 Version: 6.4.99.72 Fault Address 0x000dc6f2 Event ID: 1000 The application is running on Windows XP SP2 with Office 2003 SP2. Help would be much appreciated. Thanks Steve Hi, The following is the code that was causing the a ...Show All

• tballx Microsoft Access Runtime/Developer (XP) - compatibility issue with XP SP2?

  I have software that I packaged with Microsoft XP Developer SP1 edition which  does not  function on Windows XP SP2 systems but ran fine on all prior operating systems. The wording I am getting when I launch the installer is: "Visual Basic 6.0 Setup Toolkit" "The Application you are installing requires updated system components. To continue, install the Office System Pack. For assistance, contact your applicaton provider" Is there ...Show All

• Shahedul Huq Khandkar Metadata driven Applicaiton Composition Framework

  Hi, I am looking for an ISV application for .NET that helps end users define business entities, establish relationships and create business workflows. The above requirements mandates metadata driven approach and any informaton ISVs with this kind of solution will be helpful. Regards, Hanu Hello Hanu, This site might be really helpful in finding a solution for your needs: http://www.microsoft.com/dynamics/solution_finder.mspx ...Show All

• Tony Ball Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s) Hello, so engineers stated that there would not be any way to disable custom commandbar controls when excel enters edit mode, right Though excel itself is able to do that, and actually does that. I got such a problem when i'm in edit mode. User clicks custom toolbar button(created by COM addin). The Click event handler calls ActiveWor ...Show All

• dedwaazhaaz Executing update field only on a selected Word page

  Hi all I have created a set document templates (.dot) that prompt users to enter certain details when it loads up using the ASK field, inserts other information such as the date and contents from another document and then unlinks the information once all the fields have been updated. Code shown below: Sub AutoNew() Dim pRange As Word.Range Dim oField As Field 'ActiveDocument.Repaginate For Each pRange In ActiveDocument.StoryRanges ...Show All

• Chris White Using VBA to send an MSN instant message

  Hi I have written some VBA in Access 2003 to bring up an MSN instant message window and send a message to that contact. The only problem is, I seem to be able to do everything except actually send the message! I think this feature may have been removed from the API. Anyway, here's the code: - Private Sub SendIM()      Dim header As String Dim objmsgr As MessengerAPI.Messenger Dim contact As MessengerAPI.IMessengerContac ...Show All

• RSidhu Mail subject

    Hi When I archive an e-mail the subject changes in Archived <-- subject is it possible to cut the Archived <-- piece away using a macro ...Show All

• Kishor Kurapati oledb connaction display xml

  When I change my connection string from ADO to oledb my xml display is broken the error I go is wrong data type. I use ASP classic. Would you please help here. Thanks in advance! can you post the two connection strings, the original and what you changed it to. Could you post your query and some of the code you use to call the query. ...Show All

• jlandry Questions on ISV's and regarding end users

  1) Are there different types of ISV programs If so, what are the differences between the programs   2) How does the Royalty program differ from other ISV programs 3) Does each program offer different benefits to the end customer   4) How does the Royalty program differ from other ISV programs to the end customer     5) Does Microsoft have a brochure or a list of the benefits for the end c ...Show All

• dutchtrader14 vba in excel

  Hi John Code would appear like below Public Sub CopyStuff() Dim lngRow As Long Dim strFileName As String Dim strRange, StrRow As String Dim nEndRowIndex As Long On Error Resume Next MkDir ("C:\Files") On Error GoTo 0 nEndRowIndex = Range("A2").End(-4121).Row For lngRow = 1 To nEndRowIndex StrRow = Trim$(Str$(lngRow)) strRange = "A" & StrRow & ":B" & StrRow Range(strRange).Selec ...Show All

• Sirisuda AutoResize Merged Cells

  AutoResize Merged Cells I used some code I had found, and it works perfect ... except, it messes up my "tabbing order" code. Anybody got any code which will: AutoFit Merged Cells AND keep my tab order from messing up ...Show All

• Anupriti What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• Don Farrey M How to create a DLL in VB.net for MS Access 2003

  Hi, I've been searching high and low on the net but I cannot find out how to create a dll in VB.Net that I can call from VBA in MS Access 2003. I know that I need to add a com interop to allow vba to reference it but I've not found out how to do that. Does anyone know http://dsmyth.blogspot.com/2006/03/calling-managed-code-from-vba-using.html This will tell you how to do it. Moving from VSTO Forum ...Show All

• TobiasWenig Import CSV Files into SQL Server 2000 Table from VB Net

  Hi Guys. I'm doing a web application to import data into a SQL Server Table from VB Net 2002. Anybody do know how do it . Thanks. WERM Hi, You might want to post this question to one of the Visual Basic forums ( http://forums.microsoft.com/MSDN/default.aspx ForumGroupID=10&SiteID=1 ). -brenda (ISV Buddy Team) You want to use ADO.NET objects. You'll need to import the objects in the System.Data.SqlClient name ...Show All