Microsoft ISV

Page 115




  • Topics
    Replies
    Last post
  • Cant return a custom object from a custom collection
    by MikeBos
    1 Replies
    Last post by MikeBos
      • 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
  • Bucket ID 8, event type
    by Claus Brod
    14 Replies
    Last post by DHON
      • Hi all, on my Vista system, I generated a lot of crash reports using WER-aware code (i.e. code which explicitly uses WerReportCreate() and WerReportSubmit()). When I look at those crash reports in the Problem History window, I find that many of those crash reports have a bucket ID of 8. This doesn't look like a bucket ID as it would be assigned for a crash report which makes it to the Winqual site
  • compile error: invalid quaifier
    by CarlaCruz
    3 Replies
    Last post by CarlaCruz
      • Hi! I'm a portuguese school teacher that uses vb 6.0. The error mentioned occurs here **: Public Sub introduz() i = 0 Do While i <= 20 VF.Nr(i) = Val(InputBox("Introduza o numero de cliente", "Numero de cliente")) ** VF.NomeCliente(i) = InputBox("Introduza o nome do cliente", "Nome do cliente") If VF.NomeCliente(i) = ("XYZ") Then
  • Decimal values in text file are seen as Text.
    by Music Mogul
    3 Replies
    Last post by Mercury Schroeppel
      • Hey Everyone, I would like to import text files in a current excel sheet. I'm currently using Excel 97. I'm using the following code to import text files into a current sheet. Code Snippet Blad1.select Sep = Chr(44) SaveColNdx = 1 RowNdx = 1 Open FName For Input Access Read As #1 While Not EOF(1) Line Input #1, WholeLine If Right(WholeLine, 1) <> Sep The
  • Cells
    by LRFT
    6 Replies
    Last post by magicalclick
      • I'm really confused as to why I activate a cell: x = ActiveCell.Row Yet when I try to select that cell: Range (Cells(x, 1)).Select It comes up with an address way out of whack! What am I doing wrong
  • Check Boxes
    by jtminqc
    2 Replies
    Last post by jtminqc
      • I am a self taught newbie in Excel VBA, so my question could be very trivial. I have a UserForm that, among other things, has a CheckBox in it. Say CB1. I would like CB1 to show its last state, whenever I open the UserForm. If it was TRUE last time, I want it to show the check mark, in full black, when I open the form. How do I do that JtmInQc
  • Outlook automation problems
    by JustinCase
    2 Replies
    Last post by Mezhick
      • creating a macro in outlook 2007, and get the following 2 problems: 1. What i do is: Hit reply on an item in my inbox. Write the reply message, and instead of hitting "send", i run my macro. In the macro, i need some info about the mail that i am replying to. (more specifically, i want to save any documents that was attached to the mail.) How can i get a handle to the mail i replied to
  • Setting SeriesCollection Intermittently Fails: ERR - unable to set the xvalues property of the series class
    by RBLNC
    3 Replies
    Last post by Jon Peltier
      • Hi All, See the code snippet below for reference. I have a worksheet that contains multiple charts (ChartType = xlLineMarker) used to display trend data. The series data for each chart is dynamically reset every time the vba code is run. This reset is based on user input that is defining a date range to run view in the trend graphs. The dates are displayed on x-axis of each chart. For some date ra
  • 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
  • Automating PowerPoint
    by Jenise
    4 Replies
    Last post by Andy Pope
      • I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday. Can you please suggest how I can automically execute my vba code to run thank You!
  • Excel::NetDDE and DDEShare
    by saleem145
    3 Replies
    Last post by arpenteur81
      • Has anyone tried to link two workbooks running on different machines I found an interesting article on how this can be done -- http://support.microsoft.com/default.aspx scid=kb;en-us;128491 This is exactly what I want to do -- only problem I can't get it to work!! I am using Windows XP and Excel 2003. I have two seperate machines and I have enabled NetDDE on both of them. Also I know that N
  • Using Autofilter in VBA with a range of criteria
    by jabodaddy
    3 Replies
    Last post by Joe Dawson
      • I have working code to autofilter the list I'm interested in for a single criterion in several fields. However, I can't find anything anywhere that shows how to write the object model fields so that I can use a date range. ie. I thought that I would be able to use RangeObject .AutoFilter(Field:=1, Criteria1 > Date1, Operator:=xlAnd, Criteria2 < Date2) I'm not sure that it's poss
  • How can I activate worksheet when open a user form?
    by lyp_sj
    3 Replies
    Last post by Andy Pope
      • Hello, I used a user form to control several macro command. While after I poped out this user form, I could not activate any worksheets and modify my data. Do you know how I can activate worksheet when opening a user form Thanks so much! B.regards/Yaping
  • Making a Automatic Updatable Hyperlink List
    by Clarence j
    7 Replies
    Last post by MyLady
      • Yes Hello Everyone and thanks for looking at my Thread I am currently trying to Develope a Small Database of Student and Would like After I make a New Worksheet Named After Each Student Example "Sarah Lee" "Michael Jordan" "Bill Cosby" That on the Worsheet Named "Student List" which is in the same workbook Will Make a List of all the w
  • HowTo Delete a worksheet in excel - what is wrong with my code
    by rl_atc
    1 Replies
    Last post by magicalclick
      • I'm trying to copy a worksheet into a new file and delete one of the two worksheets in the new excel file. I get no errors..but the Sheet1 worksheet is not deleted in the new Excel file New.xls Please tell me what I'm doing wrong. Code included below: Imports Microsoft.Office.Interop.Excel Module Module1 Private objExcel As Microsoft.Office.Interop.Excel.Application
  • Login Password
    by lp12lp12
    0 Replies
    Last post by lp12lp12
      • Hi All, Is it possible to create a username/pssword fields in word that will check a domain user credentials Thanks a lot in advance
  • Operating on arrays? Possible?
    by cfel
    3 Replies
    Last post by Cringing Dragon
      • Hi all, I'd like to perform some simple arithmetic on all the numeric values in a column in one workbook and copy the results into a column in another workbook. I would prefer to do this within the macro that is already running, instead of writing the formula into each cell. Currently, I am just running a FOR loop for the length of the column and performing the arithmetic and copy/paste act
  • Excel crashes due to incomplete VBA compilation?
    by R_Neame
    0 Replies
    Last post by R_Neame
      • Intro It's a long story. If anyone has some suggestions, I'd be very grateful. My workbook works fine in Excel 2003 and in Excel 2007 compatibility mode. The problems start showing up when the file is converted to the 2007 format. When the original xls file is converted to xlsm format and then reopened using the Trust Center option "run all macros without notification", I get the error:
  • Excel Inserted Image Files - Compress
    by suznal
    1 Replies
    Last post by Andy Pope
      • I am trying to compress inserted .jpg files in a workbook. There is a button on the picture toolbar in Excel, but I would like to execute the command when the picture is inserted. However, "compress" does not seem to be a property for any event. I have recorded a macro where I compress an image file, but it does not record the event - the code is blank! I have the code in plac
  • Cannot sign in to communications service error on Vista (credentials prompting)??
    by markm75c
    3 Replies
    Last post by markm75c
      • 'You may have entered your sign-in name, username, or password incorrectly' This error suddenly occurs on my Vista x64 machine.. I've seen articles pertaining to XP and a dll to fix, but this doesnt apply in Vista. Has anyone run into this I suspect a log off or reboot may fix it; Its rather aggrivating though, if you try to enter credentials manually it still occurs. I can sign into Com
  • run-time error '1004' Method 'Range' of object '_Global' failed wen using refedit
    by MarkH001
    1 Replies
    Last post by Andy Pope
      • I have looked around the web and cannot find a solution .. hope somebody can help.. I consistantly get run-time error '1004' Method 'Range' of object '_Global' failed when I hit the Range command. The refedit contanis text somthing like (select a range of cells with my mouse) 'Sheet1'!R5C2:R15C2 But I cannot turn that into useable information. My code is launched from a command bu
  • VBA Problem with Excel PrintOut Method
    by newone
    1 Replies
    Last post by Luiz Claudio - MVP
      • Hi, I'm currently working on a small application for educational purposes. The application checks a user's knowledge in Office applications like Excel,Word and Access. The problem is that in a certain question when a user is asked to print a number of pages and a number of copies in a workbook. There is no direct way for my application to find out if the user has entered the correct pa
  • ListBox Item Color
    by Basha Sk
    4 Replies
    Last post by Basha Sk
      • Hi All, I am having two Listboxes. The ListBox1 is having some items and the ListBox2 is used to display the SubItems of the ListBox1 items. If i select two items in ListBox1 then these two items subItems will be dispalyed in ListBox2. So How can i differentiate these subItems with respect to their Parent items. Is it possible to set ForeColor to each item of a ListBox. 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
  • splitting a column in Access
    by DJRave
    0 Replies
    Last post by DJRave
      • Hey there! Does anybody know how I can split a column in Access with VB The problem is that the field contains text and numbers but the text can be multiple words. For instance: abc def 1234 abd def 5678 I want to split the numbers and the text into two seperate columns. Thanx a lot.