The following code copies values from 3 adjacent cells in excel to an array in NSBASIC. The array value in Str(1,1) However I can't get the value from the...
You may want to retrieve the cells one at a time..... I know it is a bit more cumbersome, but I believe that it will resolve your issue. Thanks, Lester ... ...
Hi Lester, I already have my app working by retrieving each cell at a time. Posted a demo of excel commands used on here about a week ago. The problem is that...
Hi George, adding the following line 'MsgBox Ubound(Str)' gives me the value'10' MsgBox TypeName(Str(1,1)) 'knows it is a variant MsgBox TypeName(Str(1,2))...
The value is in str(1,1)(1) This might look strange, but makes good sense. The element str(1,1) contains an array. To reference the first element of an array,...
Hi George, that solved my simulated problem, but it doesnt work with the Excel demo. I'm surprised because I thought that it would have! The Excel data is...
Michael, I think I managed to read more than 1 value from Excel using the "Range" option now! Here's a sketch of what I did: ... like your program, using...
Michael, I couldn't wait, tested it myself with your 1000x22 array (A1:V1000); it is almost immediate! And it works, with just 1 statement! I actually made the...
Thats great news! Thanks to you and George for your efforts. I'll update my Excel commands demo with this info and post on here as before. I now have the...
Yes, you can access specific sheets. If I remember I'll include it in demo also. Dont know what you mean by retrieving 3 dimensions at once? Mike ... the best...
Hi Michael,
>>>
Yes, you can access specific sheets. If I remember I'll include it in demo also.
<<<
Please do!
>>>
Dont know what you mean by retrieving 3...
Hello Michael, In the meantime I did a small test to reduce the complexity of the program, here is my result, perhaps you can use some of it in your example: ...
Have you had any luck in copying the NSBASIC array back into excel ? I've given it a quick try but had no luck. It should be possible. The following line is...
Hello, I used to work with Excel which is very keyboard intensive. To save time and effort I often write macros (which are programs in Visual Basic For...
Hi Michael, here's the code that puts some values from an array into Excel, without fetching anything first. The array is just a 2 dimensional array declared...
Hi Michael, yes, no problem (I hadn't tried it, but your question made me curious of course): Dim Filename,objExcel,Cell(3,3),row,column ' Dim MyArray ...
Could you post the file in the Files section of the Forum? Attachments are stripped off the online messages. Thanks, John ... save time and effort I often...
Hi Thomas, I think that your example wont work. I suspect that when you read the NSBASIC array back into Excel, all of the cells that you select for the range...
It's done! It's named CopyRange.xls John Carter <nsb@...> wrote: Could you post the file in the Files section of the Forum? Attachments are stripped...
Hello: When pasting/copying in Excel the following happen: If you put a $ sign in front of the column and no $ sign in front of the row, the column will stay...
Thank you! ... section of the Forum? ... I ... programs. ... I ... demo. ... low ... language Computer programming languages ... Service. ... Great rates...
Hi Michael, I saw the correct values in the Excel sheet! I don't (normally) publish an untested piece of code, certainly not about a subject where I have no ...
Figured it out now. Dont know what I was doing wrong before but it works now! Probably too many hours in front on computer screen! Here are methods of...
Hello: Forget about this previous post on Excel propagation - I believe it's too complicated for a simple range population. If you can manage to TRANSLATE the...
This four step guide will give you the foundation you always wanted. Learning the basics in handling stocks. This guide will help anyone, interested in getting...
Hello: Forget about this previous post on Excel propagation - I believe it's too complicated for a simple range population. If you can manage to TRANSLATE the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
