Microsoft ISV

Page 167




  • Topics
    Replies
    Last post
  • Manually halting macros
    by une
    2 Replies
    Last post by une
      • How does a user manually (not via any code) halt a macro while it is running if they decide it is taking too long or they just want to stop it It seems you can't use Ctrl-c or Ctrl-z. If you use Ctrl-Alt-Del and bring up the task manager to end the task, Word halts completely and all changes to the document are lost. This is not of much use. Is there another key sequence to halt the macro that wil
  • Using Inet to download an FTP File
    by Dudeman
    4 Replies
    Last post by Jack_II
      • I am creating a macro in Access VBA where I need to retrieve a text file from an FTP site and store it on my c drive. The code seems to be working fine but it does not do anything. It should be creating a file on my local computer, but no file ever comes back. Please advise with any suggestions that could get this code to work. Sub FTPCheck() Const cHost = "ftp://ftp.xxxxxx.com/xxx/xxxxx
  • Vertical scrolling in VBA
    by FWR
    2 Replies
    Last post by FWR
      • Dear all, Vertical scrolling using the mouse wheel does not work in the code window (the window where I write program code) of my VBA. In other cases, vertical scrolling using the mouse wheel works just fine (for example, there are no problems scrolling in the project explorer or properties window of VBA). So, I don't think there is anything wrong with my mouse or the way it is insta
  • Wording of Response web pages is different to specified text
    by Marcus Ogden
    1 Replies
    Last post by Jason Hardester - MSFT
      • Hello, I'm working on a prototype application using Windows Error Reporting, and right now I'm trialling Responses. I'm trying to understand why the wording on the web page I see (after submitting an error report for an event that I've registered a Response for) is completely different from the wording I've specified on the Winqual website's Response Management page. Two examples:
  • How do I count only the worksheets from the ActiveSheet to the last sheet?
    by MyLady
    4 Replies
    Last post by MyLady
      • Hey, Case: Let¡¯s say I have a workbook with ten sheets and have selected a sheet somewhere in between the ten sheets. How do I count only the worksheets from the ActiveSheet to the last sheet Can anyone show me how to do it with a code Regards Cathrine
  • Are these valid bucket ids ?
    by DHON
    14 Replies
    Last post by Claus Brod
      • Hi Jason, Saar, The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day. Could you please, confirm whether these are all valid bucket id If not then reason. Thanks, DHON
  • GET.CHART.ITEM
    by Jonas.S
    3 Replies
    Last post by Jonas.S
      • Hi all, Anyone having a list over point_index which is used in GET.CHART.ITEM() Regards \Jonas
  • Cannot read Office 2007 DVD
    by KRFournier
    4 Replies
    Last post by KRFournier
      • Has anyone experienced the problem of not being able to read the Office 2007 Enterprise installation DVD in a DVD R/RW drive. So far, three drives I've tested cannot read the disc. No error message. Nothing. The drive spins a little, but never sees it. I cannot access the drive through Explorer either. I've even updated the firmware. My drive's are all Lite-On drives, so I don't know if that has a
  • adding text to cell with vba script
    by Derek at Potters Clay
    5 Replies
    Last post by magicalclick
      • I've done this before but I am completely blanking on what I am doing wrong with adding text or in this case a formula to a cell. The line I have and am getting an error on is Workbooks("DSL Annual Rollup").Worksheets("DSL Annual Rollup").Cells(i, 3)="January!D"&i&"February!D"&i&"March!D"&i&"April!D"&i&a
  • Using Paste in the File Save as window
    by smith69085
    4 Replies
    Last post by Andy Pope
      • Hi all I only know a little about VB but have made a form on word that copys a word from the document saves itself to a folder prints a copy and then exits word. it all works fine except i cannot get it to paste the word from the document in the fileName when it saves. The script is below with red showing the problem. Any help on this would be much apreciated Mark Sub Process() ' ' Process j
  • Compile rrror: syntax error
    by gibger
    5 Replies
    Last post by gibger
      • Hi, When I run the following code: Code Snippet Private Sub btnClickMe_Click() Dim intrandom As Integer Dim index Dim person Dim match As Boolean Dim personx Dim persony Dim n Dim birthday() Dim counter match = False ReDim Preserve birthday(23) intrandom = (Rnd * 364) + 1 Randomize counter = 0 For n = 1 To 100 For persony = 1 To 23 birthday(person) = in
  • Access Forms
    by PC Geek
    4 Replies
    Last post by stlarmon
      • hi, Ive got a form, in MS Access and its a group control, which means it can only output integers. I need a little code to attach to the form, so that the text field which its bound to, actually gets the text. eg, if i select "before 2000" on the field, then the database would get "before 200" instead of somethign like 6 etc. i hope im explaining this clearly. Im wondering if s
  • need help for an array macro in word
    by crazyfisherrr
    2 Replies
    Last post by crazyfisherrr
      • Dear all, I am a beginner of VBA programming and I have some problems with an array macro,plz help !!! the array stores student ID and student Name and the macro will enable me to enter the student ID and student Mark in a form, and it will show up " student *** has a mark of ***". this is my script: Public arStuID(8) As String Public arStudMark(8) As Integer Sub startit() arStuID(1) =
  • include crm3.0 accounts page in an IFrame
    by einish
    8 Replies
    Last post by einish
      • I have a web solution developed in framework 1.1 and using crm 1.2 I'm migrating from crm 1.2 to crm 3.0 and I faced the following problem. I used to display this page http://<server name>/SFA/home_accts.aspx in an IFrame in my website to display all accounts same for contacts i used http://<server name>/SFA/home_conts.aspx In CRM 3.0 I cant find the corresponding pages. o
  • 2 Small Macro problems.
    by GB Allan
    6 Replies
    Last post by GB Allan
      • Hi all, Problem 1: I am trying to delete a sheet within a workbook, as part of macro. Here's the code: Sub DeleteInstructions() ' ' DeleteInstructions Macro ' Macro recorded 3/13/2007 by Gary Beckwith ' ' Sheets("INSTRUCTIONS").Select ActiveWindow.SelectedSheets.Delete Sheets("DATA").Select End Sub When I run it, I get the prompt "Data may exist in the
  • Trouble while dealing with Share Point Object Model
    by Moim Hossain
    14 Replies
    Last post by WebDev2000
      • Hello everybody, I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application int
  • inserting row in excel
    by Cammyr
    2 Replies
    Last post by Cammyr
      • I'm using vb.net express to call excel with this code Private Sub Button3_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim XL As Excel.Application Dim xlwb As Excel.Workbook Dim xlsheet As Excel.Worksheet XL = New Excel.Application xlwb = XL.Workbooks.Open( "C:\Documents and Settings\S. Ross\My Docume
  • Why is my Web Query Refreshing Inconsistently?
    by bob135
    4 Replies
    Last post by bob135
      • I have asked on several other forums (In Mr. Excel, a popular excel forum, my post got bumped to the bottom, I'll try posting it again but yeah...I'm looking everywhere now). Here's the issue: This is the code for my query: WEB 1 http://finance.google.com/finance fstype=ii&q=["Ticker"] Selection=EntirePage Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True
  • Sorting cells in a spreadsheet by colour
    by Josh Ord-Hume
    7 Replies
    Last post by crainsworth
      • My apologies if I am asking this question in completely the wrong forum. I am trying to create a VBA macro that will order data in an Excel spreadsheet according to colour (so that like colours are all grouped together). I wonder if somebody would be kind enough to spend some time explaining how to do this to a more or less complete VBA novice! Many thanks... Josh Ord-Hume
  • MS Exchange Migration
    by keithpsft
    1 Replies
    Last post by MS ISV Buddy Team
      • I am currently working for a small business (~20 ppl), and we are attempting to do an Exchange migration in order to upgrade the server running Exchange. Both of the servers will be running Windows Small Business Server 2003 Premium. We have tried using NTBackup and NTRecover. However, we cannot get the databases to mount. I have several questions regarding this migration. When the database
  • Get Current Slide Number And Insert a New Slide
    by paradigm918
    2 Replies
    Last post by paradigm918
      • I've recorded a macro to perform certain formating to slides in a ppt 2003 show. I would like to enhance it by having it insert a new slide after the current slide (as the standard action with CTRL+M) When I record the macro, however, the slide number being inserted is hardcoded - I want the macro to insert after the now current slide. When I record inserting after slide #2, the ap
  • VBA In Excel - AD scripting
    by You Chun
    0 Replies
    Last post by You Chun
      • Hi guys, Just a quick question, hope I'm in the correct area. I'm doing VBA in excel, pulling data from the Active Directory to check and populate certain data. All my querying was fine, except for this particular query, which has above 1500(probably about 3000-4000) members in it. When i use:- For Each Group In objComputer.GetEx("member"), it only man
  • Display a TextBox or Non-modal Message Box
    by sg549
    6 Replies
    Last post by Andy Pope
      • Hi all. What I'm trying to do is put up a user form with a text box while a process is running. I don't need a progress bar, as the process is not that long. I have created a userform that includes a textbox, but only the userform comes up when I ".show" it. Why won't the text box portion of the userform show Alternatively, is it possible to put up a "non-modal" system
  • randomizing the contents of Excel cells
    by Josh Ord-Hume
    6 Replies
    Last post by PYA_Ferro
      • I am trying to create an Excel macro that will look at the contents of cells A1, B1 and C1 and 'randomize' their order. So, if the contents of A1, B1 and C1 are "1", "2" and "3" respectively, they might end up as " 2 ", " 3 ", " 1 " or " 1 ", " 3 ", " 2 " once the macro has been run. Any ideas gratefully rece
  • 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