Microsoft ISV

Page 94




  • Topics
    Replies
    Last post
  • Excel status loader/counter?
    by Scott Boyd
    2 Replies
    Last post by Scott Boyd
      • Hey, Not quite sure how to word this but what i'm looking for is like some sort of preloader or egg timer style graphic or percentage counter to display when my function is running to indicate to users the current progress.  The function i'm running takes up to 3 mins to calculate so wanted to be able to show users that the program hasn't froze etc. [EDIT] Sorry just to update, i n
  • Runtime Error 1004
    by akn112
    5 Replies
    Last post by akn112
      • I think i've asked on almost every VBA forum Here's the error code im getting: Method 'Range' of object '_Global' Failed It comes every second time i run the code. Originally i thought it had something to do with the variables. But i have set my code to set my variables to nothing at the top and bottom of my code. I also close the application and close the workbook. This code should 1) op
  • Track InternetExplorer Object firing new windows
    by Ragnar Moller
    3 Replies
    Last post by Ragnar Moller
      • After stubbornly searching I found how to use an InternetExplorer object to start up IE and to fill in a form which was displayed in the browser. I sort of figured I have to use newwindow or newwindow2or newwindow3 event but I've got a few holes to fill in. I'm programming in vba for Outlook under windows NT and I'm trying to figure out - how do I program the event oe make outlook to take it into
  • Communicator web access Not working on sign in... TLS required ? (Internally and externally)?
    by markm75c
    0 Replies
    Last post by markm75c
      • I can connect to the sign in page just fine.. but once I enter all the information it gives me an error.. reason=2.. could not sign in to the server etc... I know the standalone software can connect and works fine via TCP protocol.. Can I not use TCP protocol from behind the firewall and from the outside.. or can i use TCP inside.. the TLS certificate method on the outside.. Thanks
  • Updating links in Powerpoint with VBA
    by dh273
    2 Replies
    Last post by dh273
      • I'm having problems with Powerpoint VBA. I have pasted blocks of cells from Excel into Powerpoint using Paste Special -> Paste Links-> Microsoft Excel Worksheet Object, and set the updating to manual. I'm trying to get some VBA code that will update all the links in my presentation. Essentually, the code that would do the same as me going to Edit-> Links, selecting all the links and click
  • Open a new blank form from an existing populated form
    by RhysDavies
    1 Replies
    Last post by RhysDavies
      • i know this sounds like a really easy thing to do but for some reason i cant do it - in a new system i am building i have a form where users enter their daily activities and they will need to be able to enter several days at a time. once they have filled in a days activity on the form i want them to be able to click on the 'new' command button and this will save the existing activity record to the
  • Using a date filter for opening a report in Access VBA
    by BerkErgun
    2 Replies
    Last post by BerkErgun
      • I would like to open a report in Access VBA , using a date filter and at Turkish operating system that I¡¯m using, the date format is DAY/MONTH/YEAR. Unfortunately, I¡¯m experiencing a big problem regarding date format. At present, below I tried to explain the problem I¡¯m facing: For example; if I write 30/06/07, program defines it correctly as 30 th of JUNE because there isn¡¯t a 30
  • Referencing objects from different reports
    by Quarry
    2 Replies
    Last post by RobinChadwick
      • Hi, I have 2 Access Forms, Frm1 & Frm2. In Frm1 I have a cmd button which when clicked should open Frm2 and refresh a combo box in Frm2. How can this be done as the below is not working. Private Sub cmd_cmp_Click() DoCmd.OpenForm "frm2" Me.frm2.Form.cbo_1.Refresh End Sub
  • Application Error
    by ComputerGramma
    0 Replies
    Last post by ComputerGramma
      • I keep getting this iexplore.exe-Application error message: "The instruction at "0x02f5454a" referenced memory at "0x02f5454a". The memory could not be "read". What can I do to get rid of this
  • Excel Userform - Runs fine but other users get a compile error
    by suznal
    7 Replies
    Last post by suznal
      • I have a userform that is called from a keyboard shortcut. It works perfectly fine when I run it, but other users cannot run it on their machines. We all are using Excel 2003 SP3, (only one user has SP2) and all users have changed their security to allow macros. But when they try to load the form they get a compile error. The code I have for the userform is... Code Block
  • Returning a custom object from a custom collection
    by MikeBos
    3 Replies
    Last post by Dick Donny
      • Hello, Am new to VBA object orientated stuff and have hit an early hurdle. I've created a collection of boat objects with an array of boats and an integer counter. Storing the boats isn't a problem however when I try to retrieve the boats I'm getting Object variable with block '91' not set issues. For e.g. In Main I'm calling Dim Boats as New BoatCollection ...Code t
  • Null Value Error in recordset
    by Roborean
    2 Replies
    Last post by Roborean
      • I have encountered a problem when returning a record set which contains a Null value. Please can any one help I am trying to determine if a date field against a client is empty but if it is empty, when I try to get the value, I get an error message when it gets to dteDateCreated - "Invalid Use Of Null" Dim SQLText As String Dim rs As Recordset Dim strClientCode Dim
  • 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
  • .mdmp files not being created
    by David Ching
    14 Replies
    Last post by JPSA
      • Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
  • Runtime Error
    by gibger
    4 Replies
    Last post by gibger
      • I'm working on a project that gives a person there training heart rate. When I run it I get the error message Runtime error '13': Type mismatch. Here is the code: Code Snippet Private Sub btnTrainingHeartRate_Click() Dim age ' age Dim rhr ' resting heart rate Dim thr ' training heart rate age = InputBox("Please enter you age", , 20) rhr = InputBo
  • iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
    by sapphireoceans
    14 Replies
    Last post by Jillytodd
      • Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
  • Dragin and dropin file names
    by Dougy
    2 Replies
    Last post by YaelS
      • Hello All I am relatively new to VBA and have a question that I cant seem to find an answer to on then net. Not sure if it is possible, but here goes anyway. I would like to drag and drop a file path\name from explorer into a text box in an excel form where the text box would then display the full path and file name. Thanks D
  • Common Dialog error...
    by sdbenner
    2 Replies
    Last post by Shasur
      • I am trying to use Excel VBA to open a folder and populate an array variable with all the word doc filenames in the folder. I am getting an "ActiveX component can't create object" error on the following code, specifically the Dialogs(wdDialogFileOpen) line, and I'm struggling to figure it out. Any suggestions Public Sub Main() Dim FileArray() As String, ffile As String, ffldr As String,
  • Attaching Contents of a Folder
    by Chin13
    6 Replies
    Last post by Andy Pope
      • Hi all, Using a macro running on excel, I am trying to attach the contents of a folder in Outlook. The files contained in the folder change, so it is not as simple as writing the code to attach a specific file. I need it to attach all the files regardless of the file name. Is this possible Thanks in advance
  • FindNext returns "Nothing" when doing iterative lookups, though data to find is in the cells
    by damienm38
    5 Replies
    Last post by Andy Pope
      • Hello, I am implementing a lookup Method to find translation matches in XL tables. For example, if I call the Method: Translate("world") in the following cells: A | B -------------------------------------------------------------------------- hello world | bonjour le monde world | monde
  • Possible to set CPU usage by Excel?
    by Joe Dawson
    4 Replies
    Last post by Joe Dawson
      • Hi, I have a spreadsheet that runs a bunch of code and then takes a little while to calculate. I have noticed that if I take the focus off of Excel, the CPU stops working on the Excel spreadsheet until I click back on Excel. In other words, if I go surf the web while my spreadsheet is calculating, Excel stops calculating the spreadsheet until I go back to and stay in Excel. I am using Excel 9.0.6.
  • record links during IE navigation
    by tx12345
    0 Replies
    Last post by tx12345
      • hi here is the basic idea: [code] 'turn link logger on Set ie = CreateObject("InternetExplorer.Application") With ie .Visible = False .Navigate "http://msn.com" Do Until .ReadyState = 4: DoEvents: Loop Do While ie.busy: DoEvents: Loop end with 'turn link logger off end sub [/code] if you check the index.dat file a second later, these are all the links that show up related to navigating to just thi
  • Using a formula as the default value in an inputbox (EXCEL)
    by OTG
    3 Replies
    Last post by Andy Pope
      • I currently have this: Code Snippet NewValue = InputBox("Please enter a new value for the cell:", "User input required", Range(ACell).Value) That works fine, except for cells in which there are formulae, where only the result of the formula is displayed. I want the user to be able to edit the formula using an input box. I've tried Code Snippet
  • Code Snippet Manager for VBA
    by jameyer
    2 Replies
    Last post by Derek Smyth
      • I am, for the moment, still writing my VBA code in Excel (and possibly soon word). I find that I use some code repeatedly. Is there any free code snippet manager for the VBA IDE
  • error creating Excel application object
    by srendoherty
    1 Replies
    Last post by Andy Pope
      • Hello World, I am using VBA from an application call MicroStation to open a document in Excel and am having problems creating the Excel Application object. The line: Set xlApp = GetObject(, "Excel.Application") results in the message Run-time Error '429': ActiveX component can't create object. The documentation indicates a number of possible problems, but none of them seem li