Answer Questions

• Kunal Cheda 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

• i16978 Security of source code in vba

  Hello, I have written an add-in using VBA in excel that I want to sell.  It began as some programs to help me do things I do every day, but eventually grew enough and is useful enough that I think there will be some interest in it. However I am concerned about the security of my source code when distributing the add-in.  From searching on the internet I have found at least one program that promises to unlock any protection in VBA. Wh ...Show All

• KidneyGreentoad 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 Steve, Here's some info from our support team. As ...Show All

• Marco Filippi Subform Problem

  hi all i have a problem that i tried my best to solve it but i can 't till now the problem is i have a form with 2 sub forms in side it built using MS access 2000 currently we moved the database from MS access to MS Sql Server 2000 since then this form no longer works the form idea is that user select the customer id from combo box after update event will do requery for both subforms both sub forms based in a query th ...Show All

• Liam Flood VBA SDK mfc sample

  I have installed a VBA 6.4 sdk. My problem is in mfc example not in in visual basic example. Whe i try to use a method of the application host object in macro editor occur an error. Example: Public Sub prova() Dim app As New Application Dim str As String str = app.VBAVersion 'error Set app = Nothing End Sub when i execute the macro prova occur: ActiveX component can't create object or return reference to this object ( ...Show All

• Sivasubramaniyam V MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. ...Show All

• .NetProgrammer InputBox() in MS Word form textbox.

  I would like to insert a InputBox() prompt with the text being entered into protected Word form Textbox. I understand the InputBox() code and that the macro will be going into the ''Run Macro On Entry' dropdown box. Can someone point me in the right direction on how to do this. I am new to VBA. Hi, The support engineer needs some clarifaction on what you're trying to do. 1.       ...Show All

• eugen_safronov VBA XmlMap.loadXML problem - repeating call

  Hi all, I have the following XSD load to XML Source of excel: < xml version="1.0" > <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs=" http://www.w3.org/2001/XMLSchema "> <xs:element name="stock"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="quote"> <xs:co ...Show All

• Upul-uj Linking to an Oracle DB via MSAccess/VBA

  Hello. I have an Access application that uses VBA & need to link to two tables in an Oracle database. Would anyone know how to log into an Oracle DB (ie. myDB, myUserID,myPass) using VBA code For reference, I have Oracle 8i client installed with a TNSNAMES.ORA, SQLNET.ORA & have and OBDC connection set up. If you know of a good Oracle forum and can point me there, perhaps, that would be helpful. Thank you. RLN ...Show All

• desolate "unable to get the pivotfields property of the pivot table class"

  this macro works properly: With ActiveSheet.PivotTables("" & tblName & "").PivotFields(" Freq ") .Orientation = xlColumnField .Position = 1 End With Because the ColumnFields can change based on user selection (the selected value is on Worksheets("Hidden").Cells(1, "e") ), so i replace the PivotField value. The code become: With ActiveSheet.PivotTables("" &am ...Show All

• Jeremy Cantrell Need VBA Code Help

  Does anyone know the VBA code to allow formatting within a table inside a protected template in Word 2003. Specifically, being able to allow BOLD type would suffice. That's what seems clear to me, but Spotty has spent much time straightening us out lately, without contributing to any answers. To the original question, I need to ask a few questions: Do you know the password of the protected template Do yo ...Show All

• cougar68 How can I determine if a character is number?

  Hello all, I am new to VBA. I am writing some macros which manupulate strings. Do you know any built-in function of VBA (Excel) which checks if a string or a character is number or character Do you know any web url which contains useful VBA functions like the onw that I am asking Thank you in advance, Kostas Hi Kostas! try function application.worksheetfunction.isnumber(xxx) . that should do it. for ...Show All

• armanddp What about Sourcesafe now too?

  So Empower and Certified partners will not get Team System.  That also screws us up for Sourcesafe doesn't it I quote from the MSDN site ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/VSTmSysvsVSS.asp ):   The desktop-based nature of Visual SourceSafe 2005 lends itself well to scenarios where team members may need occasional remote access to files. However, it is not intended for day-to-day usage by a ...Show All

• BrBut how to add CheckBox?

  i want to add several CheckBox into Form. the numbers of checkBox is depends on the user input. i had already data on the ExcelSheet that represent one table of selected database. then the entire column name will be listed in userForm. i need to know how to add checkBox into the userForm (in uncertain range, depends on how many column in the table) and of course including the label beside it. Hi, O ...Show All

• SQLIsFun CRM 3.0 doesn’t save my settings

  Hi, I’m having another problem in CRM 3.0. When I change any setting in the CRM system, everytime that I clicked in the OK button it should save my new settings and that’s not happening. How can I solve this Thanks, Hi, Here's the latest from the engineer: I checked my IIS application pool account is Network Service. Is there any error information in the event viewer -brenda (ISV Buddy Team) Hi ...Show All