Microsoft ISV

Page 193




  • Topics
    Replies
    Last post
  • Visual Basic Error Runtime 1004
    by LindseyV
    1 Replies
    Last post by Andy Pope
      • I am trying to use a conditional sum formula that is referencing data from a different workbook within the same spreadsheet in Excel 2003. The error I am getting is Visual Basic Runtime Error 1004: Unable to set the FormulaArray property of the range class. I have not been able to find any reference to this particular error. Can anyone help on this
  • .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
  • Outlook macro for subject modification
    by blackmamba
    3 Replies
    Last post by blackmamba
      • Hey guys, Do you know how can i make a macro to change the subject for each mail i send. It helps others to create rules based on the subject. Basically i need to take the existing string in the subject and add some text like "funny:" before. This may be easy but I only made excel macros so far. How do i store the macro What if i close the outlook, can i use add-ins like in excel Thanks
  • Subscript out of range with a simple sql :-( [newbie to VBA]
    by Maximus
    14 Replies
    Last post by Andy Pope
      • Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers! Code Snippet Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
  • Vertical align the contents of a text box
    by vsyam
    4 Replies
    Last post by vsyam
      • Hi, I am working on a project where textboxes are used to hold different types of content like normal text, fields and shapes. I want to vertically center-align the contents of the textbox w.r.t the textbox itself. Any ideas Thank you.
  • Getting The Content Of A Word Document?
    by KAMACI
    7 Replies
    Last post by KAMACI
      • How can i get my ActiveDocument's content
  • Getting data from other workbooks
    by Jeff DigiTech
    4 Replies
    Last post by Jeff DigiTech
      • I have a master Excel file named (master.xls) and other slave files called ( slave1.xls, slave2.xls, slave3.xls ....salve5.xls and so on. ) master's structure is exactly the same as other of other salves where they all contain a number in cell A1 master will first select the slaves. And master wants to calculate the sum of A1(s) in slaves and have the result put in B1 of master.xls getting A1(s) f
  • sending emails from MS Word with variable subject line
    by gve2002
    9 Replies
    Last post by Andy_F
      • Hi, I've searched these forums but have not been able to find exactly what I need. I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code (    .Subject = "New subject"   ) What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in
  • ComboBox listing on Startup
    by Philsophaie
    8 Replies
    Last post by Philsophaie
      • The ComboBox1 doesn't initialize the list automatically. It only puts up a blank ComboBox . Here is the code I am using: Private Sub Form1_Load() ComboBox1.Items.Add ("Open App1") ComboBox1.Items.Add ("Open App2") ComboBox1.Items.Add ("Open App3") ComboBox1.Items.Add ("Open App4") End Sub
  • Corrupted Error Report?
    by Optical10
    3 Replies
    Last post by Optical10
      • Hello Whenever computer recovers from a serious error after restarting the Windows error report is corrupted so I get this message in the Explorer responds page, ”°Corrupted Error Report Unfortunately, the error report you submitted is corrupted and cannot be analysed. Corrupted error reports I rare. They can be caused by hardware or software problems, and they usually indicate a serio
  • Simple Outlook 2007 Macro Terms
    by cal2005
    1 Replies
    Last post by Cringing Dragon
      • Hi, I'm wondering where I can find a list of oft-used terms when creating macros for Outlook 2007. Specifically, I just want to set up a keyboard shortcut macro to move the selected email(s) to my "saved" folder (from my inbox). So I need to find terms to: 1. refer to the currently selected message(s) 2. procedure to move to a folder Thanks!
  • VBA findrecord edit
    by nullity
    0 Replies
    Last post by nullity
      • Hello. I haven't used VBA before and I'm just starting to familiarize myself. I am suppose to add an edit functionality to our Contact Form. With that, I have an edit button to enable editing with the forms. But then, the controls are refreshed. I want the same set of information to display when I hit the edit button. I tried to use the: DoCmd.FindRecord (Me![CusID]) but the data showing is not
  • VBA code tweak to import to different column
    by smurray444
    2 Replies
    Last post by Spidermans_DarkSide - MSP, VSI
      • Dear all, I have some VBA code which will import large files into Excel 2007 and upon reaching the bottom of the sheet, will continue onto the next. However, by default it imports starting in column A - yet if I have data in A already, I don't want this to be overwritten. Therefore I was wondering how the code would be adapted slightly so that I can dictate into which column to start the import. T
  • WSS 3.0 "This stock feature has been retired."
    by bafadam
    14 Replies
    Last post by cis365
      • What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently. Anyone have any clue with this could possibly be referencing
  • Contact in Canada
    by [MSP]D
    2 Replies
    Last post by dfoliveira
      • Hi, I'm from Brazil and this year I want to find a job in Canada. Preferably something with .NET. Is anybody here from Canada I want to talk with somebody to know more about life in Canada, career and this stuffs... My messenger address is:d_foliveira@hotmail.com . Thanks a lot. I really appreaciate some help. []'s
  • WSS 3.0 "This stock feature has been retired."
    by bafadam
    14 Replies
    Last post by cis365
      • What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently. Anyone have any clue with this could possibly be referencing
  • Visual Basic for Excel
    by Steven Matuszak
    4 Replies
    Last post by Jon Peltier
      • I have several hidden workbooks loaded at startup that contain excel macros used to modify certain special workbooks. I also have a number of modules that are universal and contain procedures and functions I'd like to use in any project that I load. The file containing common modules is S.XLS and special workbooks C.XLS and D.XLS VB for Excel recognizes each sheet as a project. As I read the on-li
  • 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,
  • Edit the Recordset
    by Tantani
    5 Replies
    Last post by Tantani
      • Hellooo, I use Access VBA 2003 with DAO. Does anyone know how can I move to the first record of an Quantity attribute in order to change or Edit it like this: Quantity 0.50 1.40 0.70 ..... Goto first field (0.50), if it is lower than 1, then change it to 0 Goto second field ( 1.40), if it is lower than 1, then change it to 0, otherwise change it to 1. Thank you in advance!
  • Saving a pic
    by Edday
    7 Replies
    Last post by Andy Pope
      • hey i really need help with this, i have posted in tons of forums and the descussion groups, no replies! gar lol, well i have this macro in excel 2003 and it has a userform and there are a few elements (3 pictures, 3 text boxes) that get modified during the macro then i need to kinda merge them and save it as one picture, can a macro do that any help would be great thx
  • Excel Chart to be converted to Picture or Drawing
    by Joana Andrea Mina
    1 Replies
    Last post by Andy Pope
      • Hello, I am currently programming/automating an excel report with 20 sheets and each sheets consists of more than 10 charts. However, whenever I activate or scroll these sheets a prompt message "Not enough system resources to display" appears. My suspicion is it has too much links because whenever I delete 10 sheets it is working properly. My planned workaround is to convert the c
  • LBound and UBound functions
    by Keithyboy1
    7 Replies
    Last post by Shlizar Axis
      • Is there a reference library I need to enable in the VBE to get LBound and UBound functions They don't appear to exist in the Object Browser with the current reference libraries I have enabled. Many thanks!
  • CRM 3.0 Outlook Client
    by keithpsft
    7 Replies
    Last post by PFLIK
      • I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying: "Your Web browser options are currently set to disable cookies. Mi
  • Access
    by YaelS
    0 Replies
    Last post by YaelS
      • Hi, How can I disable the X button on the main access application
  • Is there a today() function in VBA?
    by Derek at Potters Clay
    3 Replies
    Last post by Shlizar Axis
      • I've been trying to get the current date a few ways in VBA. I tried using the today() function in a spreadsheet and getting the data from that cell and also calling it explicitly in a vba script and have had no success. any help will be appreciated.