Microsoft ISV

Page 102




  • Topics
    Replies
    Last post
  • WSS 3.0 "This stock feature has been retired."
    by bafadam
    14 Replies
    Last post by cis365
      • What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently. Anyone have any clue with this could possibly be referencing
  • On Error not trapping internet connection problem
    by Julian Ladbury
    1 Replies
    Last post by Julian Ladbury
      • I want to add a toolbar button to a Word 2003 VBA project to access a web page. The code below runs fine when my internet connection is open. On Error GoTo notFound ThisDocument.FollowHyperlink _ Address:="http://www.chronolator.co.uk/Tutorials/index.htm", _ NewWindow:=True, AddHistory:=True Exit Function ' problem time notFound: Call showMessage(c8Msg5310) However, if I
  • Excel: Can a UDF tell what cell it was invoked from?
    by My_Head_Hurts
    3 Replies
    Last post by My_Head_Hurts
      • I have a need to check other values in the same row, and/or same column as the cell being processed. My User Defined Function therefore needs to know what cell is invoking it. It is certainly not ActiveCell. My function works if I pass it a string (e.g. "H12") to tell the UDF what cell it is, but that's too messy to populate through hundreds of cells. Does anyone know how this can be don
  • running a sub from another sub
    by DJRave
    1 Replies
    Last post by ADG
      • Hey there, I've written 3 subs to log data during import. I want to start all 3 subs by using another script but I can't get it to work. I've tried using the Run method but everytime I try to run the script it comes up with a Run-time error (7952): You made an illegal function call. Does anybody have a solution to my problem Thanks Private Sub Runmultiplesubs()
  • Problem with PasteSpecial
    by SanK
    0 Replies
    Last post by SanK
      • Hello Everybody, I am facing one strange problem in one of my VBA applications. The application uses the normal "Paste" to paste one copied signature file. I would like to use the "PasteSpecial" feature instead, so that only the text of the signature file gets inserted and not its background shade. My code snippet: Code Snippet With Selection .Range.PasteSpec
  • Passing Function As Argument
    by Douglas Penna
    4 Replies
    Last post by Douglas Penna
      • I dunno if it's possible, but I'd like to pass a function name as an argument to a function. The idea is to use the result of the function to do some calculations, no matter what the function is. It would be like this: Function Find_Zeros( Function_Name As Function, Value_X As Double, etc) Thanks in advance.
  • Highlight Row depending on cell - Excel VBA -
    by Reuben B
    3 Replies
    Last post by kent kindberg
      • Hi All I need some help with this code ...... I have a sheet full of data, Col A , B & C full of data and col D is 1 or 0 ... I need to highlight all rows in red whenever there is a 0 in Col. D when i press a button (that i know how to create !) I don't want to use conditional format as the sheet slows down drastically using this method !! Thanks
  • Help
    by Munich
    1 Replies
    Last post by MyLady
      • Hoe to write a code for a task, such that if i click at particular cell in excel then after clicking it opens a new sheet
  • Run Time Error 9 when Calling a Userform
    by Joe Dawson
    6 Replies
    Last post by Joe Dawson
      • Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to r
  • Visible Property For Pivottable
    by sonofwind
    0 Replies
    Last post by sonofwind
      • Hi all, The " Pivot Table" is generated from an OLAP cube. One of the "Pivot Table" fields is "Customers," and its subfield hierarchy is as follows: Category 1, Category 2 and Category 3. In addition, when I type an equal sign and click a cell in the "Pivot Table," I can look at the following formula : =GETPIVOTDATA("[Measures].[Sales]",'Pivo
  • Access Data Project, form bound to Sproc, need to update, etc
    by Computermike
    2 Replies
    Last post by JKnow
      • I have an Access Data Project. SQL Server backend, access forms. I have a form bound to a stored procedure. The storede procedure is based on two tables. The form needs to update and delete records in one of the tables. I set the Unique Table property to the table I need updated. When I try to update a record I get the error'This recordset is not updateable" It worked fine when the
  • Need info on Hits vs Cad ID's
    by DESSCI
    2 Replies
    Last post by Jason Hardester - MSFT
      • Can I get information on why the total hits on an event would say 2 and when clicking the CABS link to download, it shows more than two CABs to download What is the difference between the total hits for the event and amount of CAB ID's avaialble to download What does each CAB ID represent Just need info on how this whole WER reports work. New at the whole process. Thanks,
  • Answer Error Report processing delay
    by brokenn
    2 Replies
    Last post by brokenn
      • Hi, I've signed up for WER and done some of the important steps by now: 1. Obtained Verisign ID 2. Setup a proxy caching Symbol Store to hold our symbols and also cache the msdl ones. 3. Source indexing on all my binaries to automatically extract the correct source code from svn for the relevant crash dumps. 4. Mapped my products using the Product Feedback mapping tool.
  • subscript out of range
    by Derek at Potters Clay
    5 Replies
    Last post by Andy Pope
      • I am getting an error when running the script Do While (Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "dsl") Or Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "hsi")) I am uncertain why this is coming up. i is currently set to 1, so it should be starting to search in cell a1.
  • My vista doesnt contain wer.dll and werapi.h
    by Zzeeshan
    2 Replies
    Last post by KINSHU [MSFT]
      • Are wer api's are only in specific windows vista versions I have Windows Vista enterprise edition installed on my computer. How can i get this dll now
  • How can I use a variable in formulaR1C1?
    by lyp_sj
    3 Replies
    Last post by Andy Pope
      • Hello, I'm trying to use .FormulaR1C1 as below. "K" is a variable. How can I write the code if I want to build "K" into the formula Thanks so mcuh! cells(j, lastcolumnCAGR + 2).FormulaR1C1 = "=RC[-1]^(1/k)-1" B.regards/Yaping
  • Is there a today() function in VBA?
    by Derek at Potters Clay
    3 Replies
    Last post by Shlizar Axis
      • I've been trying to get the current date a few ways in VBA. I tried using the today() function in a spreadsheet and getting the data from that cell and also calling it explicitly in a vba script and have had no success. any help will be appreciated.
  • excel 2003 macros dont work in 2007
    by pmgd
    1 Replies
    Last post by Cringing Dragon
      • I have a spreadsheet created in excel 2003 which makes use of various macros and userforms. I just tried running it under 2007 and got the following two problems: 1. Despite NOT having an option explicit statement and specifically UNchecking the relevant excel options box it compains about all of my undeclared variables. Why Hint: It doesnt say 'undeclared variable' it makes reference t
  • Finding out the Modules (VBA) Access password...
    by Lant
    0 Replies
    Last post by Lant
      • Hi there, I'm working in project which has a system in MS Access. And we have to provide some enhancements on that, but the coding area (called Modules) into this MS Access file is protected by a password... and anyone knows this password. I have already found few good programs which finds out the password from .mdw file, but they don't work fine with the VBA (Modules) password. So... I'm here...
  • Automation error 80004005 when creating a CDO session Object
    by Lenny2
    0 Replies
    Last post by Lenny2
      • Hi, I've got an MS Access app that uses CDO to mail out the results of various reports that it produces. The application works fine running from my desktop, but when I try to run it through a web-based Citrix session I get a error (80004005 Automation Error, Unspecified Error) when I try to instanciate the CDO Session object. I have been unable to determine the cause of it. I thought that pe
  • 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 + Bloomberg
    by macduss
    5 Replies
    Last post by Joe Dawson
      • Hi All, i am building a macro in which i retrieve info from Bloomberg. i have to compare these data with other values. Before comparing i would like to copy and paste special value the data retrieved from bloomberg. How can i do to perform the copy paste special value only once all fields are updated (i.e. how the macro can know that the fields are ok and it is time to
  • A simple list of words from a word document
    by jnxd666
    2 Replies
    Last post by jnxd666
      • I want to create a list of words from a word document. For example a document containing a sentence " The quick brown fox " the list of words should be - The quick Brown fox I initially thought I would use the Activedocument.words.count to find the total number of words in the document. Then use a do while loop to iterate through each word and generate a list. The solution was easy
  • Collection Item: Parent / NextItem
    by Paul_NL
    1 Replies
    Last post by Andy Pope
      • Hi, I am struggling with classes. This is what I want to do, in VBA (test it in Excel please): I want to add a property/function to my class, named NextItem and PreviousItem. These return the next and previous items in the collection. I have several separate collections where I keep my items in. So if I want to determine the next and previous item, I need to figure out in which collection the item
  • Excel Time Help
    by MoPatel
    6 Replies
    Last post by MoPatel
      • Hi all, This is my first time posting here , hope i will be able to find the answer i am looking for. I'm very new to vba so please bear with me. Here goes, this is the problem i'm having at the moment with my formulas and vba. I am currently desinging a roster for my workplace and the problem i am having is to work out the night shifts. these night shift start at 23:00:00 and end at 06:0