Hi,
How to insert specific column values from excel to sql table using visubal
basic dot net.
Thanks,
Sharma
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Hi team,
Need example for how to insert specific column values from excel to sql
table. using vb.net
Thanks,
Sharma
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread
Hi Team,
I have created a tool in vba with password protected. I have forgot the
password.
Now I want to do some changes in the tool based on the requirement. so
please remove the vba password and send me the tool as soon as possible.
Also it would be great if any one help me to create add ins.
** **
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amrahs k
*Sent:* Friday, March 23, 2012 6:22 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ SQL Query - Excel VBA
** **
Hi Team,
Here I am
Hi Team,
Here I am posting a request for running sql queries in excel macro. I have
listed my queries below. Currently am running these queries manually. I
want these queries needs to be run automatically.
SELECT distinct AMRCostCtr
FROM [SRT1].[RequestToolDev].[dbo].[vReqsocs]
Dear Team,
Can any one please suggest me that how to connect MS - Access database
using Visual Basic.
I have a database mdb file and I want to connect it from VB front end.
Any help or suggestion will be greatly appreciated.
Thanks,
Sharma
--
FORUM RULES (934+ members already BANNED for
Hi Bhushan,
This helps lot and solves my query as well.
Thanks for your time and the help.
Regards,
Sharma
On Tue, Apr 12, 2011 at 12:14 PM, Bhushan Sabbani bsabban...@gmail.comwrote:
Dear Sharma,
Pls find the attachment.
pls let me know if there is any problem or the solution was
@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amrahs k
*Sent:* Monday, April 11, 2011 3:32 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need Small Help to pull values based on the
criteira!
Hi Team,
I have attached the sample spreadsheet with my
Hi Team,
I have attached the sample spreadsheet with my query. Kindly help me to
solve the same.
Thanks,
Sharma
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Brilliant! Thanks for your support Ayush.
Best Regards,
Sharma
On Sun, Dec 12, 2010 at 1:35 PM, Ayush jainayus...@gmail.com wrote:
Dear Sharma,
Attached is the solution. I have used COUNTIFS formula to get this done.
I hope it helps. Please let us know if any further assistance is required.
, _
ยง, , vbTextCompare)
For i = 1 To UBound(v) Step 2
v(i) = VBA.StrConv(v(i), vbUpperCase)
Next
ProperCase_r = Join(v, )
End Function
regards
r
2010/11/13 amrahs k amrahs...@gmail.com
Hi,
First I would like to say thank to you. The script that you had given to
me works fine though I
Hi,
Any update on the below email? I am awaiting for your response.
It would be great if you could share this by today.
Thanks,
Sharma
-- Forwarded message --
From: amrahs k amrahs...@gmail.com
Date: Mon, Nov 15, 2010 at 2:54 PM
Subject: Re: $$Excel-Macros$$ Fwd: Need Change
Hi,
Thanks for your help.
Regards,
-Sharma
On Fri, Nov 12, 2010 at 1:45 PM, SUMIT VYAS svyas0...@gmail.com wrote:
Dear
See
Regards
Sumit
On Fri, Nov 12, 2010 at 1:11 PM, amrahs k amrahs...@gmail.com wrote:
Hi,
Kindly unprotect the attached workbook vba password. Since it is very
Sample_Findlaw.xls)
Name for this Doc Number is : New York
If the user enter Texas instead of New York then the macro would
populate a message box.
Please help me to fix this.
Thanks,
Sharma
On Mon, Nov 1, 2010 at 10:41 AM, amrahs k amrahs...@gmail.com wrote:
Hi,
This is what I actually looking
Hi,
This is what I actually looking for. It works great and solves my query.
Thanks for your efforts and help.
Regards,
Sharma
On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa robb@gmail.com wrote:
the sub test is just one example of how to use the function into a routine.
Sub test()
Dim
result
regards
r
2010/10/28 amrahs k amrahs...@gmail.com
Hi,
This works great. Thanks for your efforts and help. Though I have a small
need as well.
The code gives the output through message box. Due to this I am unable to
copy the value (i.e) Output.
Also the code is only
test()
Dim s As String
s = AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR
MsgBox ProperCase_r(s)
End Sub
regards
r
On 27 Ott, 11:25, amrahs k amrahs...@gmail.com wrote:
Hi Team,
I want a macro in MS word that will do the following.
It will first convert the upper case
Hi Team,
I want a macro in MS word that will do the following.
It will first convert the upper case into title case and then replace every
connecting word with lower case.
*Example:* AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR
*Required Output:* Agreement. The Adoption the
Dear Experts,
I need quick suggestion to solve the below issue.
Issue: Team use to update a spreadsheet for tracking their hours details for
extending the shift. After a day the values in the spreadsheet gets changed
this is because people might miss use it. So I want a backup spreadsheet of
Hi,
Can anyone please assist me on this.
Thanks,
Sharma
On Wed, Sep 29, 2010 at 10:08 AM, amrahs k amrahs...@gmail.com wrote:
Hi Team,
I have attached the spreadsheet in which VBA project was protected with
password. Due to this I am unable to edit the code as well.
Kindly advice me
will be greatly appreciated.
Thanks a lot!
-Sharma
On Mon, Aug 30, 2010 at 12:36 PM, amrahs k amrahs...@gmail.com wrote:
Dear Experts,
I have a problem to work on a folder where in I need to do manually to do
the below task.
I have a folder named as Calibration in C: drive. It contains 500 excel
Dear Experts,
I have a problem to work on a folder where in I need to do manually to do
the below task.
I have a folder named as Calibration in C: drive. It contains 500 excel
files. What I want to do is to create new folder1 and move 50 files to it.
Then another 50 files to new folder2 till the
use in access refrence Microsoft scripting runtime
it makes you copy files , create folders
any things related files if you fail send i have already form access*
On Mon, Aug 30, 2010 at 10:06 AM, amrahs k amrahs...@gmail.com wrote:
Dear Experts,
I have a problem to work on a folder where
, Aug 27, 2010 at 1:37 PM, ashish koul koul.ash...@gmail.comwrote:
in reference select Microsoft outlook
Regards
Ashish koul
akoul.blogspot.com
On Fri, Aug 27, 2010 at 10:06 AM, amrahs k amrahs...@gmail.com wrote:
Hi Koul,
Thanks a lot for your effort and time. I have a response
Ashish Koul
akoul.blogspot.com
On Wed, Aug 25, 2010 at 8:48 AM, amrahs k amrahs...@gmail.com wrote:
Hi Team Members,
I have a query with regard to outlook email. Can anyone please suggest or
advice me how to proceed with this.
Requirement: An email should be send automatically with below
Hi Team Members,
I have a query with regard to outlook email. Can anyone please suggest or
advice me how to proceed with this.
Requirement: An email should be send automatically with below subject and
body to the mentioned address. Copying the left most sheet in the attached
excel in a separate
.
Thanks for your time,
Looking for your help to proceed further.
Thanks again,
Sharma
On Tue, Jul 27, 2010 at 9:39 AM, Vasant vasant...@gmail.com wrote:
Hope this is works...
Regards
Vasant
On Tue, Jul 27, 2010 at 4:22 PM, amrahs k amrahs...@gmail.com wrote
Attached is the revised solution.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 12/23/09, amrahs k amrahs...@gmail.com wrote:
Hi Dilip,
Good Afternoon!
I just wanted
at your end.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Dec 21, 2009 at 1:43 PM, amrahs k amrahs...@gmail.com wrote:
Hi Dilip,
Thanks for looking into this. I have added
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jun 3, 2009 at 2:12 PM, amrahs k amrahs...@gmail.com wrote:
Dear Team,
Could any one suggest me to solve this task.
Thanks,
Sharma
On Mon, Jun 1, 2009 at 7:25 PM, Harmeet Singh
harmeet.hew...@gmail.comwrote:
Hi Dilip Sir,
Can you
Dear Team,
Could any one suggest me to solve this task.
Thanks,
Sharma
On Mon, Jun 1, 2009 at 7:25 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi Dilip Sir,
Can you please look into this query.
Regards,
Harmeet
-- Forwarded message --
From: amrahs k amrahs
Hi Harmeet,
Any update on the below one. Whether this can be done through macro or not?
Please let me know am waiting for your valuable suggestion.
Regards,
Sharma
On Sat, May 30, 2009 at 4:58 PM, amrahs k amrahs...@gmail.com wrote:
Hi Harmeet,
I have comeup with new task and I have
ActiveCell.Address strAddress
If ActiveCell.Offset(0, 89).Value Labor Then
MsgBox Cell ActiveCell.Offset(0, 89).Address is
empty
End If
ActiveCell.Offset(1, 0).Select
Wend
End Sub
Regards
Bala
On May 29, 12:53 pm, amrahs k amrahs...@gmail.com wrote:
Hi Harmeet,
I
Hi Harmeet,
This is what i am exactly looking for.
Thanks a lot. Keep rocking.
Regards,
Sharma
On Fri, May 29, 2009 at 8:53 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
On Fri, May 29, 2009 at 1:23 PM, amrahs k amrahs...@gmail.com wrote:
Hi Harmeet,
I just want a macro
.
Regards!
2009/5/13 amrahs k amrahs...@gmail.com
Hi Harmeet,
I have attached one sample workbook that contains a query for data
validation.
I just need a macro for the same.
Thanks for your help.
Regards,
Sharma
On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh harmeet.hew...@gmail.com
Hi Harmeet,
Please find the attached sample workbook that contains a simple query for my
project.
Thanx in advance.
Regards,
Sharma
On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi,
Please see attached file.
On Wed, May 6, 2009 at 5:53 PM, amrahs k
, 2009 at 5:53 PM, amrahs k amrahs...@gmail.com wrote:
Hi Team,
I need your help it is very urgent!
Thanks,
Sharma
-- Forwarded message --
From: amrahs k amrahs...@gmail.com
Date: Wed, May 6, 2009 at 5:33 PM
Subject: Help required
To: gyanjai...@gmail.com
Hi Jain,
I
...@gmail.comwrote:
Hi,
Please see attached file.
On Wed, May 6, 2009 at 5:53 PM, amrahs k amrahs...@gmail.com wrote:
Hi Team,
I need your help it is very urgent!
Thanks,
Sharma
-- Forwarded message --
From: amrahs k amrahs...@gmail.com
Date: Wed, May 6, 2009 at 5:33
38 matches
Mail list logo