Hi Experts,
Please help me out the problem is if i check my status from master sheet
for knowing how many projects are under process, when i select the
statusfrom the drop down list, why dont all releated figures comes
out. e.g. if i
select under process all the under process project details sh
Paul,
I intend to open file located in specific Folder each time i open a blank
workbook file.This contains Task to be performed and data to be updated each
hour based on customer request. Since there are more than 10 Excel file to
be updated manually (based on request received from customer and T
Paul,
I must admit that you are genius as the way of you explained the thing in
such a lucid manner that a naive person like me understood at first
sight... Unbelievable ..Many Many Thanks again to you Paul as you devoted
your precious time for us...
Thanks & Regards,
C.G.Kumar
On Mon, Dec
hey ashish you have any idea about below 1 line code. can you or somebody else
explain what it does?
Dim FSO As Object
Set FSO = CreateObject("scripting.filesystemobject")
From: hanumant shinde
To: koul.ash...@gmail.com
Cc: excel-macros@googlegroups.com
Sent
thanks kantilal
From: Kantilal Badale
To: excel-macros
Sent: Mon, 20 December, 2010 10:35:12 PM
Subject: Fwd: $$Excel-Macros$$ Need ans for 3 que
Use conditional formatting to highlight cell containing formula
Kantilal
-- Forwarded mes
hey thanks Ashish,
that was really very simple yar. :)
From: ashish koul
To: excel-macros@googlegroups.com
Sent: Sun, 19 December, 2010 11:52:44 AM
Subject: Re: $$Excel-Macros$$ Need ans for 3 que
use this function
Function checkformula(x As Range)
checkf
How may I add a custom menu when one file is open, without using vba code?,
please see attachment, the file creates a new item *“Send Rows to Oracle
NCA”* under menu *“tools”,* when the file is closed the menu is deleted,
however there is no code in VBA code viewer, how is this possible?
-
Use conditional formatting to highlight cell containing formula
Kantilal
-- Forwarded message --
From: ashish koul
Date: Sun, Dec 19, 2010 at 11:52 AM
Subject: Re: $$Excel-Macros$$ Need ans for 3 que
To: excel-macros@googlegroups.com
use this function
Function checkformu
Dear sir how can I write excel sheet dis format 1,85,000 in excel.
It yes then please give me tips. Awating your positive replay…
Raj
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
For this to work, it must be in EACH Excel file that you wish to open!
It will not work for "ANY Excel file", but only the ones that contain this
macro.
Can you explain what it is that you're trying to accomplish?
Is it for multiple users? or just yourself?
You could place the file in the XLSt
In this case, Z will ALWAYS be (4) because:
Range("A1").select ' Selects Cell A1, which means that A1 is now the "Active
Cell"
Z=activecell.row+3 ' Activecell is A1, because you selected it immediately
before.
It looks like you just need to drop the Range("A1").Select
line and have the macro us
Let's look at the command itself.
The "normal" syntax of the SaveAs procedure is:
ActiveWorkbook.SaveAs Filename:="C:\temp\NewFile.xls"
Now, if you have a variable called FileName, you could use:
FileName = "C:\temp\NewFile.xls"
ActiveWorkbook.SaveAs Filename:=FileName
But when you use:
ActiveW
In that case, you're going to have to get a little more "creative" with
your formula.
As I said, the result in subtracting two date/times is a NUMBER.
In your example,
A1 = 10/12/2010 9:00:00 AM and B1 = 20/12/2010 10:00:00 AM
results in:
10.04142, or 10 days and .04142 of a d
Hi
I think using save as it can do, I crate a macro given below but its
not working well
Sub copyfile( )
Dim Filename As String
ActiveWorkbook.SaveAs Filename:=Filename = InputBox("File name, please?")
end sub
it save the file in the name of False.xls always.Pls let me know what
is the trouble.
Re
Guru,
In the menu bar, Click on *Data - Text to columns - Next, *where you can
adjust according to your needs by moving the bar. For further clarifications
please get back to me.
Regards,
Vebhav Jain
On Mon, Dec 20, 2010 at 11:52 AM, gurumurthy sastry Kondury <
gurumurthy.sas...@gmail.com> wrote
Hi,
how can i learn macros
On Mon, Dec 20, 2010 at 1:27 PM, vebhav jain wrote:
> Hi All,
>
> Whats wrong in this code..
> Dim Z as long
> Range("A1").select
> Z=activecell.row+3
> where i need to select the third row from the current row.
>
> Thanks,
> Vebhav Jain
>
> --
>
> --
Could you please tell what if there is more than 1 day difference. Say A1
has 10/12/2010 09:00 and B1 is 20/12/2010 10:00, then put Formulae in C1 as
ABS(B1-A1) in time format it gives result as 10/01/1900 1:00:00 . Actual it
should be 10 Days and 1 Hours.
Any suggestion will be appreciated.
T
pls let me know how can i learn macros creations.
On Mon, Dec 20, 2010 at 2:46 PM, Upendra Singh Sengar <
upendrasinghsen...@gmail.com> wrote:
> Hi Vebhav,
>
> Nothing is wrong in below code but if you want to select 3rd row from
> current row, you should add one line to below code:
> Row(Z).se
Hi,
I have to learn VBA codding( For macro) through online
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
Hi,
I really don't want to write this article as I'm in love with new interface
of Excel 2007 and wants my blog readers and every excel user to understand
the new Ribbon Menu structure than to go back and use Excel 2003 style menu
in Excel 2007. However I don't want to write but I'm not writing
Hi Vebhav,
Nothing is wrong in below code but if you want to select 3rd row from
current row, you should add one line to below code:
Row(Z).select.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 20 December 2010 13:27, vebhav jain wrote:
> Hi All,
>
Hi All,
Whats wrong in this code..
Dim Z as long
Range("A1").select
Z=activecell.row+3
where i need to select the third row from the current row.
Thanks,
Vebhav Jain
--
--
Some important links for excel users:
1
Hi,
I have a complete column like the below which has a reference number, a text
and two values for the text. I want to split this data into four different
columns ( B C D E). Please help.
1.01 Vinculados a Compromissos de Recompra 726.223 300.412
Thanks & Regards
Guru.
--
Hi Vijay,
Can i know from where you downloaded the font. I am usning 2007 excel.
Thanks
Manjunath
On Sun, Dec 19, 2010 at 1:35 PM, P.VIJAYKUMAR wrote:
> Dear Kumar,
>
>
> After installing the font the Rupee Symbol appears only if Rupee Foradian
> font is selected and ~ is pressed you can have t
24 matches
Mail list logo
