Microsoft ISV

Page 177




  • Topics
    Replies
    Last post
  • 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
  • Does Winqual accept WER reports from Vista systems?
    by Claus Brod
    14 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
  • ListView in VBA
    by Cody Code
    2 Replies
    Last post by Cody Code
      • Hallo I Just Have One Question in Regards to the Listview Control in VBA. I am trying to fill each column in my listview with data that is from a recordset. i.e rem lstviewItems in the listview control on the form Set list = Me.lstviewItems.Object With list .ListItems.Add , , rec("Desc") .ListItems.Add.SubItems(1) = rec("RetailCost") .ListItems.Add.SubItems(2) = txtQty.Value
  • How to open "Properties" dialog box to "Custom" tab within macro?
    by oryan_dunn
    2 Replies
    Last post by oryan_dunn
      • I'm writing a macro that will, as part of its operation, update all fields within the document. I need all my custom fields filled out prior to running this macro. I'd like to be able to prompt the user to fill out the properties by providing a button that will open directly to the Custom tab of the file properties dialog box. How do I go about programming this Thanks, Ryan
  • Code to save Office 2007 Word or Powerpoint as Office 2003
    by jchau
    1 Replies
    Last post by Andy Pope
      • How can I use vba to save Office 2007 Word or Powerpoint as Office 2003 counterparts
  • Excel - VBA - Users having major problems
    by suznal
    11 Replies
    Last post by Roosey
      • I NEED HELP! I have a workbook with a decent amount of VBA, and there are users who are experiencing severe difficulties with it. I have no problem on two of my machines with the file, but here is what others are experiencingˇ­ They can open and access all of the controls and feature of the workbook ¨C the first time. Once the save and close the file, they cannot re-open it! They ge
  • Cann't kill excel.exe with Access VBA coding
    by mrtaktak
    3 Replies
    Last post by mrtaktak
      • Hi I use the below coding to quit Excel application 2003, but Excel.exe is remain in the Task Manager. Can anybody give me an idea. Thanks! objExcel.quit Set objExcel = nothing
  • Why is my Access database becoming HUGE!!!
    by Agent Dagnamit
    1 Replies
    Last post by Shasur
      • I'm running this code to allocate a random number to a field called [rnd100] to each row of a table containing around 350k rows. Problem is, the code runs, but rapidly increases the size of the database to well over 1Gb (from under 100Mb). What is going wrong If I removed the row that allocates the random number, it runs fine. If I replace this with a line to simply update eac
  • 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
  • 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
  • VBA Word Can't find project or library
    by Paulnz
    5 Replies
    Last post by Andy Pope
      • I have wrote a VBA macro and in the macro I use visual basic functions such as "RTRIM$( )" and "STR$( )". When running the macro on a client's computer the error "Compile error Can't find project or library" comes up and it stops at the "Rtrim$( )" function. What is missing on the client's computer. Please help Thanks Paul Seo
  • 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
  • VBA Excel short Macro Ending in 1st Open Cell
    by Duane in Japan
    3 Replies
    Last post by AussieJames
      • I recorded an actual Macro and it looks like this. Application.CommandBars("Web").Visible = False Range("A28").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Range("A29").Select ActiveWindow.SmallScroll Down:=3 What I actually have is thousands of rows populated, Three rows are visible with data in the top three rows of my active sheet, 26,
  • 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
  • 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
  • Send Outlook message via VBA Macro in Excel
    by Maplesoft
    11 Replies
    Last post by Sohail Ch.
      • I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error: Run-time error '-2147024770(
  • ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista
    by Claus Brod
    12 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where
  • how can I set all the items' subtotal as False in pivot table?
    by lyp_sj
    4 Replies
    Last post by lyp_sj
      • Module per Plant Category Y03 Y04 Y05 Y06 Y07 Y08 Y09 Y10 Y11 Y12 CLV Export Demand 1092 757 879 977 970 1176 1188 1200 1212 1224 CLV Export Total 1092 757 879 977 970 1176 1188 1200 1212 1224 CLV FN Demand 11520 12710 11524 12392 14807 15554 15843 16
  • 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
  • Why the do while loop does not work?
    by lyp_sj
    6 Replies
    Last post by lyp_sj
      • Hello, Below is my code, the lastrowGSVGrowthRate is 101, I expected result is to copy all the "AFFILIATE" items. While with my code, it only copied the first "AFFILIATE" item. I do not know where I did wrong. Thanks so much! B.regards/Yaping raffiliate = 1 rowaffiliate = 1 Do While raffiliate <= lastrowGSVGrowthRate If cells(raffiliate, 1
  • 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
  • VBA macro for Excel for extracting and 'depositing' text between brackets...
    by Josh Ord-Hume
    5 Replies
    Last post by MyLady
      • I am trying to create an Excel macro that will 'look' at the text contents of a given cell (say A1), copy any text that occurs within brackets, and then deposit this text into an adjacent cell (B1). For example, if A1 contained the following: "This is <just> a test", the word "just" would be extracted and deposited into B1. Ideally, I would like to be able to run such a m
  • Command for insert picture
    by cooldlkk
    1 Replies
    Last post by Andy Pope
      • Hi , could someone pls advise the command for to insert picture to excel using vb command. Dim img as image how to mention location of file name , path directory . what if the file name and path... pls advise
  • Run-time error '13': Type Mismatch
    by whateveritis
    2 Replies
    Last post by whateveritis
      • i always get this error when i try to run...does anyone know what's the problem Code Snippet Option Explicit Private Sub UserForm_Initialize() UpdateData cbxDept.AddItem "Marketing & Sales" cbxDept.AddItem "Supply Chain" cbxDept.AddItem "Purchasing" cbxDept.AddItem "Technical & Production" cbxDept.AddItem "R
  • 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