Click here to Skip to main content
15,885,216 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: IOException was Unhandled Pin
Dave Kreskowiak7-Jan-13 18:08
mveDave Kreskowiak7-Jan-13 18:08 
GeneralRe: IOException was Unhandled Pin
jankevint7-Jan-13 21:52
jankevint7-Jan-13 21:52 
AnswerRe: IOException was Unhandled Pin
Richard MacCutchan7-Jan-13 22:26
mveRichard MacCutchan7-Jan-13 22:26 
GeneralRe: IOException was Unhandled Pin
jankevint7-Jan-13 23:18
jankevint7-Jan-13 23:18 
GeneralRe: IOException was Unhandled Pin
Richard MacCutchan7-Jan-13 23:31
mveRichard MacCutchan7-Jan-13 23:31 
AnswerRe: IOException was Unhandled Pin
Mike Meinz22-Jan-13 3:15
Mike Meinz22-Jan-13 3:15 
GeneralTo calculate with two - three & four criteria multiple worksheet in summary sheet Pin
atulkhandekar3-Jan-13 21:42
atulkhandekar3-Jan-13 21:42 
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Eddy Vluggen4-Jan-13 22:48
professionalEddy Vluggen4-Jan-13 22:48 
atulkhandekar wrote:

Presently, i have calculate through excel formula but calculation is slow due to thousand of data records
& thousand of formula. And it will take very long time.
 
Now i required to calculate through vba micro to speed up our work.

Using VBA to perform the calculations isn't going to speed up things much. Excel is not meant as a datastore, I suggest you put the records in a Database and work from there.

atulkhandekar wrote:
Note: I am not familiar with VBA.

Try VB.NET; find a good book, and convert the formula's to code.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
atulkhandekar7-Jan-13 1:46
atulkhandekar7-Jan-13 1:46 
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Eddy Vluggen7-Jan-13 1:57
professionalEddy Vluggen7-Jan-13 1:57 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Richard MacCutchan7-Jan-13 6:39
mveRichard MacCutchan7-Jan-13 6:39 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Shailesh Shah12-Jan-13 19:20
Shailesh Shah12-Jan-13 19:20 
Questionwhich method I should go with Pin
demo 22-Jan-13 19:54
demo 22-Jan-13 19:54 
AnswerRe: which method I should go with Pin
Eddy Vluggen4-Jan-13 22:51
professionalEddy Vluggen4-Jan-13 22:51 
Questionvb6 with ms access2007 database Pin
tuticorinmano2-Jan-13 9:58
tuticorinmano2-Jan-13 9:58 
AnswerRe: vb6 with ms access2007 database Pin
David Mujica2-Jan-13 10:26
David Mujica2-Jan-13 10:26 
GeneralRe: vb6 with ms access2007 database Pin
tuticorinmano2-Jan-13 12:49
tuticorinmano2-Jan-13 12:49 
QuestionShould be simple: incompatible types Pin
AndreFratelli1-Jan-13 7:44
AndreFratelli1-Jan-13 7:44 
AnswerRe: Should be simple: incompatible types Pin
AndreFratelli2-Jan-13 0:27
AndreFratelli2-Jan-13 0:27 
GeneralRe: Should be simple: incompatible types Pin
GuyThiebaut7-Jan-13 22:34
professionalGuyThiebaut7-Jan-13 22:34 
Questiondatagrid in vs 2012 Pin
jenkinsdjj30-Dec-12 20:22
jenkinsdjj30-Dec-12 20:22 
AnswerRe: datagrid in vs 2012 Pin
Richard MacCutchan30-Dec-12 22:29
mveRichard MacCutchan30-Dec-12 22:29 
GeneralRe: datagrid in vs 2012 Pin
jenkinsdjj31-Dec-12 0:40
jenkinsdjj31-Dec-12 0:40 
QuestionGetting innertext of HTML with </ br> tag between words Pin
Stonesteel26-Dec-12 22:57
Stonesteel26-Dec-12 22:57 
AnswerRe: Getting innertext of HTML with </ br> tag between words Pin
Dave Kreskowiak27-Dec-12 8:49
mveDave Kreskowiak27-Dec-12 8:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.