Microsoft ISV

Page 141




  • Topics
    Replies
    Last post
  • Can't remember the purpose of these lines of code in my project?
    by Scott Boyd
    2 Replies
    Last post by Scott Boyd
      • Hi, I just can't remember what the following lines of code are here for! Please put me out of my misery... Code Snippet Private glb_count As Integer Public Property Get GlobalCount() As Variant GlobalCount = glb_count End Property Public Property Let GlobalCount(ByVal vNewValue As Variant) glb_count = vNewValue End Property
  • NEED URGENT HELP
    by keilah
    0 Replies
    Last post by keilah
      • Hi People I am having trouble with a excel spreadsheet. I am pulling in live data from a MS Access database, that has two data sets of portfolio IDs. In Col A the Portfolio Id are shown as individual (separated) in Col (say) G, the Same IDs are conbined (as shown below) for example: ColA ColG Barclays1 Barclays 1+2 (shown as) Bar
  • Converting a string to an Array
    by DeathSurfer
    2 Replies
    Last post by DeathSurfer
      • Duuuudes: Is there an easy way in vba to convert a string to an array of integers. For example: I have this particular array of numbers in the element <column_data_types> in a xml file: <column_data_types> 1, 1, 1, 1, 1, 1, 1, 1, 1, 5, 5, 5, 1, 1, 1 </column_data_types> I have a function that will grab the array of numbers but the function returns a string. ("1,
  • where do I start??
    by Eyalwu
    2 Replies
    Last post by Eyalwu
      • Good evening. Here is the thing. I am using a Mass spectrometer, which exports data into excel worksheet. What I want to do now, is to process this data while it being exported into the worksheet, i.e: taking avrage value every (let's say) 5 values that being exported, or every once in a time interval, and save it somewhere else (a different worksheet for example). Now, since I don't know
  • Learning VBA.... where to begin??
    by gregw74
    4 Replies
    Last post by NWAprog
      • I have some very limited knowledge of VB, but I would like to learn VBA from the ground up, specifically with FrontPage. I just don't know where a good starting point is Do I learn VB and then build upon that by learning VBA, or dig right into VBA Do I learn VB.NET or VB in it's previous form Is VBA much different in Office 2007 than previously Any feedback would be greatly appreciated. Thank yo
  • Live Communications Server 2005 SP1 Status Unknown
    by Bennydojo
    1 Replies
    Last post by Heiken
      • Hello, I've been running LCS 2005 SP1 Federation/PIC for over a year now. Recently several users who Communicate with MSN contacts frequently are getting "Status Unknown" for any user@hotmail.com MSN user. This is isolated to about 3 persons, the only commonality is that their username is 9 characters or longer. (Ex. 123456789@domain.com ) I saw another post from a while ba
  • How to Get Position of Scribble line's Points?
    by Sstar
    4 Replies
    Last post by Sstar
      • I have scribble line object in my Ms Word document. Shape.Type = msoFreeform Now I want to get position of the controls points and change it slightly. How can I get the controls points' position in the first place. I noticed that Shape.ShapeNodes.SetPosition ( index, x, y) helped me to set position of each node. However, no ShapeNodes.GetPosition functio
  • Easy msgbox Query
    by jaxgev
    8 Replies
    Last post by Andy Pope
      • Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi
  • Run time error 1004
    by Donald Wm. Johnson
    11 Replies
    Last post by Phillb
      • I am attempting to delete a range of cells in an Excel spreadsheet using a Macro. The range is one row by 8 columns. However, when the line of VBA code actually doing the deletion is reached I get a "Run-time error '1004': Delete method of Range class failed." The actual line causing the error is: Selection.Delete Shift:=x1Up where I have previously selected the ra
  • Variable scoping in Excel VBA macros
    by Wewake
    3 Replies
    Last post by Andy Pope
      • Hi All, I am developing an Excel VBA macro to retrieve the Inventory details from Mainframe sessions and writing the output in the same excel workbook as a last sheet. I am getting problem in the rowCounter variable, the one I am using it to position the row in the output excel sheet. I am initializing the counter value to 2 because I have my header as my first row.
  • Macro to Delete Rows
    by GB Allan
    6 Replies
    Last post by GB Allan
      • Hi, I am writing a macro that I want to do the following with: 1-Sort spreadsheet by column J. 2-Search for the first instance of the term "unbilled." 3-From that point and down, delete all rows below. 4-Delete specfic columns. I'm having trouble with steps 2 and 3 - the search works, but for the deleting of the rows, it's picking a specific row range. I want it to del
  • vlookup
    by Namrata Prashar
    14 Replies
    Last post by Namrata Prashar
      • Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata
  • How to check if a date exists
    by HMote
    10 Replies
    Last post by HMote
      • Could anyone point me in the right direction I just need a way to see if a date exists...example: "6/31/07" doesn't exist, whereas "6/30/07" does exist. Thanks!
  • use inputbox to choose cells for plots in excel
    by Jonas.S
    12 Replies
    Last post by Jon Peltier
      • Hi all, The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that Grateful for ideas usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64) C
  • 0x62304390 referenced memory
    by MishraJitu
    9 Replies
    Last post by kingtiger_6
      • Hi All, I am facing this problem while closing internet explorer. I am really frustrated to this problem. Help me Biswa
  • Change Input Focus: bring Form to front:Stop Excel from flashing: HELP!
    by J678
    2 Replies
    Last post by jameswmc
      • My Macro doesn't bring my userform to the front because it has just transfered focus to Internet Explorer. Instead the Taskbar flashes repeatedly. the code is simple: Set MyObject = CreateObject("internetexplorer.application") With MyObject .Visible = False .Navigate MyLocation Do While .ReadyState <> 4: Loop End With Load UserForm1 UserForm1.Show
  • ACCESS - You do not have exclusive access to the database
    by agriff98
    4 Replies
    Last post by agriff98
      • I have an ACCESS application that is running locally on a user's machine. When they log in, they get the error "You do not have exclusive access to the database", then they have to click "OK" 21 times before the application will open up for them. The .mdw file is named different from the .mdb file, so they aren't locking each other out. Any ideas
  • Add a customized Tab in Communicator 2005
    by Gabriel M&amp;#233;ndez
    7 Replies
    Last post by Ken Kosmowski
      • Hi, i'm trying to add a new customized tab in Communicator 2005 to show an html page, i have a document titled "Planning and Deployment" which somehow explains how to do this... I tried to add a new entry on the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Communicator called "TabURL" and also under HKEY_CURRENT_USER\Software\Policies\Microsoft\Communicator wi
  • How do I configure sharepoint data to point different directory?
    by eac022403
    3 Replies
    Last post by MS ISV Buddy Team
      • I have created 20 GB vhd and install my SharePoint on it. Everything I put as data will be written on that 20 GB vhd. But if I put all my data in shared folder, it will be filled out quickly and I will be out of space. Is there anyway to store the new data other than the vhd and still be shared For example for my shared folder, I want to put the data in another drive but I want them to be shared t
  • How to check if contacts are already in outlook public folder and disregard
    by RhysDavies
    2 Replies
    Last post by Cringing Dragon
      • Hi i posted this code previously - it imports contacts from an accessquery into an exchange public folder for people to use - i import the unique contact ID from the access dbase into the job title field - i want to add code that will check the job title field against the ID in the query and if it is already there i do not want it to create a duplicate contact as it presently does, but i do want i
  • Need help with XPath syntax
    by DeathSurfer
    2 Replies
    Last post by Luiz Claudio - MVP
      • Duuudes: Need help with XPath syntax. I'm new to XPath so bear with me. In the following statement, The way I understand XPath so far should recursively look in the xml file below for every <worksheet_name> element whos value is "Fabric Roll Data " then recursively look for the <first_column_header> element no matter how deep it is in the children of <worksheet_name> an
  • Email data from Access to multiple persons
    by DJRave
    0 Replies
    Last post by DJRave
      • Hey there! For my work I keep track of things in an Access database. I receive data, edit and regroup it and after that distribute it to other people. Every month I have to mail exported *.txt files to a group of people. And since not everybody gets the same data I need to select the files/emailaddresses manually. I want to automate this procedure to reduce the work and chances of errors.
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • TypeOf ToggleButton is MsForms.Checkbox returns true !
    by Sebastien TANIERE
    4 Replies
    Last post by Sebastien TANIERE
      • Hello, I am experiencing a curious problem on VBA : ToggleButtons returns true on condition : TypeOf oControl Is MSForms.CheckBox It returns also true on condition : TypeOf oControl Is MSForms.ToggleButton My problem is that this behavior is due to a recent version of VBA. This bug has appeared on an existing Word application after installing Outlook2003 which installed visual basic 6.3 Ap
  • Different classes in one collection
    by wlwlz
    6 Replies
    Last post by Cringing Dragon
      • Hello Everyone, I just recently started to learn VBA so there are quite a few things I'm having trouble with. When I tried to put multiple classes in a collection and later use For Each <Class> to access them by each class, it would result in an error stating object type does not match. Just wondering is there a way to implement what I'm trying to do here in VBA Namely,