Click here to Skip to main content
11,490,282 members (53,091 online)

Visual Basic

 
AnswerRe: Debug user control in VB6.0 ? Pin
ChandraRam17-Jan-13 21:08
memberChandraRam17-Jan-13 21:08 
QuestionHow make DOWNLOADER in VB 2010 ? Pin
radoslaw1238-Jan-13 8:21
memberradoslaw1238-Jan-13 8:21 
AnswerRe: How make DOWNLOADER in VB 2010 ? [modified] Pin
GuyThiebaut8-Jan-13 22:53
memberGuyThiebaut8-Jan-13 22:53 
GeneralRe: How make DOWNLOADER in VB 2010 ? Pin
radoslaw1239-Jan-13 1:36
memberradoslaw1239-Jan-13 1:36 
GeneralRe: How make DOWNLOADER in VB 2010 ? Pin
GuyThiebaut9-Jan-13 1:40
memberGuyThiebaut9-Jan-13 1:40 
QuestionIOException was Unhandled Pin
jankevint7-Jan-13 15:37
memberjankevint7-Jan-13 15:37 
AnswerRe: IOException was Unhandled Pin
Dave Kreskowiak7-Jan-13 19:08
mvpDave Kreskowiak7-Jan-13 19:08 
GeneralRe: IOException was Unhandled Pin
jankevint7-Jan-13 22:52
memberjankevint7-Jan-13 22:52 
AnswerRe: IOException was Unhandled Pin
Richard MacCutchan7-Jan-13 23:26
mvpRichard MacCutchan7-Jan-13 23:26 
GeneralRe: IOException was Unhandled Pin
jankevint8-Jan-13 0:18
memberjankevint8-Jan-13 0:18 
GeneralRe: IOException was Unhandled Pin
Richard MacCutchan8-Jan-13 0:31
mvpRichard MacCutchan8-Jan-13 0:31 
AnswerRe: IOException was Unhandled Pin
Mike Meinz22-Jan-13 4:15
memberMike Meinz22-Jan-13 4:15 
GeneralTo calculate with two - three & four criteria multiple worksheet in summary sheet Pin
atulkhandekar3-Jan-13 22:42
memberatulkhandekar3-Jan-13 22:42 
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Eddy Vluggen4-Jan-13 23:48
memberEddy Vluggen4-Jan-13 23: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 2:46
memberatulkhandekar7-Jan-13 2:46 
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Eddy Vluggen7-Jan-13 2:57
mvpEddy Vluggen7-Jan-13 2:57 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Richard MacCutchan7-Jan-13 7:39
mvpRichard MacCutchan7-Jan-13 7:39 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Shailesh Shah12-Jan-13 20:20
memberShailesh Shah12-Jan-13 20:20 
Questionwhich method I should go with Pin
demo 22-Jan-13 20:54
memberdemo 22-Jan-13 20:54 
AnswerRe: which method I should go with Pin
Eddy Vluggen4-Jan-13 23:51
memberEddy Vluggen4-Jan-13 23:51 
Questionvb6 with ms access2007 database Pin
tuticorinmano2-Jan-13 10:58
membertuticorinmano2-Jan-13 10:58 
AnswerRe: vb6 with ms access2007 database Pin
David Mujica2-Jan-13 11:26
memberDavid Mujica2-Jan-13 11:26 
GeneralRe: vb6 with ms access2007 database Pin
tuticorinmano2-Jan-13 13:49
membertuticorinmano2-Jan-13 13:49 
QuestionShould be simple: incompatible types Pin
AndreFratelli1-Jan-13 8:44
memberAndreFratelli1-Jan-13 8:44 
AnswerRe: Should be simple: incompatible types Pin
AndreFratelli2-Jan-13 1:27
memberAndreFratelli2-Jan-13 1:27 
GeneralRe: Should be simple: incompatible types Pin
GuyThiebaut7-Jan-13 23:34
memberGuyThiebaut7-Jan-13 23:34 
Questiondatagrid in vs 2012 Pin
jenkinsdjj30-Dec-12 21:22
memberjenkinsdjj30-Dec-12 21:22 
AnswerRe: datagrid in vs 2012 Pin
Richard MacCutchan30-Dec-12 23:29
mvpRichard MacCutchan30-Dec-12 23:29 
GeneralRe: datagrid in vs 2012 Pin
jenkinsdjj31-Dec-12 1:40
memberjenkinsdjj31-Dec-12 1:40 
QuestionGetting innertext of HTML with </ br> tag between words Pin
Stonesteel26-Dec-12 23:57
memberStonesteel26-Dec-12 23:57 
AnswerRe: Getting innertext of HTML with </ br> tag between words Pin
Dave Kreskowiak27-Dec-12 9:49
mvpDave Kreskowiak27-Dec-12 9:49 
GeneralRe: Getting innertext of HTML with </ br> tag between words Pin
Stonesteel27-Dec-12 22:04
memberStonesteel27-Dec-12 22:04 
GeneralRe: Getting innertext of HTML with </ br> tag between words Pin
Dave Kreskowiak28-Dec-12 5:41
mvpDave Kreskowiak28-Dec-12 5:41 
Questionthreading impliment Pin
Michael Hulak25-Dec-12 18:58
memberMichael Hulak25-Dec-12 18:58 
AnswerRe: threading impliment Pin
Dineshshp25-Dec-12 19:32
memberDineshshp25-Dec-12 19:32 
AnswerRe: threading impliment Pin
Eddy Vluggen26-Dec-12 13:16
memberEddy Vluggen26-Dec-12 13:16 
QuestionHow to read list of local and network printers Pin
KASR125-Dec-12 8:21
memberKASR125-Dec-12 8:21 
AnswerRe: How to read list of local and network printers Pin
Eddy Vluggen25-Dec-12 9:30
memberEddy Vluggen25-Dec-12 9:30 
GeneralRe: How to read list of local and network printers Pin
KASR126-Dec-12 4:38
memberKASR126-Dec-12 4:38 
GeneralRe: How to read list of local and network printers Pin
Eddy Vluggen26-Dec-12 12:58
memberEddy Vluggen26-Dec-12 12:58 
GeneralRe: How to read list of local and network printers [modified] Pin
KASR127-Dec-12 0:15
memberKASR127-Dec-12 0:15 
GeneralRe: How to read list of local and network printers Pin
Eddy Vluggen27-Dec-12 5:28
memberEddy Vluggen27-Dec-12 5:28 
GeneralRe: How to read list of local and network printers Pin
KASR127-Dec-12 8:26
memberKASR127-Dec-12 8:26 
GeneralAdding an email notification module to my application. Pin
KismetGerald24-Dec-12 14:01
memberKismetGerald24-Dec-12 14:01 
GeneralRe: Adding an email notification module to my application. Pin
Richard MacCutchan25-Dec-12 0:07
mvpRichard MacCutchan25-Dec-12 0:07 
GeneralRe: Adding an email notification module to my application. Pin
KismetGerald25-Dec-12 1:09
memberKismetGerald25-Dec-12 1:09 
GeneralRe: Adding an email notification module to my application. Pin
Richard MacCutchan25-Dec-12 22:01
mvpRichard MacCutchan25-Dec-12 22:01 
Questionvbs - text inputs uploaded to web Pin
oceaniana24-Dec-12 13:25
memberoceaniana24-Dec-12 13:25 
QuestionThrowing run time error while saving the record. Pin
Member 786176324-Dec-12 3:11
memberMember 786176324-Dec-12 3:11 
AnswerRe: Throwing run time error while saving the record. Pin
Eddy Vluggen25-Dec-12 4:03
memberEddy Vluggen25-Dec-12 4:03 

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

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


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 27 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid