Hi,
Though i learnt some good concepts in vba, I don't know the technical name of them.
For ex. Recently i have been questioned "what is Late binding and Early binding?". I had to say "Dont know" though i knew the concept. Later i asked the same question to one of my friends. He explained the concept that i knew earlier. There are few more like this, that made me to loose a job oppertunity.
...
NarenMCA
Last Activity: May 20 '15, 02:18 PM
Joined: Aug 1 '07
Location: Banglore/India
-
Advanced Tutorial PDF
-
Hi Rpicilli,
It throws the below error.
"Method or Data Member not found."
Can you help me with more details that I must include to my code along with "RecSetName.Dis pose".
Thanks,
Naren -
Hi Veena,
I am setting RecordSet = Nothing every time when the macro runs. If I open the task manager, it shows a huge memory space occupied. So when the user gets on to the next task, It again takes some more space in the RAM. So at a point of time the application stucks.
I guess "Nothing" will just clear the references to the recordset object but the querry o/p(Data) that is temporarily kept in RAM by the...Leave a comment:
-
Kill a RecrodSet in VBA
Hi Everyone,
I have a couple of dropdowns, based on the selection by user I must display values from many worksheets. I am using ADODB concept in VBA.
I am using the below code to get data from various sheets in a excel workbook.
Call rstNetAct.Open( strSQL, strConnStr, CursorTypeEnum. adOpenForwardOn ly, LockTypeEnum.ad LockReadOnly, CommandTypeEnum .adCmdText)
once the Output is shown, I am... -
Hi Stewart,
Its working. The information you have given is very helpful and easily understandable.
Thanks a lot.
Naren...Leave a comment:
-
Sum based on a criteria
Hi,
Table Name: Countries
Field1: Ctry
Field2: State
Field3: Population
Table
--------------------------------------------------------------------
Ctry: State Pop
--------------------------------------------------------------------
Ctry1 State1 100
Ctry1 State2 100
Ctry1 State3 100
Ctry2... -
Thanks for you suggestion.
But I am trying this because I just want to learn this.
-Naren...Leave a comment:
-
Progress Bar in VBA(Excel)
Hi,
I want to use status bar control 6.0 in VBA(Excel). Other functions in the Macro will be performing some copy/paste and filtering operations. I want the progress bar to show status based on the tasks performed by those functions.
Can any one help me in this.
Thanks in advance,
Naren -
VBA & MS Outlook. How to find all files names and folders names...
Hi,
The below code in MS Outlook gives me the names of folders in "public folders". I am looking forward to get all the subfolders and files in "Public folders"
Please assist me in this.
Thanks,
Naren
Dim myNamespace As Outlook.NameSpa ce
Dim myfolder As Outlook.MAPIFol der
Sub test()
Set myNamespace = Application.Get Namespace("MAPI ")... -
Tracking Keyboard hits and Mouse moves using VBA
Hi,
I am VBA programmer looking for a clue or an idea which will help me to do the below.
Is there any way that I can track the Keyboard hits and Mouse moves using VBA even if the excel application is closed. The OS i am using is windows XP
Thanks in advance,
Naren
No activity results to display
Leave a comment: