"Array Index Out of Bounds"
I recently purchased "Office Professional Ed 2003." With
it came "Business Contact Manager." When I double click
to open a particular contact or business contact, I get
the above "subject" message. Is there a reason, fix, or
solution for this?
...Windows Contacts / Windows Live Contacts confusion
Sorry I know that this has probably been treated often but it confuses me
Only a few days ago i have been forced to switch to Windows Live Mail, after
having used Windows Mail in Windows7 for a while (there is a way of
importing windows Mail into Windows7).
I now have two different contact systems.
1. the c:\users\MyName\Contacts
folder (in my German version this is called "Kontakte")
2. The Windows Live Mail contact system that integrates directly into
Windows Live Mail.
It seems that these two do not synchronize and can someone tell me which in ...additem to combobox with an array
hi, i'm trying to add itemns to an multicolumn combobox (3 columns)
using an array.
if i just try to add 1 column there is no problems, but when i try t
add more columns to the combobox it wont work anymore.
jocke's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=76
View this thread: http://www.excelforum.com/showthread.php?threadid=47167
Did you change the .columncount property?
I made a small userform and picked up some values off a worksheet to create...Array+Array
I have 2 (or more) arrays, how can i combine them into 1?
Array 1 = "1, 2, 3, 4"
Array 2 = "A, B, C, D, E, F"
Array_Combined = "1, 2, 3, 4, A, B, C, D, E, F"
On Jan 7, 9:23=A0am, Danny <dannypct...@gmail.com> wrote:
> I have 2 (or more) arrays, how can i combine them into 1?
> Array 1 =3D "1, 2, 3, 4"
> Array 2 =3D "A, B, C, D, E, F"
> Array_Combined =3D "1, 2, 3, 4, A, B, C, D, E, F"
Dear programmer I don't understand the array can any one give very easy
example to understand the types of array ( I can use command button and text
'Don't forget to write notes for me
' the next line will define the array.
Dim a(2) As String
' the next lines define the data of array
a(0) = "1"
a(1) = "2"
a(2) = "3"
And so on
The array is very difficult please give me easy example
"a" <A@a.com> wrote in message news:uy9smdVUIHA.4476@TK2MSFTNGP06.phx.gbl...
> Dear programmer I don't understa...how do I create an array
I have a column of values that look like: 00000000007310F0000
all cells are 19 chars in length, and the 15th char is alpha. I need to map
the 15th alpha char to a numeric. the mapping is as follows:
ABCDEFGHI (column F)
123456789 (column G)
this is where I'm at:
...Account Framework, Account Format, & Default COA
Someone please tell me if I have this straight. When you first
install GP, there is a default account framework which is set to max
length of 66 with max segments of 9. Which means you can have up to 9
segments divvied up any way you wish as long as the total of all
segments does not exceed 66 characters. Correct? And for which there
is really no need to change this. Correct?
Now, when you setup a company you can setup your account format any
way you want as long as it =93fits within=94 the account framework. So,
if you leave the account framework set to the defaults you can set...Array saving question (lbound)
I am saving an array to a file and then load it again.
Open sPath For Binary As #iFile1
If uLoad Then
Get #iFile1, , uArray
Put #iFile1, , uArray
My array looks like this:
Redim myArr(1 to 3) as long
myArr(1) = 100
myArr(2) = 500
myArr(3) = 10000
When I load it again, I say:
Redim MyNewArr(1 to 3) and call the above sub.
For some reason, MyNewArr now looks like this:
MyNewArr(0) = 100
MyNewArr(1) = 500
MyNewArr(2) = 3
When I try to access MyNewArr(3) an out of bounds error is thrown.
Can somebo...Accessing the CCD array of the camera using MFC
I am capturing the images from the camera using VC++ MFC . And each
image is of size 1280*1024. When I want to do processing over certain
area, actually I want to divide the Image height(1024) into 4 blocks
(256,256,256,256) keeping the width (1280) constant. So that I will
get the whole image into 4 small images. Can anyone please kindly tell
me How can I able to do this ? I am thinking of accessing CCD array,
If accessing CCD array is a solution for this.. Please help
Thanks in advance
First, you need to have a device driver that connects to the camera. This is not an MFC
...Identify occurence in "array" which meets condition(s)
Example Scenario: where my formula tests whether the value in column A equals
a multiple of 5. The result is displayed in column B.
Call No. Meet Formula?
So, from the list above, I know that the 5th and 10th call will meet the
My formula is a lot more complicated than just checking for multiples of 5
and I have to run the formula per row (it will be a v long explanation if you
wanna know why). Is there a way such that I just enter "20" in one cell and
the formula gives me a result of "5, 10, 15, 20" (us...array/list
I have defined an CObarray class called CReference, which I've made
I'd like CReference to contain a list type varailble that contains a list of
strings, So I thought I'd use the CStringList class. Thus my CReference
class CReference : public CObject
and my serialise looks like
void CReference::Serialize(CArchive &ar)
ar << notesrefs << notesresources << titl...To Array or not to Array...
....That is the question!
Is there a difference (in terms of processing speed, efficiency, etc.)
between using the non-array SUMPRODUCT formula or using the SUM array
formula? When used on a large scale, is one faster - or better in some
way - than the other?
In my limited experience I find that on large worksheets,
array formulas are far more processing greedy than SUMPRODUCT
and hence take longer.
I tend to prefer arrays though! And i find more user friendly with
nested IFs (with SUM/COUNT etc)
"hmm" <firstname.lastname@example.org> wrote in message news:3FE...array formula in vba
I have a worksheet in which I have a following array formula entered
I would like to write a macro that would enter such formula into
Q1:Q1000, the problem that I can't solve is the number of rows that is
changing, sometimes I have 1000 rows, sometimes more. How to adjust
the formula under vba to consider the number of rows?
Your formula looks kind of weird. You started in B1 in one portion and P2 in
another. And you wanted to put the formula in Q1:Q###.
I'm gonna guess that you really meant to st...Array
Hello from steved
I would like to insert a row but I get a message
you cannot change part of an array
How do I acheive inserting a row
Remove your array formula(s) that intersect the rows you're moving.
In article <email@example.com>,
"Steved" <firstname.lastname@example.org> wrote:
> Hello from steved
> I would like to insert a row but I get a message
> you cannot change part of an array
> How do I acheive inserting a row
>Remove your array fo...problem with array of derived class
Could I get a hand with trying to build a particular array?
I have a base class CActRectangle, and classes such as CActSquare derived
from CActRectangle. The variable int m_nType is used to identify the class,
e.g., ART_SQUARE, and so on for other derivatives.
When I try the following:
CArray <CActRectangle*,CActRectangle*> ActRectangleArray;
CArray <CActSquare *,CActSquare *> ActSquareArray;
. . .
. . .
for(int i = 0; i < m_Rectangles.GetSize(); i++)
if(m_Rectangles[i]->m_nT...Column to Array
I have spent HOURS on this...
Very simple, all I need to do is convert a column of about 1600 items
to an array 12 items wide.
>Very simple, all I need to do is convert a column of about 1600 items
>to an array 12 items wide.
1600 isn't divisible by 12. I'll assume there are 1608 items. I'll
assume your column of data is named D.
For what purpose? If you just want to fill another range that spans 12
columns by 134 rows (I'll use G1:R134). If you want to go across then
...Swap up Two Tchar Array Variables
I wanted to swap the TCHAR str1, TCHAR str2 arrays.
Is there any API for that.
I searched , but i didn't get in MSDN.
I don't think there is one. How about this
void Swap(TCHAR *pStr1,int Len1,TCHAR *pStr2,int Len2)
TCHAR *pTemp = new TCHAR[strlen(pStr1)+1];
"lucky" <Laxmanmaruthy@gmail.com> wrote in message
> I wanted to swap the TCHAR str1, TCHAR str2 arrays.
> Is...Array #3
I have a spreadsheet of various types of expenditure, for example:
Date in column A
with the values in column C
I am trying to use sumif to have subtotals of the different types of
I'm missing something obvious............. well it is Friday pm
tghcogo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10494
View this thread: http://www.excelforum.com/showthread.php?threadid=484260
=SUMPRODUCT(--(B...x-y scatter graph and confused
I am using Excel 2007.
I am trying to do a combination bar graph/ x-y scatter graph.
I have headings and data for date, last year sales, and this years sales.
Dates are formatted as 03/04/08 and sales are formatted for numbers to 1
Everything plots fine and "last years sales" are represented by the column
I have changed "this years sales" to a x-y scatter graph (lines connected to
That combination plots fine.
On the x-y graph, I changed the secondary axis to primary axis.
I then save the workbook.
When I open the workbook, the graph h...Array
In Excel can any one tell me how i change the size of an Array, it is set at
1E to E22, i would like to expand this to make it larger ie: 1G to say G99 ??
Look n the VBA help for resize
Regards Ron de Bruin
"Dad7" <Dad7@discussions.microsoft.com> wrote in message news:CCFF265A-BB76-4FBC-8E80-3110F05F21F3@microsoft.com...
> In Excel can any one tell me how i change the size of an Array, it is set at
> 1E to E22, i would like to expand this to make it larger ie: 1G to say G99 ??
> In Excel can any one tell me ho...Recalculate edited Arrays
2003 on XP.
I have a large range that is full of arrays, the formula works well but when
I need to expand the range to cover the new year, I find/replace the specific
cell for the new year, but then how can I recalculate all the cells in one go
instead of editing and Ctrl+Shft+Return each cell individually?
Please ignore previous question, all sorted, age-onset-moment.
Sorry. Have a nice day.
> 2003 on XP.
> I have a large range that is full of arrays, the formula works well but when
> I need to expand the range to cover the new year, ...Creating an array
I am new to the forums.
I have been learning Powershell in my spare time and it has been
challenging to say the least. I have hit a small snag.
I have written a script that will search a directory and all
sub-directories contained within for .txt files. Once the .txt files
have been found the script looks at the contents of the .txt files for a
certain string. If the string is found within the .txt file it is copied
to another directory.
What I would like to do is create an array which contains all of the
copied .txt files. I would like the contents of the array to b...building array
I am trying to build a dynamic array. Sadly, I can't seem to see my error.
iStartWkCol = 2
iEndWkCol = 74
iNoWks = iEndWkCol - iStartWkCol + 1
ReDim Preserve aNewDbData(1, iNoWks) As Variant 'Resize our array to
accomodate the data
For iCounter = iStartWkCol To iEndWkCol 'Loop through the
Week Cols of the Worksheet
iarrPosn = iCounter - iStartWkCol
aNewDbData(0, iarrPosn) = _
Range(CLetter(iCounter) & "2").Value 'Date
aNewDbData(1, iarrPosn)...How to convert char array into wchar array?
is there a function to conver array of chars into array of WCHARs?
"Polaris" <email@example.com> wrote in message
> is there a function to conver array of chars into array of WCHARs?
>>is there a function to conver array of chars into array of WCHARs?
I use MultiByteToWideChar()
Been tasked with "installing forefront" on our exchange 2007 servers.
i'm confused between two product names:
- Microsoft Forefront Protection 2010 for Exchange Server
- Forefront Security for Exchange server.
What is the difference or is the first name just the latest iteration of the
Thanks for any pointers.
On Mon, 15 Mar 2010 15:11:08 -0400, "Lynne Seamans"
>Been tasked with "installing forefront" on our exchange 2007 servers.