Microsoft ISV

Page 179




  • Topics
    Replies
    Last post
  • Capture Hyperlink values on open MS Access VBA
    by Alan.Hill
    1 Replies
    Last post by Alan.Hill
      • Hi All, I've been doing some VBA stuff for a while and have run into a problem and I'm not sure if there is a simple answer, maybe I'm just going blind on this. I have a database system that logs a serires of quality assesments, and so far all is good, but the problem I have is with the automated link geraneration response capture. To explain; The system held in Access XP will automatical
  • how do re-enable marco after it stopped?
    by sirpelidor
    3 Replies
    Last post by Andy Pope
      • Hi, I wrote some vba code within the Worksheet_Change sub. It supposedly fires whenever a cell value has been changed. Problem is...sometimes it fires, sometime it doesn't. Whenever it doesn't (probably because it encounted bug within my code), no matter what I do, I can't re-enable the marco again. So far, the only way for me to go around that copy my code into a clipboard, close out excel (not
  • RegEx: Process URL segments
    by gregw74
    2 Replies
    Last post by Shasur
      • I need some help in parsing a URL. I am hoping to at least match and remove the domain name (including HTTP..) and the first two or three segments of the URL. http:\\www.somedomain.com\segment_a\segment_b\segment_c\page.htm becomes segment_c\page.htm or segment_b\segment_c\page.htm If a loop is possible that would be ideal. If variable x=2, the loop would remove the first 2 segments of th
  • How to rename worksheet without installed Excel?
    by Perry Choy
    5 Replies
    Last post by Andy Pope
      • I want to rename worksheet but haven't installed Excel
  • Help please
    by jovert
    3 Replies
    Last post by envi_ria
      • can i control any application or software using only VB program or how can i control any application using VB for example, i want to control the internet explorer then by using vb i can direct the website i want to go or write the address without manipulating,only the vb program to be used! Thanks a lot for the help!
  • Associated Toolbar Button with Add-In
    by PSandekian
    1 Replies
    Last post by Cringing Dragon
      • I have created an Excel 2000 VBA project that I need to distribute to others. I would like it to have a toolbar button linked to it. I was thinking an Add-In would be an easy way to go for distribution. I can get it to work with a shortcut key but the button doesn't appear on the toolbar when the Add-In is selected. Does anyone know how I can do this The code is specific to Office 2000 Excel.
  • Numbers in textboxes VBA Excel
    by rascalcat
    4 Replies
    Last post by rascalcat
      • I am trying to use a userform with 3 textboxs. 2 are for user input of numbers. The other is to display the calculation result using the input numbers. Having problems getting the + operator to do what i want
  • Error 9: Subscript out of range
    by lactoast2000
    2 Replies
    Last post by lactoast2000
      • I am having a problem getting past this error. I can't seem to firgure out what I am doing wrong. I am new to VBA so that doesn't help, but I was wondering if anyone could help. Here is the code: Sub Main() Call Pull_Data Call Input_Data End Sub Sub Pull_Data() strWorkSheetRaw = "Jan07-May07" Sheets(strWorkSheetRaw).Select lRowCount = Cells(Rows.Count, "A").E
  • Could You give the Above Code in C#/JavaScript
    by Srikar Muppidi
    0 Replies
    Last post by Srikar Muppidi
      • Dear Friends, I'm struggling to get the time duration of the Song Viewed in JavaScript, I hope if u Could translate the Above code in C#/javaScript, Where i was using < object type ="application/x-oleobject" id ="mediaPlayer" classid ="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6" Please Help anyBody.. Thanks in Advance
  • How could I count the last column in row 1?
    by lyp_sj
    5 Replies
    Last post by Duane in Japan
      • Hello, I'm new for VBA, so I'm wonderring how I can count the # of column in row 1. Thanks so much for help! B.regards/Yaping
  • Some problem in CRM 3.0
    by tadriant
    3 Replies
    Last post by tadriant
      • Hello, I don't know if this is the right place to write, but i'm having an enoying problem. I'm trying to delete an invoice in CRM and i can't do this at all. Everytime i try to delete it, a window "Internet Explorer Script Error" pops up and the message is this: An error has occured in the script on this page. Line: 253 Char: 1 Error: Object doesn't support tis proporty
  • Solving Error 3052
    by Tantani
    1 Replies
    Last post by Mark Ostermann
      • Dear Guys, Hi, I am using Aceess VBA 2003. I have got the following error: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. (Error 3052) You have exceeded the maximum number of locks allowed on a recordset. This limit is specified by the MaxLocksPerFile setting in your system registry. The default value is 9500, and can be changed either by editing the registry
  • VBA Macro created in Word Template not running when template is launched in Internet Explorer
    by S Prasad
    6 Replies
    Last post by S Prasad
      • Hello: I have a Word template that contains a VBA application. This application is launched through a macro and runs fine when I double click and open the template using MS Word. However, when I tried to open the same WORD template file in Internet Explorer (this is the final requirement), it fails to launch the application or run the macro. I am already using the following code in the ThisDoc
  • I want to create a "search" engine within my Excel spreadsheet.
    by Mark at Citi
    1 Replies
    Last post by magicalclick
      • 'm the type of person that likes to teach myself, BUT i'm having difficulties understanding the VB manuals. i figured their would be someone out there that could break it down for me, possibly at a high school level. lol I have a spreadsheet that has many tabs. In one of the tabs it lists client names and information, approx. 260 lines, starting in cell A15 and continuing down so forth. I want t
  • How to configure CER with no dialog?
    by John Brown
    14 Replies
    Last post by Claus Brod
      • I just tried to configure my XP SP2 workstation to send crash reports to a CER file share such that no dialog box would be presented. It didn't work as expected. ReportFault returned frrvErrNoDW and no crash report showed up in the file share. I have the 'Configure Error Reporting' policy enabled and a corporate file path entered. This works fine when I elect to 'send report' through the dialog bo
  • please help to modify
    by sree
    1 Replies
    Last post by sjoo
      • There is a DeleteDuplicate macro code here in this page, This macro actually deletes all but first duplicate row. http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows I wish to delete all but last row. I mean Example Row1, Row2 and Row3 has same element in columnA. I wish to keep the Row3 and delete Row1 and Row2. Special case:-----At the same ti
  • Sept 2002 Action Pack - What was X09-59757
    by SimpleSimon
    1 Replies
    Last post by MS ISV Buddy Team
      • Can anyone tell me which CD X09-59757 was, from the Sept 2002 MS Action Pack I've got a CD sleeve here with a CD Key, and the above number, but no CD to put in it. ...and since I'm asking, how about X10-17366. I *think* that it's for the Evaluation version of Outlook 2003, but can't verify this. This would be from the January 2003 Action Pack. Thanks!
  • OUTLOOK EXPRESS
    by Rath150
    1 Replies
    Last post by Ken Tucker
      • Hi, First time here. Don't know if I am in the right pew Have problem with Outlook Express. When I click on mail - message is totally in script - no graphics - just happened last night. When I go to view tab - click - message in HTML - message looks fine. However, when I go to next message same thing happens - no graphics. Need help to get my messages back to normal read. T
  • How to activate a listbox selection using Excel VBA?
    by Kven
    14 Replies
    Last post by Andy Pope
      • Hi, I am very new to VBA Progamming. I have created a tool which checks for error in excel file. The below is my problem. First i will select a file using Openfile method. Then the combobox will display all the sheets which are present in the selected excel file. Here i will select a excel sheet and run a code to check errors. The procedure will check the errors and shows how many errors
  • excel and vba - get min and max from array...
    by luca90
    4 Replies
    Last post by luca90
      • in column A have a value related column D. In effect in D are the value of Principal Agency and in column A are the value of Sub Agency of Principal Agency. Now based column D how to ,(with a function or macro) get and store in a variable the value of min and max of Sub Agency Example: for all 4580 in column D get the min and max from column A. In this case the min is 4500 the max is 6552 The nam
  • 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
  • Solving Error 3052
    by Tantani
    1 Replies
    Last post by Mark Ostermann
      • Dear Guys, Hi, I am using Aceess VBA 2003. I have got the following error: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. (Error 3052) You have exceeded the maximum number of locks allowed on a recordset. This limit is specified by the MaxLocksPerFile setting in your system registry. The default value is 9500, and can be changed either by editing the registry
  • ListBox Controls in Access 2000
    by Keithyboy1
    1 Replies
    Last post by Keithyboy1
      • I have a listbox control on a form, which is bound to an employees table. Basically, the user can select 1 or more employees from the list and perform certain actions on them. This is all hunky dory. However, when I close the form and re-open it, the list box scroll position is where I last left it, rather than being at the top of the list. Is there any property that can effectively reset the l
  • pogo games
    by maryanna
    0 Replies
    Last post by maryanna
      • I use att yahoo and when i play pogo games i do not hav ea chat box, anyone know what i can do to correct the problem. i get the chat box when i use ie, but that is when i get the application error message when i log off.
  • Creating a dynamic hyperlink to a worksheet cell in Excel using VBA
    by Justus Beek
    6 Replies
    Last post by Cringing Dragon
      • I would like to add a hyperlink that refers to a cell within a worksheet and I would like to do this dynamically. As an example: Sheets("Sheet1").Hyperlinks.Add Anchor:=Sheets("sheet1").Cells(1,2), Address:="", SubAddress:= _ "'sheet2'!A1", TextToDisplay:="Back <<" This works. But now I would like to assi