Reputation: 309 Architect
- Active Posts:
- 1,851 (0.82 per day)
- 26-March 09
- Profile Views:
- Last Active:
- Today, 06:31 AM
- OS Preference:
- Who Cares
- Favorite Browser:
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Who Cares
- Dream Kudos:
- Expert In:
Posts I've Made
Posted 25 May 2015Then 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.
Posted 25 May 2015No worries, glad you got it sorted and thanks for coming back to tell us...
Posted 24 May 2015You could have a look at using the Replace command and replace them for a space of empty string to remove them all together.
QuoteReplace$(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)
Posted 24 May 2015It 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.
Posted 21 May 2015You 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
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
QuoteThis method cannot be used in an With…End With block.
- Member Title:
- D.I.C Lover
- 43 years old
- June 12, 1971
- Programming Languages:
- C#, VB
- Website URL: