maj3091's Profile User Rating: *****

Reputation: 309 Architect
Active Posts:
1,851 (0.82 per day)
26-March 09
Profile Views:
Last Active:
User is offline Today, 06:31 AM

Previous Fields

OS Preference:
Who Cares
Favorite Browser:
Favorite Processor:
Favorite Gaming Platform:
Your Car:
Who Cares
Dream Kudos:
Expert In:

Latest Visitors

Icon   maj3091 has not set their status

Posts I've Made

  1. In Topic: I can't seem to open files using shell

    Posted 25 May 2015

    Then you need to post what your current code is now that you're concatenating your string for your call.

    Would be worth printing out your string with the full call to the debug window (debug.print) just to verify it yourself that it's correct.
  2. In Topic: Writing to a text file Getting odd charage returns and line feeds.

    Posted 25 May 2015

    No worries, glad you got it sorted and thanks for coming back to tell us...
  3. In Topic: Writing to a text file Getting odd charage returns and line feeds.

    Posted 24 May 2015

    You could have a look at using the Replace command and replace them for a space of empty string to remove them all together.


    Replace$(expression, find, replacewith[, start[, count[, compare]]])

    The Replace$ function syntax has these parts:

    expression Required. String expression containing substring to replace.

    find Required. Substring being searched for.

    replacewith Required. Replacement substring.

    start Optional. Position within expression where substring search is to begin. If omitted, 1 is assumed.

    count Optional. Number of substring substitutions to perform. If omitted, the default value is –1, which means make all possible substitutions.

    compare Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. (0 = case sensitive, 1 = case-insensitive)

    Built-in "vb" constants can be used for the compare argument:

    vbBinaryCompare for 0 (case-sensitive search)
    vbTextCompare for 1 (case-insensitive search)
  4. In Topic: Writing to a text file Getting odd charage returns and line feeds.

    Posted 24 May 2015

    It looks like your input data may have carriage returns in the strings already.

    Instead of writing to a file, write the same data to a multi-line enabled text box to see if that is the case.
  5. In Topic: Drawing a line from a module to a form

    Posted 21 May 2015

    View, on 20 May 2015 - 10:07 AM, said:

    View Postmaj3091, on 20 May 2015 - 12:38 AM, said:

    You can draw from a module, but try passing in your form as as a parameter

    Public Sub DrawOnForm(frmDrawOnMe As Form)
        frmDrawOnMe.Line (10, 10)-(200, 200)
    End Sub

    then call it with

    DrawOnForm Form1

    But I want to use "with...". I done this already but there are too many lines and that's why I wanted to use "with".

    You didn't explicitly say you need to use WITH.

    The line function can't be used with With and end with.

    The comment below is direct from MSDN


    This method cannot be used in an WithEnd With block.

My Information

Member Title:
D.I.C Lover
43 years old
June 12, 1971
Programming Languages:
C#, VB

Contact Information

Website URL:
Website URL  http://


Page 1 of 1
  1. Photo

    Coulee Icon

    02 Feb 2012 - 19:29
    Hi,I found your post Compiling on Win7x64 SP1 gives ADO Issue on XP....
    I met the same problem,can you help.
    I will really really appreciate it
  2. Photo

    maj3091 Icon

    20 Dec 2011 - 01:32
    Thanks raziel_, I didn't realise what you meant at first! I was hoping you knew my boss at work! :)
  3. Photo

    raziel_ Icon

    19 Dec 2011 - 09:24
    gratz on the promotion man :)
Page 1 of 1