Hi guys,
I am working on Excel 2007 macros. My requirement is to access MS SQL
server DB from excel, using VBA. I am just trying to pull some data by
connecting to DB, but facing this issue: 'Facing 'run-time error
-2147217871 (80040e31) Automation error' in excel VBA'
Below is the chunk of
Dear Friends,
i have to convert the time to given format . format is as follows.
Time Output
08:590859
17:001700
15:30 1530
17:05 so on.
13:12
00:00
08:57
17:15
08:55
17:10
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Are
Simply use
=TEXT(A2,hhmm)
Warm Regards,
Ravi Kumar.
-Original Message-
From: excelvbacli...@googlegroups.com
[mailto:excelvbacli...@googlegroups.com] On Behalf Of ??
Sent: Wednesday, September 25, 2013 12:44 PM
To: excel-macros@googlegroups.com;
you can use this formula
=TEXT(A12,hhmm)
On Wed, Sep 25, 2013 at 12:13 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Friends,
i have to convert the time to given format . format is as follows.
Time Output
08:590859
17:001700
15:30 1530
17:05 so on.
Thanks Ravinder for your kind help. I have not checked it yet, but if I
face any issue, definitely I'll get back to you for further assistance,
hope you would't mind. :)
Thanks Regards,
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and
Dear Friends,
I got the solution.
Thanks Aamir for giving your idea
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 25, 2013 at 1:02 PM, Aamir Shahzad aamirshahza...@gmail.com wrote:
you can use this
Give us more information..for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sandes Bagwe
Sent: Tuesday, September 24, 2013 8:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I need help on one Macro creation
Hello All,
I
i m taken a loan from bank witch have due date 16 day after 1st date (
29/04/2013 is 1st day and due date is 14/05/2013) how to fined next due
DATE
NEED FORMULA
THANX
Regards
Sridher Sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !
Thanks Mr. ravinder,
But I dont think it is that simple.You have provided the correct formula.
ButI have to calculate the euclidean distance for each sample against all
samples(e.g sample 1 with all other samples, sample 2 with all other
samples, etc)
So there will be huge no. of
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sridher sharma
Sent: Wednesday, September 25, 2013 3:58 PM
To: excel-macros
Subject: $$Excel-Macros$$ for due date
i m taken a loan from bank witch have due date 16 day after 1st date (
29/04/2013
Hi,
Another way. See the attached file.
=DATE(YEAR(D5),MONTH(D5),DAY(D5)+15)
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Wednesday, September 25, 2013 4:31 PM
To:
Hi,
I'm trying to copy the data from the website and below is my code I'm
getting Dim clip As DataObject saying User defined type not defined. and
please verify the code whether its correct. My table id is table1.
[code]
Sub GetTable()
dataarr = Range(A2:A4)
Hello,
Am trying to extract unique values using array but am not getting correct
count. I have attached the excel in Sheet1 there is main data, in sheet2 am
getting values after running macros and in sheet3 colored cells is the
orginal value and in Column C I have put countif formula which is not
Visit here
http://excelpoweruser.wordpress.com/2011/08/09/get-unique-list-another-method/
For more method to get unique see this
http://excelpoweruser.wordpress.com/?s=Unique+list
On Wed, Sep 25, 2013 at 8:32 AM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
Am trying to
Hello
I am stuck with an assignment that I have spent a lot of time trying to
come up with a conventional solution and I am at a point where I need
advise from the esteemed sages on this forum.
Output File name: NAOPIP Review with multiple line items (~2k).
Instructions: The tab has
Hello,
Vassili here, I live in Michigan working for an automotive supplier and I
really enjoy working with excel. I sometimes get some assignments that are
above my capabilities so any assistance is greatly appreciated.
Thanks!
Vassili
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Hi,
This is Aamir Shahzad from Pakistan, working in Bank as MIS officer, work
in excel and learning of advance excel formulas by books this forum. I
intended to learn Macros after expert in formulas.
what streamline should I follow? any idea?
On Thu, Sep 26, 2013 at 1:02 AM, Vassili
recheck your connection string
and where you are getting this error
On 25 Sep 2013 12:26, Junaid junaid.an...@gmail.com wrote:
Hi guys,
I am working on Excel 2007 macros. My requirement is to access MS SQL
server DB from excel, using VBA. I am just trying to pull some data by
connecting to
Dear Junaid,
Kindly attach the error file .
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 25, 2013 at 12:26 PM, Junaid junaid.an...@gmail.com wrote:
Hi guys,
I am working on Excel 2007 macros. My requirement is
19 matches
Mail list logo