MS Excel sheets as Input and Output Sheets, Integrated to VB application Programs
-
I found that MS excel Sheets are very Powerful tools if used in Conjunction with Visual Basic Programs. I Used MS excel Object on VB forms to Provide: 1- Large Organized data for Input Purpose, 2- Then Another MS excel object on another Form is used to Present the Output of that program. 3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation. 4- Using excel sheets with programing is really powerful, Output of some communication programs on excel sheets may be used for real time problem detection. It depends on the programmer, how is he/she going to use it.
-
I found that MS excel Sheets are very Powerful tools if used in Conjunction with Visual Basic Programs. I Used MS excel Object on VB forms to Provide: 1- Large Organized data for Input Purpose, 2- Then Another MS excel object on another Form is used to Present the Output of that program. 3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation. 4- Using excel sheets with programing is really powerful, Output of some communication programs on excel sheets may be used for real time problem detection. It depends on the programmer, how is he/she going to use it.
good for you.
Watched code never compiles.
-
I found that MS excel Sheets are very Powerful tools if used in Conjunction with Visual Basic Programs. I Used MS excel Object on VB forms to Provide: 1- Large Organized data for Input Purpose, 2- Then Another MS excel object on another Form is used to Present the Output of that program. 3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation. 4- Using excel sheets with programing is really powerful, Output of some communication programs on excel sheets may be used for real time problem detection. It depends on the programmer, how is he/she going to use it.
We should immediately promote you to a Platinum member for that well thought out position on VB and OLE Automation.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me
-
I found that MS excel Sheets are very Powerful tools if used in Conjunction with Visual Basic Programs. I Used MS excel Object on VB forms to Provide: 1- Large Organized data for Input Purpose, 2- Then Another MS excel object on another Form is used to Present the Output of that program. 3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation. 4- Using excel sheets with programing is really powerful, Output of some communication programs on excel sheets may be used for real time problem detection. It depends on the programmer, how is he/she going to use it.
Member 4320844 wrote:
3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation.
Nope, IIRC the maximum rows in a spreadsheet are 5K. Edit: My bad, not 5K but still restricted number.
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.
-
Member 4320844 wrote:
3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation.
Nope, IIRC the maximum rows in a spreadsheet are 5K. Edit: My bad, not 5K but still restricted number.
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.
As I recall, in Excel 95 (?) the limit was 16384 and it's gone up from there.
-
I found that MS excel Sheets are very Powerful tools if used in Conjunction with Visual Basic Programs. I Used MS excel Object on VB forms to Provide: 1- Large Organized data for Input Purpose, 2- Then Another MS excel object on another Form is used to Present the Output of that program. 3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation. 4- Using excel sheets with programing is really powerful, Output of some communication programs on excel sheets may be used for real time problem detection. It depends on the programmer, how is he/she going to use it.
In my opinion, in most cases, a grid is not a very good way to present information. Most low-paid data monkeys will screw it up royally -- present them with a well-designed form to guide them along.
-
As I recall, in Excel 95 (?) the limit was 16384 and it's gone up from there.
Yes, the last version with the Power Pivot installed can compile its own OLAP in-memory cube and handle with gigabytes of records and provide data mining services. But I think he is talking about a simple visualization of the records where Excel has some limitations for the number of the records, where the simple data grids don’t have this problem.
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.
-
In my opinion, in most cases, a grid is not a very good way to present information. Most low-paid data monkeys will screw it up royally -- present them with a well-designed form to guide them along.
-
I found that MS excel Sheets are very Powerful tools if used in Conjunction with Visual Basic Programs. I Used MS excel Object on VB forms to Provide: 1- Large Organized data for Input Purpose, 2- Then Another MS excel object on another Form is used to Present the Output of that program. 3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation. 4- Using excel sheets with programing is really powerful, Output of some communication programs on excel sheets may be used for real time problem detection. It depends on the programmer, how is he/she going to use it.
-
We should immediately promote you to a Platinum member for that well thought out position on VB and OLE Automation.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me
I second that. maybe with a 'Lord High Aoutomation Guru' icon thrown in.
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H
-
Script monkey, accountants wannabe programmers, we had a lot of them in the nineties,
Two heads are better than one.
Norm .net wrote:
accountants wannabe programmers
Careful in case DD hears you. Hang on, it's Friday and the pubs still serving - clear!
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H
-
Script monkey, accountants wannabe programmers, we had a lot of them in the nineties,
Two heads are better than one.
I resemble that remark!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
-
I resemble that remark!
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
-
Norm .net wrote:
accountants wannabe programmers
Careful in case DD hears you. Hang on, it's Friday and the pubs still serving - clear!
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H
-
I got BAAAAD news for you - he isn't drinking tonight as he has to drive tomorrow.... :-D
Did you know: That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.
-
I second that. maybe with a 'Lord High Aoutomation Guru' icon thrown in.
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H
-
Does it look like a guillotine?
Join the cool kids - Come fold with us[^]
It would not do for one to encourage such things. But not a bad idea, gets rid of the problem area.
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H
-
It would not do for one to encourage such things. But not a bad idea, gets rid of the problem area.
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H
Nagy Vilmos wrote:
gets rid of the problem area.
:laugh:
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.
-
I found that MS excel Sheets are very Powerful tools if used in Conjunction with Visual Basic Programs. I Used MS excel Object on VB forms to Provide: 1- Large Organized data for Input Purpose, 2- Then Another MS excel object on another Form is used to Present the Output of that program. 3- I found that it was fascinating, amazing for Large Data Input and Large output Presentation. 4- Using excel sheets with programing is really powerful, Output of some communication programs on excel sheets may be used for real time problem detection. It depends on the programmer, how is he/she going to use it.
-
I sincerely hope you never discover Access... oops...
-NP Never underestimate the creativity of the end-user.
