Answer Questions

• voy VBA Excel Module opening Access DB with Recordset

  Here is the code: Dim cConn As ADODB.Connection Dim rs As ADODB.Recordset Dim sSql As String sSql = "SELECT Table1.Field1,Table1.Field2, Table1.Field3 FROM Table1 WHERE Table1.Field4 = Yes" Set cConn = New ADODB.Connection Set rs = New ADODB.Recordset cConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\path\files\folder\database.mdb'" Set rs = New ADODB.Recordset rs.Open sSql, cConn I get the same error on ...Show All

• Fallen Ghost Empower program

  Is the Empower program still available I am unable to enroll. Thank you, Frank Hileman Hi Frank, Yes the program is still available. What error are you getting when you try to enroll -brenda (ISV Buddy Team) I just got the scoop... The systems are undergoing conversion in preparation for the launch of MSPP 2.0 on Monday 14 th . All the enrollment tools have been shut down, but will be up again on Monday. Sorry for any inconvenienc ...Show All

• SGray experiences with MS software testing?

  hi, just wondering has anyone done microsoft ISV software tests   i'm a one-person ISV and i'm interested to hear from others who have been through the testing process.  i've been on the ISV empower program for the last 18 months and i'll be taking my tests shortly.  i intend to apply under the "platform" tests, doing the windows client test, and web services + .net framework.  i read the instructions from the testi ...Show All

• Mathiarasi list object

  Sir I have a list object in excel. i want to make the alternate rows of the list object to display different background color pls let me know Per our support engineer: Thanks for using Microsoft ISV Community Forum, according to your problem, I think you can take the following steps to achieve what you want: 1. Select the whole list object. 2. From the menu, choose ...Show All

• Mrishi Extract code from .dot

  For some reason, (really not sure why, but it happens every now and then on my company's PC) my normal.dot file containing a few years' worth of customisations and home-grown macros was reset to the default a few days ago. My backup normal.dot has the toolbar customisations and lists the macros in the Tools>Macro>Macros window, but they do not run. ("Could not load Macro storage" error.) I can see snippets of the macros when I lo ...Show All

• francisk VBA source code

  Hi all. I need to do my final year project in Excel using VBA. The project is in such a way that i can generate curves using Excel. I have been searching for the samples source code for cosine, sine and FFT source code, but to no avail. Could anyne please advise me on this I am a newbie to VBA, so i'm rather lost now.. Thanks in advance. No problem. Thanks alot for your help:)) ...Show All

• Fred Herring partly remove the code from VBComponents

  I wanna use VBComponents.remove to remove part of the code from one function workbook_open(). Is that possible See waht you can get from Chip Pearson's site ...Show All

• smmoraco My new Buddy

     I met my new buddy a couple of days ago. Her name is Amy, and she is really nice. She sent me an email, and asked me what I needed help with. I replyed to Her email and told her, I needed help with office Excell. I explaned how I use office, and explained that a lot of other functions in office that I don't know how to use. One of them is templates. She sent me an email back and said she could help me learn some of ...Show All

• Bob DuPuy 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

• Aurora222 Extracting Symbols from Word

  I'm trying to extract characters from a Word document which includes some Symbols (such as alpha, beta etc) When these characters are encountered (using the document's Characters collection) they all report their text to be "(". Any ideas as to how I can get the correct character values Current code is simply: Dim doc As Document Dim char As Range Set doc = Application.ActiveDocument For Each char I ...Show All

• dahall Excel - squares appear when sending info from textbox to cell

  Hi there - Hope someone can help! I have a simple database in Excel, driven by VB. I have a textbox in a form that, when updating the record, enters the info from the textbox into a cell (ie, range("a1").value=frmdata.txtnotes.text. The textbox uses multiline, and when it updates the cell, squares appear where the enter key was pressed in the textbox. It is identical with the .value property. Does anybody know how to transfer the ...Show All

• Tweed about listview in vba excel

  hi... can anyone help me..... How to highlight an item in a listview using a textbox or how to search an item in a listview then automatically highlight the item if found Hello again, You'll want to loop over the items in the list until you find a match, once you find the match make it selected using the index of the loop. Private Sub CommandButton1_Click() Dim i As Integer For i = 0 To Me.ListBox1.ListCount ...Show All

• Calumm Unable to create .NET class in VBA

  I'm trying to use a .NET DLL from VBA, but i keep getting a error message in VBA: "Run-time error '-2147024894 (80070002)': "File or assambly name ClassLibrary1, or one of its dependincies, was not found." I'm running VS 2005 and I have selected "Register for COM interop" and "Make assembly COM visible" in the properties window for the project. The code is rather simple C#: namespace ClassLibrary1 { public interface IClass1 { bool getT ...Show All

• mr_dipity email from excel

  The code at the end allows me to send an email with outlook with some fields from an Excel spreadsheet. Note that in the body I copy a table in html format. Is there an easier way to include in the body a range of cells in table format Thanks, Antonio Sub send_email_confirm() Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) ' determines if sale or purchase Di ...Show All

• RPierce Vba commands used to connect to sql

  Thats a bit odd... try the Open statement instead. Here's an example: Dim I, FileName For I = 1 To 3 ' Loop 3 times. FileName = "TEST" & I ' Create file name. Open FileName For Output As #I ' Open file. Print #I, "This is a test." ' Write string to file. Next I Close ' Close all 3 open files. The important lines are Open, Print and Close. Look in the help file for the open statement as there are a few ...Show All