Hello Dear,
I have attached to Macro
1.Search Special
2.Search & Replace
Hope it Will Help
Happy To Help
:)
Shyam
On Wed, Apr 7, 2010 at 11:27 PM, Liu Yunxia wrote:
> Hello all,
>
> I'm trying to do a search in Excel for a cell that contains "Apple" or
> "Orange". How can I do that i
Hello Dear,
Hope u have got some call,if not i have approx 100 consultancy e mail id.
if necessary reply,hope all vba job searcher will be also benefited.
Hope It Will Help.
Happy To Help
:)
Shyam
On Thu, Apr 8, 2010 at 11:23 AM, Baby Patel wrote:
> Thanks Shyam
>
> Will try .
>
> Ch
Hello Dear,
I am unable to understand your problem,Is it if *SEC STS CD have any value*
*Then concatenate STAT DESC value ?*
**
If it is then,please let me know.
On Wed, Apr 7, 2010 at 6:22 PM, Sundarvelan N wrote:
> * TOT BAL* *STAT DESC* *CANCELLED* *CANCELLED* *PT TYPE(5.4)* *
>
From: vivek jain [mailto:vivek.j...@gmail.com]
Sent: Saturday, April 03, 2010 8:04 AM
To: 'excel-macros@googlegroups.com'
Cc: 'excel-macros+nore...@googlegroups.com'
Subject: IMPORT FIXED WIDTH TXT FILE TO EXCEL
Dear Group Members,
I want to import a txt file without any separator ex
Hello Dear,
It is possible to import export using ADO Controls,I am bit Confuse,
How i can send excel data to access when access is not install.
Hope it Will Help
Happy To Help
:)
Shyam
On Thu, Apr 8, 2010 at 6:54 AM, Chechu wrote:
> Hi, I need some help in an export from Excel to
Hi Liu,
Turn on the macro recorder, then do the search manually using Find from the
Edit menu.
When the desired cell is found, stop the macro recorder and go have a look at
the code.
If you need more help, post again.
Regrads - Dave.
> Date: Wed, 7 Apr 2010 10:57:10 -0700
> Subject: $$Exce
hi janet use this code to get the file names of all folders in the
directory then use seema's code to append
Public Sub ListWorkbooks()
Dim Directory As String
Dim FileName As String
Dim IndexSheet As Worksheet
Dim rw As Long
'Change the directory below as needed
Directory = "
try for
Range("a1").NumberFormat = "0.000"
On Wed, Apr 7, 2010 at 11:26 PM, ashish koul wrote:
> try using this
>
>
>
> Format( result , "#,##0.000")
>
> example
> Sub a()
>
> Dim i As Integer
> i = 3.000567
> MsgBox Format(i, "#,##0.000")
> End Sub
>
>
>
>
> On Wed, Apr 7, 2010 at 10:15 PM, m
My "debugging" in a prior response was intended to show how numbers
are displayed. Your single values may always contain some "fuzz".
I believe that unless declared otherwise, values within calculation
are converted to double, so the double data type is often preferred to
single unless for some re
Hi, I need some help in an export from Excel to Access macro. I have
an Excel tool which will be used by many users. In this Excel, I have
a range, let's say in Sheet 1, A1:B20, that I need to export to
Access. I mean, each user will have to click a button and export to an
Access database located i
Try storing results or using double.
Sub test()
Dim d As Double
Dim s As Single
d = 0.004
Debug.Print "d", d, d + 0.1
s = 0.004
Debug.Print "s", s, s + 0.1
d = d + 0.1
Debug.Print "d + 0 .1", d
s = s + 0.1
Debug.Print "s + 0.1", s
End Sub
Immediate Window:
Dear Ajinkya & Vikas
Thanks for providing download link.
Hegards
Hemant
On Wed, Apr 7, 2010 at 7:00 PM, ajinkya natu wrote:
> Hi Hemant,
>
> I suppose this is what ur looking for...the file size is around 50MB so had
> to upload it on 4shared.
>
> http://www.4shared.com/file/259007389/9ff776d/
All,
Paul, all my files are in one folder and if necessary I can put master .xls
in the same folder.
Seema, much appreciation for your assistance. Your codes worked well, but
for it to run I supposed to open all excel files and copy en paste 10 file
paths (into the excel you send) and run, to me
Hello all,
I'm trying to do a search in Excel for a cell that contains "Apple" or
"Orange". How can I do that in Cells.Find method? Thanks.
Liu Yunxia
--
--
Some important links for excel users:
1. Follow us on TWIT
try using this
Format( result , "#,##0.000")
example
Sub a()
Dim i As Integer
i = 3.000567
MsgBox Format(i, "#,##0.000")
End Sub
On Wed, Apr 7, 2010 at 10:15 PM, mike wrote:
> I'm working with variables that hold three decimal point numbers such
> as .001 and 3.185. Excel VBA seems to ad
I'm working with variables that hold three decimal point numbers such
as .001 and 3.185. Excel VBA seems to add extra digits to these
variables so that instead of -0.004 the value is -0.0040018998981
for example.
I've tried adding lots of rounding statements everytime I work with
the variable
Thx Aindril/Abhishek,
I will try your solutions and let you know if I need any further help.
Regards,
Roopesh Kapur
On Apr 7, 3:07 pm, Aindril De wrote:
> This is another alternative
> solution:http://www.mrexcel.com/forum/showthread.php?t=86072
>
>
>
> On Wed, Apr 7, 2010 at 3:29 PM, Aindril
Hi,
Go format as table,
On Wed, Apr 7, 2010 at 6:23 PM, Jai wrote:
> Dear All Members.
>
> How can put the filter 2 times in One Excel file .
>
> --
> Thanks For Mail.
>
> --
>
> --
> Some important links for excel
Hi Hemant,
I suppose this is what ur looking for...the file size is around 50MB so had
to upload it on 4shared.
http://www.4shared.com/file/259007389/9ff776d/Access_2007_Bible.html
Regards,
AJ
On 7 April 2010 18:09, Hemant K wrote:
>
> Hi Group,
>
> Any one have this book pls provide i
Hi, Hemant
Chk This link
*http://ineedfile.com/access-2007-bible-free-download*
On Wed, Apr 7, 2010 at 6:09 PM, Hemant K wrote:
>
> Hi Group,
>
> Any one have this book pls provide it.
>
>
> --
> Regards
> Hemant Koranne
>
> --
>
> -
Dear All Members.
How can put the filter 2 times in One Excel file .
--
Thanks For Mail.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldai
* TOT BAL* *STAT DESC* *CANCELLED* *CANCELLED* *PT TYPE(5.4)* *COUNT*
*TYPE SRVS* *SEC STS CD* ** RAN RETURNED, PER CLIENT REQUEST 4362.1
4/6/2010 C-INPT 1 C-INPT RAN RETURNED, PER CLIENT REQUEST 1127.3 4/6/2010
C-OPT 1 C-OPT RAN RETURNED, PER CLIENT REQUEST 1594.1 4/6/2010 C-OPT 1
C-OP
Hi Group,
Any one have this book pls provide it.
--
Regards
Hemant Koranne
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Greetings all
I have a number of widths and lengths of fabrics, up to 20 pieces. The
widths and lengths can vary in size
The aim is use VBA to identify the least amount of fabric I need to
purchase but have the combinations fit within the width of the fabric
roll, this may vary but typically coul
Hello Dear,
I have check it and find great.It's working nice
great work.
On Wed, Apr 7, 2010 at 4:56 AM, Harmeet Singh wrote:
> Good one guyz nice to see such creative formulas, here is my share of
> knowledge.
> Kindly check out the index match function without adding additional colu
This is another alternative solution:
http://www.mrexcel.com/forum/showthread.php?t=86072
On Wed, Apr 7, 2010 at 3:29 PM, Aindril De wrote:
> OOps.. Sorry missed the link...
> Here is the link:
> http://spreadsheets.about.com/od/excelfunctions/qt/080321networkda.htm
>
> Hope this helps...
>
> Re
OOps.. Sorry missed the link...
Here is the link:
http://spreadsheets.about.com/od/excelfunctions/qt/080321networkda.htm
Hope this helps...
Regards,
aindril
On Wed, Apr 7, 2010 at 2:31 PM, L.K. Modi wrote:
> Dear Aindril
>
>
> As i m seeing this mail there is no link at all in your mail. Is
On a different note, has any one used Microsoft office Spreadsheet Control
10.0 / 11.0. It can also serve my purpose but I have never used before and I
(really) can't file a good documentation for it on the internet. I think it
does not support the routine vba expressions as worksheets do. For exam
Roopesh,
Try this:
=NETWORKDAYS(A2,B2)+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)))=7))
Where - A2 is start date and B2 is end date.
Cheers!
AJ
On Wed, Apr 7, 2010 at 12:29 PM, RK wrote:
> Hi Champs,
>
> I am looking for a formula or an add in that works like networkdays,
> the only dif
Dear Aindril
As i m seeing this mail there is no link at all in your mail. Is there any
way to calculate networking days
Regards
LKModi
On Wed, Apr 7, 2010 at 2:20 PM, Aindril De wrote:
> Hi Roopesh,
>
> The process given in the link below will be a good start.
> Regards,
> Aindril
> On W
Thanks Siva for your kind reply.
The attached ocx file is showing the same error - "The control could not be
created because it is not properly licensed." I've tried by registering it
in regsvr32.exe too, still the same result. If you can create it
successfully, please send a sample file, may be I
Hi Roopesh,
The process given in the link below will be a good start.
Regards,
Aindril
On Wed, Apr 7, 2010 at 12:29 PM, RK wrote:
> Hi Champs,
>
> I am looking for a formula or an add in that works like networkdays,
> the only difference being that I want saturday to be included as a
> working d
Is the stats formula, confidence, reliable in excel? I have a set of
data, approx. 1300 rows that I'm looking to calculate the confidence
interval.
--
--
Some important links for excel users:
1. Follow us on TWITTER
Hi Champs,
I am looking for a formula or an add in that works like networkdays,
the only difference being that I want saturday to be included as a
working day, rest everything to remain same as Networkdays.
Regards,
Roopesh Kapur
--
--
34 matches
Mail list logo