Click here to Skip to main content
       

Visual Basic

 
AnswerRe: Debug user control in VB6.0 ? PinmemberChandraRam17-Jan-13 20:08 
QuestionHow make DOWNLOADER in VB 2010 ? Pinmemberradoslaw1238-Jan-13 7:21 
AnswerRe: How make DOWNLOADER in VB 2010 ? [modified] PinmemberGuyThiebaut8-Jan-13 21:53 
GeneralRe: How make DOWNLOADER in VB 2010 ? Pinmemberradoslaw1239-Jan-13 0:36 
GeneralRe: How make DOWNLOADER in VB 2010 ? PinmemberGuyThiebaut9-Jan-13 0:40 
QuestionIOException was Unhandled Pinmemberjankevint7-Jan-13 14:37 
AnswerRe: IOException was Unhandled PinmvpDave Kreskowiak7-Jan-13 18:08 
GeneralRe: IOException was Unhandled Pinmemberjankevint7-Jan-13 21:52 
AnswerRe: IOException was Unhandled PinmvpRichard MacCutchan7-Jan-13 22:26 
GeneralRe: IOException was Unhandled Pinmemberjankevint7-Jan-13 23:18 
GeneralRe: IOException was Unhandled PinmvpRichard MacCutchan7-Jan-13 23:31 
AnswerRe: IOException was Unhandled PinmemberMike Meinz22-Jan-13 3:15 
GeneralTo calculate with two - three & four criteria multiple worksheet in summary sheet Pinmemberatulkhandekar3-Jan-13 21:42 
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet PinmemberEddy 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 Pinmemberatulkhandekar7-Jan-13 1:46 
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet PinmvpEddy Vluggen7-Jan-13 1:57 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet PinmvpRichard MacCutchan7-Jan-13 6:39 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet PinmemberShailesh Shah12-Jan-13 19:20 
Questionwhich method I should go with Pinmemberdemo 22-Jan-13 19:54 
AnswerRe: which method I should go with PinmemberEddy Vluggen4-Jan-13 22:51 
Questionvb6 with ms access2007 database Pinmembertuticorinmano2-Jan-13 9:58 
AnswerRe: vb6 with ms access2007 database PinmemberDavid Mujica2-Jan-13 10:26 
GeneralRe: vb6 with ms access2007 database Pinmembertuticorinmano2-Jan-13 12:49 
QuestionShould be simple: incompatible types PinmemberAndreFratelli1-Jan-13 7:44 
AnswerRe: Should be simple: incompatible types PinmemberAndreFratelli2-Jan-13 0:27 
GeneralRe: Should be simple: incompatible types PinmemberGuyThiebaut7-Jan-13 22:34 
Questiondatagrid in vs 2012 Pinmemberjenkinsdjj30-Dec-12 20:22 
AnswerRe: datagrid in vs 2012 PinmvpRichard MacCutchan30-Dec-12 22:29 
GeneralRe: datagrid in vs 2012 Pinmemberjenkinsdjj31-Dec-12 0:40 
QuestionGetting innertext of HTML with </ br> tag between words PinmemberStonesteel26-Dec-12 22:57 
AnswerRe: Getting innertext of HTML with </ br> tag between words PinmvpDave Kreskowiak27-Dec-12 8:49 
GeneralRe: Getting innertext of HTML with </ br> tag between words PinmemberStonesteel27-Dec-12 21:04 
GeneralRe: Getting innertext of HTML with </ br> tag between words PinmvpDave Kreskowiak28-Dec-12 4:41 
Questionthreading impliment PinmemberMichael Hulak25-Dec-12 17:58 
AnswerRe: threading impliment PinmemberDineshshp25-Dec-12 18:32 
AnswerRe: threading impliment PinmemberEddy Vluggen26-Dec-12 12:16 
QuestionHow to read list of local and network printers PinmemberKASR125-Dec-12 7:21 
AnswerRe: How to read list of local and network printers PinmemberEddy Vluggen25-Dec-12 8:30 
GeneralRe: How to read list of local and network printers PinmemberKASR126-Dec-12 3:38 
GeneralRe: How to read list of local and network printers PinmemberEddy Vluggen26-Dec-12 11:58 
GeneralRe: How to read list of local and network printers [modified] PinmemberKASR126-Dec-12 23:15 
GeneralRe: How to read list of local and network printers PinmemberEddy Vluggen27-Dec-12 4:28 
GeneralRe: How to read list of local and network printers PinmemberKASR127-Dec-12 7:26 
GeneralAdding an email notification module to my application. PinmemberKismetGerald24-Dec-12 13:01 
GeneralRe: Adding an email notification module to my application. PinmvpRichard MacCutchan24-Dec-12 23:07 
GeneralRe: Adding an email notification module to my application. PinmemberKismetGerald25-Dec-12 0:09 
GeneralRe: Adding an email notification module to my application. PinmvpRichard MacCutchan25-Dec-12 21:01 
Questionvbs - text inputs uploaded to web Pinmemberoceaniana24-Dec-12 12:25 
QuestionThrowing run time error while saving the record. PinmemberMember 786176324-Dec-12 2:11 
AnswerRe: Throwing run time error while saving the record. PinmemberEddy Vluggen25-Dec-12 3: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
Web03 | 2.8.140916.1 | Last Updated 20 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid