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 ti
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. P
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.
as a large index of
> connection string examples. You should avoid
> Microsoft Jet connection strings and in cases where there are alternatives,
> ODBC connection strings, which have been replaced by newer drivers. (ODBC
> is still fine and commonly used with many non-Microsoft data sto
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]
a,[SRT1].[Request
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 viola
20 | Mobile - 90290 32123
>
>
>
> *From:* excel-macros@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 ba
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 wrote:
> Dear Sharma,
>
> Pls find the attachment.
>
> pls let me know if there is any problem or the solution was helpful.
>
>
> Warm Re
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 :
http:/
Brilliant! Thanks for your support Ayush.
Best Regards,
Sharma
On Sun, Dec 12, 2010 at 1:35 PM, Ayush 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.
>
> Thanks.
>
> B
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
Date: Mon, Nov 15, 2010 at 2:54 PM
Subject: Re: $$Excel-Macros$$ Fwd: Need Change!
To: excel-macros
;
>s = re.Replace(s, x)
> Next
> Debug.Print s
> re.Pattern = _
> "(^|[.!?(]\b|[.!?(]\s+\b|\r\b|\f\b|\n\b)(.)"
> ProperCase_r = _
> re.Replace(s, "$1§$2§")
> v = Split(ProperCase_r, _
> "§", , vbTextCompare)
> For i = 1 To UBound(v) Step 2
Hi,
First I would like to say thank to you. The script that you had given to me
works fine though I have a constraint as-
The below code is does not handle "(" in the input. Please look into the
below example.
*Input: CASE MANAGEMENT CONFERENCE QUESTIONNAIRE (LOCAL RULE 12.7)*
*Output: Case Man
Hi,
Thanks for your help.
Regards,
-Sharma
On Fri, Nov 12, 2010 at 1:45 PM, SUMIT VYAS wrote:
> Dear
>
> See
>
> Regards
>
> Sumit
>
>
>
> On Fri, Nov 12, 2010 at 1:11 PM, amrahs k wrote:
>
>> Hi,
>>
>> Kindly unprotect the atta
Hi,
I have attached a spreadsheet which contains list of document numbers and
their respective names. What I want is I need a word macro that will do the
following.
Note:
The file name will always starts with the Doc Number (5 digits). Ex: 12345
(Refer "Sample_Findlaw.xls" for list of Doc Number
54Test1.doc" (Refer the spreadsheet
"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:
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 wrote:
> the sub test is just one example of how to use the function into a routine.
>
> Sub test()
> Dim s As String
>
ext and
> use its result
>
>
> regards
> r
>
>
>
>
> 2010/10/28 amrahs k
>
>> 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. D
\n\b)(.)"
>
> ProperCase_r = _
> re.Replace(s, "$1§$2§")
> v = Split(ProperCase_r, _
> "§", , vbTextCompare)
> For i = 1 To UBound(v) Step 2
> v(i) = VBA.StrConv(v(i), vbUpperCase)
> Next
> ProperCase_r = Join(v, "")
> End Function
>
&
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 Adul
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
this
Hi,
Can anyone please assist me on this.
Thanks,
Sharma
On Wed, Sep 29, 2010 at 10:08 AM, amrahs k 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 advic
look into this and help me to overcome this issue since it is very
much required as every time am doing it manually.
Any idea or suggestion will be greatly appreciated.
Thanks a lot!
-Sharma
On Mon, Aug 30, 2010 at 12:36 PM, amrahs k wrote:
> Dear Experts,
>
> I have a problem to w
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 wrote:
>
>> Dear Experts,
>>
>> I have a problem to wo
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
2010 at 1:37 PM, ashish koul wrote:
>
>> in reference select Microsoft outlook
>>
>>
>> Regards
>> Ashish koul
>> akoul.blogspot.com
>>
>>
>>
>>
>> On Fri, Aug 27, 2010 at 10:06 AM, amrahs k wrote:
>>
>>> Hi
;Messages " & vbCrLf & vbCrLf & " Thanks " & vbCrLf & "Regards" &
> vbCrLf & " Ashish Koul"
> .Attachments.Add ThisWorkbook.Path & "\abc1.xls"
> .Send
> End With
>
> Set olMail = Nothing
> 'Kill Th
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 w
; > Thanks again,
> > Sharma
> >
> > On Tue, Jul 27, 2010 at 9:39 AM, Vasant wrote:
> >
> >> Hope this is works...
> >>
> >> Regards
> >> Vasant
> >>
> >>
> >> On Tue, Jul 27, 2010 at 4:22 PM, amrahs k
Christmas"
>
> 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 wro
Hi Dilip,
Good Afternoon!
I just wanted to follow up with the below email. Any updated on this sir?
Thanks & Regards,
Sharma
On 12/21/09, amrahs k wrote:
>
> Dear Dilip,
>
> Yes. Please go ahead with the revised solution since it looks perfect.
>
> Good job sir. Thanks
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 wrote:
>
>> Hi Dilip,
>>
t; dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
> On Wed, Jun 3, 2009 at 2:12 PM, amrahs k wrote:
>
>> Dear Team,
>>
>> Could any one suggest me to solve this task.
>>
>> Thanks,
>> Sharma
>>
>> On Mon, Jun 1, 2009 at
Dear Team,
Could any one suggest me to solve this task.
Thanks,
Sharma
On Mon, Jun 1, 2009 at 7:25 PM, Harmeet Singh wrote:
> Hi Dilip Sir,
>
> Can you please look into this query.
>
> Regards,
> Harmeet
>
> -- Forwarded message ------
> From: amrahs k
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 wrote:
> Hi Harmeet,
>
> I have comeup with new task and I have explained the
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 wrote:
>
>
> On Fri, May 29, 2009 at 1:23 PM, amrahs k wrote:
>
>> Hi Harmeet,
>>
>> I just want a macro for val
ss
> Range("B3").Select
> While ActiveCell.Address <> strAddress
>If ActiveCell.Offset(0, 89).Value <> "Labor" Then
>MsgBox "Cell " & ActiveCell.Offset(0, 89).Address & " is
> empty"
>End If
>ActiveCell.Offset
.
>
> see the attached file.
>
> Regards!
>
> 2009/5/13 amrahs k
>
> 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
2009 at 5:53 PM, amrahs k wrote:
>
>> Hi Team,
>>
>> I need your help it is very urgent!
>>
>> Thanks,
>> Sharma
>>
>> -- Forwarded message --
>> From: amrahs k
>> Date: Wed, May 6, 2009 at 5:33 PM
>> Subject: H
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 wrote:
> Hi,
>
> Please see attached file.
>
> On Wed, May 6, 2009 at 5:53 PM, amrahs k wrot
:
> Hi,
>
> Please see attached file.
>
> On Wed, May 6, 2009 at 5:53 PM, amrahs k wrote:
>
>> Hi Team,
>>
>> I need your help it is very urgent!
>>
>> Thanks,
>> Sharma
>>
>> -- Forwarded message --
>> From: amrahs
Hi Team,
Can anyone please suggest me to extract the contents from the Flash Site. It
would be helpful if you could provide me macro to do this.
Your suggestions will be of great help.
Thanks,
Sharma
--~--~-~--~~~---~--~~
-
42 matches
Mail list logo
