Microsoft ISV

Page 24




  • Topics
    Replies
    Last post
  • VBA 6.3 String
    by roman rus
    1 Replies
    Last post by Andy Pope
      • Hi, My question is how do i access individual characters of a string in VBA 6.3 is there something like myString[0] thx
  • IsError function from VBA6.3 to v6.0
    by SuzukiBandit
    8 Replies
    Last post by SuzukiBandit
      • Hi All, I'm having problems with a small VBA script that I wrote in v6.3 but need to implement in 6.0. Excel 2002 -> 2000. The following code works fine in the later version: For i = 2 To LastRow ' select the next row based on loop vString = "A" & i If IsError(Application.VLookup(Range(vString).Value, vRange, 31, False)) Then Y = "NEW" Else
  • Calling a function from a DLL
    by Douglas Penna
    6 Replies
    Last post by Mezhick
      • Hello there, I wrote a DLL in C++, and I'm trying to use it in Excel. When calling the the function, I used the code, at the begginning of the module: Option Explicit Public Declare Function preco _ Lib "OpcAmericanaDll.dll" _ (ByVal Spot As Double, ByVal strike As Double, ByVal Ks_fixados As Double, ByVal t_dos_strikes As Double, ByVal t_final As Double, ByVal t_inicial As
  • VBA macro to replace
    by sree
    5 Replies
    Last post by sree
      • Hi I have two worksheets in a workbook, In sheet 1, i have columns Sector level 2 and 3, for some enterprises In Sheet 2, i have columns sector level 1, for the same enterprises, I wish to create a macro, which would look for corresponding enterprises which is the only common element in both sheets and then it should replace corresponding sector level 2 with sector level 1
  • Locking clickable labels
    by une
    1 Replies
    Last post by Andy Pope
      • Can you lock a label like you can a toggleButton I have some code as follows; If toggleButton1.value = True Then togglebutton2.locked = True Else togglebutton2.locked = False End If But I also want to temporarily lock some clickable labels, but there is no ".locked" function for labels. How do I stop a label's click action from being allowable under certain circumstances Thanks.
  • Error 1004 with Excel 2007 (on VISTA) on Publish method
    by LaurentB
    0 Replies
    Last post by LaurentB
      • Hi, I'm trying to publish a Range in an html file from excel 2007 (OS is VISTA) and I receive an error 1004 on the Publish method. Here is the code I'm using : Code Block ' temp file name Dim TempFile As String TempFile = Environ$("temp") & "\" & Format(Now, "dd-mm-yy h-mm-ss") & ".htm" ' delete any PublishObjects left
  • how to get the VALUE of an OUTLINENUMBER (word / macro in VB)
    by XiXCal
    1 Replies
    Last post by Riquel Dong ¨C MSFT
      • Hi, I am currently working on a VB macro which has to get references in Word documents in order to make a traceability matrix. My problem comes from a document, in which the references are Outlinenumbers in a column containing this outlinenumber list. I have to get the value of the cells of this column, but these outlinenumbers (auto-incremented numbers) are neither strings nor numbers..
  • HELP FIX THE CODE..........
    by keilah
    1 Replies
    Last post by Peter Mo.
      • I have somehow managed to put some code together to complete a task that i have found some difficulty with. Match and delete a row from table. Need some help fixing the code.......... ArrNames = Array("creation1", "creation2", "creation3", "Creation4", "creation5", "creation6", "creation7", "creation8", &
  • Problems with VB solver code
    by Stacy B
    1 Replies
    Last post by Jon Peltier
      • I am writing visual basic code behind an excel spreasheet and am having difficulty making it work. It involves using the solver function. The code is listed below: Sub signif_control_pop() Dim cntlpc Dim pop 'Clear any previous solver settings. SOLVERReset 'Prompt user for population size. pop = Application.InputBox(Prompt:="Population Total:", Type:=1) Range(&qu
  • New to Visual Basic
    by darnold
    5 Replies
    Last post by darnold
      • Im trying to do the following: I created some command buttons that has the number 1, 2, 3, 4 on it, like a keypad or a calculator. When I press the button I want it to give a value (variable) of 1, 2, 3, 4, etc. At the same time if I press 1 and 4 on the keypad, Id like it to indicate 14 or 9 and 8 I would get 98. What I'm trying to do is: Button 1 = 10 * (number pad syst
  • Information required : WOW64
    by VikasAgr
    2 Replies
    Last post by Greg Taylor
      • What is WOW64 How it helps to run 32-bit applications on 64-bit processor Where could I get it
  • MSDN Installation
    by uxair
    0 Replies
    Last post by uxair
      • I've MSDN installed on my system, since i've installed it through MSDN setup (not by VS setup) Visual Studio does not recognize its presence(Ctrl+F1 doesn't work.), Is there a way I could tell visual studio about the presence of MSDN. By the way this behaviour is common in both VS 2003 as well as VS2005
  • error message when closing ie7
    by syjon
    3 Replies
    Last post by metalmarvin
      • The computer administrator profile is not having this problem only the other users on my home computer. Upon closing the browser this pops up: iexplore.exe Application error The exception unknown software exception (0x0eedfade) occured in the application at location 0x7c812a5b We have ie7. Can someone help
  • add group to printer ACL
    by fkbr
    0 Replies
    Last post by fkbr
      • Hello, I have a print server with 200 shared printers. I need to add a group to each printer ACL with an appropriate rights (same for all printers). Is anyway to script it Thank you Ali
  • VBA XML and encoding
    by Vsfa
    0 Replies
    Last post by Vsfa
      • Hello, Here is my issue. In an excel sheet, I fill in several cells which contain text. This text can be either in english / french / spanish / italien / german, which means I can have characters like "e" or "e" etc... In a vba macro I'm trying to put all these data into an XML, this XML is then processed later on by an ASP.net app I have created (using an xm
  • Increase prompt in message box
    by une
    3 Replies
    Last post by Jon Peltier
      • I have a userform that contains a command button that when clicked displays a message box. This message box contains help notes for the user. However I can't quite fit all the text in. When displayed, the message box cuts off the last couple of sentences. I think this is because my help text is the prompt in the message box and it is too long (> 1024 characters). How can I get a few extra sente
  • Configuration Failed
    by NaveenPN
    2 Replies
    Last post by Mica
      • Configuration Failed One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure: Failed to initialize SharePoint Products and Technologies upgrade. An exception of type System.Collections.Generic.KeyNotFoundException was thrown.Addi
  • Communicator Mobile 2005 and TLS (Using port 4443 possible?) More options
    by markm75c
    1 Replies
    Last post by markm75c
      • Confused on something with CM and CWA: We have web access enabled/installed, it uses MTLS and certificates on port 4443 to access the site... I'm assuming when using Communicator Mobile on Windows Mobile 2005, I specify TLS to connect remotely to the server (no vpn).. Is there a way to specify port 4443 or is the TLS port 443 even with Web Access installed on port 4443 (IE: these are diff
  • VBA in Excel - organizing charts as objects in a sheet
    by jk2880
    1 Replies
    Last post by bi-lya
      • I am using a macro to create multiple charts from data on a separate sheet in the Excel file. However, the program places each new chart on top of the previous one in the sheet I select. I would like to place these charts apart on the sheet so that they are viewable. 1) Is there an command to order the charts down and across the sheet 2) Alternatively, can I select and move each sheet without us
  • AutoExec will not execute properly
    by Jürgen1234
    4 Replies
    Last post by Jurgen1234
      • Hello there I have an .dot file in the Word 2003 start-folder. When opening word, the file is read. The autoexec-macro should make a new entry with a number of commands and subcommands in the standard menubar. On about 300 PC's this works fine. On a few ones only part of the commands appear. All PC's run W2000 and Office 2003. Any idea regards Jurgen
  • Determine if and where the .NET Framework is installed using VBA
    by TU71
    6 Replies
    Last post by vtortola
      • I have an Excel spreadsheet that needs to determine if the .NET Framework is installed as well as the path to that install. How can this be acomplished in VBA code
  • Pivot Table Macro
    by GB Allan
    3 Replies
    Last post by GB Allan
      • Hi, I have set up a small macro to create a pivot table from a spreadsheet: Sub CreatePivot() ' ' CreatePivot Macro ' Macro recorded 3/14/2007 by Gary ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _ "Data!R1C1:R656C90").CreatePivotTable TableDestination:="", TableName:= _ "PivotTable1", DefaultVersion:=xlPivotTableVersion10
  • how can I count # of columns between two specific columns?
    by lyp_sj
    3 Replies
    Last post by lyp_sj
      • Hello, How can I count # of columns between two specific columns such like, how many columns between column A and column D Thanks so much! B.regards/Yaping
  • Why the do while loop does not work?
    by lyp_sj
    6 Replies
    Last post by lyp_sj
      • Hello, Below is my code, the lastrowGSVGrowthRate is 101, I expected result is to copy all the "AFFILIATE" items. While with my code, it only copied the first "AFFILIATE" item. I do not know where I did wrong. Thanks so much! B.regards/Yaping raffiliate = 1 rowaffiliate = 1 Do While raffiliate <= lastrowGSVGrowthRate If cells(raffiliate, 1
  • VBA and automated word generation
    by Bindhia
    2 Replies
    Last post by Bruno Yu - MSFT
      • Hi there, I am currently working on a VBA application. There is an automated word generation available in the appliacation that serves the reporting process. If there is any Flash add-in being installed in the user's machine (can be viewed through Tools->Templates and Add-ins in MS Word) ,the applicaiton crashes down when the user tries to generate the report because the flash add-in r