Groups
Sign in
Groups
Excel Access & VBA
Conversations
About
Send feedback
Help
Excel Access & VBA
Contact owners and managers
1–30 of 32
Mark all as read
Report group
0 selected
Rakesh Sharma
8/1/11
[VBA for Excel & Access] GetUserID fro Environment
---- Paste this in General section ----------- Private Declare Function apiGetUserName Lib "
unread,
[VBA for Excel & Access] GetUserID fro Environment
---- Paste this in General section ----------- Private Declare Function apiGetUserName Lib "
8/1/11
Rakesh Sharma
7/1/11
it was tough living paycheck to paycheck I needed money fast now I dont feel bad about spending my
unread,
it was tough living paycheck to paycheck I needed money fast now I dont feel bad about spending my
7/1/11
Rakesh Sharma
4/8/11
[VBA for Excel & Access] Send email from SQL Server using stored procedure
CREATE Procedure dbo.sp_SQLSMTPMail @vcTo varchar(2048) = null, @vcBody varchar(8000) = '', @
unread,
[VBA for Excel & Access] Send email from SQL Server using stored procedure
CREATE Procedure dbo.sp_SQLSMTPMail @vcTo varchar(2048) = null, @vcBody varchar(8000) = '', @
4/8/11
Rakesh Sharma
4/5/11
http://odette.onlinewebshop.net/medcurex.html
unread,
http://odette.onlinewebshop.net/medcurex.html
4/5/11
Rakesh Sharma
4/5/11
[VBA for Excel & Access] 4/06/2011 12:03:00 AM
http://maths-a-domicile.com/medcurex.html -- Posted By Rakesh Sharma to VBA for Excel &
unread,
[VBA for Excel & Access] 4/06/2011 12:03:00 AM
http://maths-a-domicile.com/medcurex.html -- Posted By Rakesh Sharma to VBA for Excel &
4/5/11
Rakesh Sharma
5/27/10
[VBA for Excel & Access] Create Dynamic commandbar in Excel :easy to change
Name the sheet as "Menus" A B C D E F G 1 Level Caption Position/Macro Divider FaceID
unread,
[VBA for Excel & Access] Create Dynamic commandbar in Excel :easy to change
Name the sheet as "Menus" A B C D E F G 1 Level Caption Position/Macro Divider FaceID
5/27/10
Rakesh Sharma
3/18/10
[VBA for Excel & Access] Work with Excel from Access ( Web Query)
Sub importDatafromWEB() On Error GoTo lb1: '******************************************** '
unread,
[VBA for Excel & Access] Work with Excel from Access ( Web Query)
Sub importDatafromWEB() On Error GoTo lb1: '******************************************** '
3/18/10
Rakesh Sharma
2/8/10
[VBA for Excel & Access] Working with word using VBA in Excel
Sub Createwordapp() Dim wdapp As Object Dim wddoc As Object '**** Creating word application
unread,
[VBA for Excel & Access] Working with word using VBA in Excel
Sub Createwordapp() Dim wdapp As Object Dim wddoc As Object '**** Creating word application
2/8/10
Rakesh Sharma
1/15/10
[VBA for Excel & Access] Convert Numbers into words
Function Inwords(ByVal Nvalue As Double) Dim intDecimal As String Dim intTens As String Dim
unread,
[VBA for Excel & Access] Convert Numbers into words
Function Inwords(ByVal Nvalue As Double) Dim intDecimal As String Dim intTens As String Dim
1/15/10
Rakesh Sharma
1/8/10
[VBA for Excel & Access] Create custom command bar in access using VBA
Sub CreateCommandBar() Dim myCB As CommandBar Dim myCPup1 As CommandBarPopup Dim myCPup2 As
unread,
[VBA for Excel & Access] Create custom command bar in access using VBA
Sub CreateCommandBar() Dim myCB As CommandBar Dim myCPup1 As CommandBarPopup Dim myCPup2 As
1/8/10
Rakesh Sharma
1/1/10
[VBA for Excel & Access] Create 30 Days evaluation restriction for your t...
you can now secure/restrict the usage of your tool/macro by adding below code in excel. Private Sub
unread,
[VBA for Excel & Access] Create 30 Days evaluation restriction for your t...
you can now secure/restrict the usage of your tool/macro by adding below code in excel. Private Sub
1/1/10
Rakesh Sharma
12/22/09
[VBA for Excel & Access] Like Operator (Usage in VB and VBA)
Dim testCheck As Boolean ' The following statement returns True (does "F" satisfy
unread,
[VBA for Excel & Access] Like Operator (Usage in VB and VBA)
Dim testCheck As Boolean ' The following statement returns True (does "F" satisfy
12/22/09
Rakesh Sharma
3
12/21/09
View this page: "Useful links, Courses etc."
Click on http://groups.google.co.in/group/myvbagroup/web/useful-links-courses-etc?hl=en - or copy
unread,
View this page: "Useful links, Courses etc."
Click on http://groups.google.co.in/group/myvbagroup/web/useful-links-courses-etc?hl=en - or copy
12/21/09
Rakesh Sharma
12/21/09
View this page: "Links, Books for Access"
Click on http://groups.google.co.in/group/myvbagroup/web/links-books-for-access?hl=en - or copy &
unread,
View this page: "Links, Books for Access"
Click on http://groups.google.co.in/group/myvbagroup/web/links-books-for-access?hl=en - or copy &
12/21/09
Rakesh Sharma
,
Dilip Pandey
2
12/17/09
Re: Code Help
Thanks Rakesh, I like that you are marking entire forum (myvba...@googlegroups.com) in these types
unread,
Re: Code Help
Thanks Rakesh, I like that you are marking entire forum (myvba...@googlegroups.com) in these types
12/17/09
Gaurav Mathur
, …
Rakesh Sharma
4
11/16/09
Code for opening an internet site (Id and password too) using VBA coding
Do change the field name, as it is mentioned in HTML source of that site in which you wish to login.
unread,
Code for opening an internet site (Id and password too) using VBA coding
Do change the field name, as it is mentioned in HTML source of that site in which you wish to login.
11/16/09
Rakesh Sharma
11/16/09
[VBA for Excel & Access] Open website with login and paswd using VBA
The program requires references to the following: 1 Microsoft Internet Controls 2. Microsoft HTML
unread,
[VBA for Excel & Access] Open website with login and paswd using VBA
The program requires references to the following: 1 Microsoft Internet Controls 2. Microsoft HTML
11/16/09
Rakesh Sharma
2
11/15/09
[VBA for Excel & Access] Create Barchart using "REPT" function.
example workbook From: Rakesh Sharma <rak_s...@yahoo.co.in> To: myvba...@googlegroups.com
unread,
[VBA for Excel & Access] Create Barchart using "REPT" function.
example workbook From: Rakesh Sharma <rak_s...@yahoo.co.in> To: myvba...@googlegroups.com
11/15/09
Rakesh Sharma
11/10/09
[VBA for Excel & Access] Remove workbook password.
'**************************************************************************** ' Main
unread,
[VBA for Excel & Access] Remove workbook password.
'**************************************************************************** ' Main
11/10/09
Rakesh Sharma
2
8/26/09
[VBA for Excel & Access] Append data from Multiple workbooks without open...
Regards Rakesh ----- Forwarded Message ---- From: Rakesh Sharma <rak_s...@yahoo.co.in> To:
unread,
[VBA for Excel & Access] Append data from Multiple workbooks without open...
Regards Rakesh ----- Forwarded Message ---- From: Rakesh Sharma <rak_s...@yahoo.co.in> To:
8/26/09
tanuj sharma
,
Rakesh Sharma
2
8/21/09
Hi...
Hi You can post your queries here Regards Rakesh On Aug 14, 5:51 pm, tanuj sharma <tanujsharm...@
unread,
Hi...
Hi You can post your queries here Regards Rakesh On Aug 14, 5:51 pm, tanuj sharma <tanujsharm...@
8/21/09
Rakesh Sharma
,
Dilip Pandey
2
8/20/09
[VBA for Excel & Access] Conditional Ranking in Excel
Dear Rakesh, Thanks man...!!1 U r genius. Thx -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +
unread,
[VBA for Excel & Access] Conditional Ranking in Excel
Dear Rakesh, Thanks man...!!1 U r genius. Thx -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +
8/20/09
Rakesh Sharma
8/12/09
View this page: "SQL Syntex"
Click on http://groups.google.co.in/group/myvbagroup/web/sql-syntex?hl=en - or copy & paste it
unread,
View this page: "SQL Syntex"
Click on http://groups.google.co.in/group/myvbagroup/web/sql-syntex?hl=en - or copy & paste it
8/12/09
Rakesh Sharma
8/12/09
View this page: "About DAO object"
Click on http://groups.google.co.in/group/myvbagroup/web/about-dao-object?hl=en - or copy & paste
unread,
View this page: "About DAO object"
Click on http://groups.google.co.in/group/myvbagroup/web/about-dao-object?hl=en - or copy & paste
8/12/09
Rakesh Sharma
8/12/09
View this page: "DAO & ADO"
Click on http://groups.google.co.in/group/myvbagroup/web/dao-ado?hl=en - or copy & paste it into
unread,
View this page: "DAO & ADO"
Click on http://groups.google.co.in/group/myvbagroup/web/dao-ado?hl=en - or copy & paste it into
8/12/09
Rakesh Sharma
2
8/4/09
How to create Dynamic validation list in excel
Example: Let say I have two sheets in a workbook 1) Lists 2) Answer Sheet Lists : has two list as
unread,
How to create Dynamic validation list in excel
Example: Let say I have two sheets in a workbook 1) Lists 2) Answer Sheet Lists : has two list as
8/4/09
Rakesh Sharma
8/2/09
[VBA for Excel & Access] Send mail without using mail clients (Outlook) t...
Sub Sendmail() Set imsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.
unread,
[VBA for Excel & Access] Send mail without using mail clients (Outlook) t...
Sub Sendmail() Set imsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.
8/2/09
Rakesh Sharma
3
7/27/09
[VBA for Excel & Access] Conditional MIN() & MAX()
Here is the file with example. Regards Rakesh From: Rakesh Sharma <rak_s...@yahoo.co.in> To:
unread,
[VBA for Excel & Access] Conditional MIN() & MAX()
Here is the file with example. Regards Rakesh From: Rakesh Sharma <rak_s...@yahoo.co.in> To:
7/27/09
Rakesh Sharma
7/25/09
Use this to lock your files and folders without using any software
Paste the below code in "Notepad" save it as with any name having extn *.bat. 1. Double
unread,
Use this to lock your files and folders without using any software
Paste the below code in "Notepad" save it as with any name having extn *.bat. 1. Double
7/25/09
Gautam Gupta
7/15/09
Re: Excel open password cracker tool
Hi Rakesh , Its awesome tool. you are a real geek. Thanks. -- Gautam Kumar Gupta 9910091578
unread,
Re: Excel open password cracker tool
Hi Rakesh , Its awesome tool. you are a real geek. Thanks. -- Gautam Kumar Gupta 9910091578
7/15/09