Hi All,
In the user form I have coded a date validation which should take data for
current date or the previous date only with the help of *calendar only*.
However, the code is not working properly.
Moreover in the textbox3 I want it to restrict it only for numbers and no
character should be
Dear Members,
Would you please help regarding How to open a excel file saved on 2007
format in 2003 format
Thanking you in Advance
Sanjib
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Hi Rajan,
Thank you very much but i like macro better because it is really fast.As
you known my sheet is large with lots of rows.
Hope that your experience'll help everyone .
Regards
Son
2011/11/27 rajan verma rajanverma1...@gmail.com
Hi
Please see the attached file.. Pivot table can be
Hi Mr Sam.
I wonder this code used for which office as 2003,2007,2010.Because my
office is 2003 and result is not to like my desirement.
Hope that you can feed back more to me
Regards
son
2011/11/27 Sam Mathai Chacko samde...@gmail.com
Here's a macro to get this done
Sub Consolidator()
very useful sheet. thanks for sharing.
On Mon, Nov 28, 2011 at 12:20 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Thanks Ankit,
Very useful sheet you have shared with Group.
--
Thanks regards,
Noorain Ansari
Son, the macro is written for 2007-10. Will send a modified version,
but before that, can you confirm the result is correct in 2007-10? If
not, what is the issue?
Sam
On 28/11/2011, son nguyen sonnguye...@gmail.com wrote:
Hi Mr Sam.
I wonder this code used for which office as
There is an office 2003 compatibility installation file that can be
downloaded from microsoft site. Just search for the installation
package, and install. even after installing that, you would still not
be able to view data in rows beyond 65536 or columns IV.
Regards
Sam Mathai Chacko
On
http://www.excelfox.com/forum
This is a bulletin board. Not one like googlegroup, but have ppt, word
and outlook forums.
Sam Mathai Chacko
On 28/11/2011, Amit Desai (MERU) amit.de...@merucabs.com wrote:
Dear All,
On part of Thanks Giving day...let me thank you from the depth of my
heart...
Thanks Noorain and Ashish
On Mon, Nov 28, 2011 at 10:58 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Yahya,
Please check attached sheet with Userform.
On Mon, Nov 28, 2011 at 12:47 PM, Yahya Muhammad yahya...@gmail.comwrote:
Thanks Ashish. It does the trick. Just one more
Hi Sam
I tried on office 2010 ,result is ok.Could you send me a modified version
2003 and explain for me a bit of this code as i am a beginer of VB.
Thanks a lot
Son
2011/11/28 Sam Mathai Chacko samde...@gmail.com
Son, the macro is written for 2007-10. Will send a modified version,
but
Rename the file.
2003 format : .xls
2007 format : .xlsx
--- On Mon, 11/28/11, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote:
From: Sanjib Chatterjee chatterjee.kolk...@gmail.com
Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous version of
excel
To: excel-macros
Dear Santosh,
Please see attached sheet i hope it will help to you.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Nov 28, 2011 at 3:00 PM, santosh
2011/11/28 Kenil Gala keni...@yahoo.com
Rename the file.
2003 format : .xls
2007 format : .xlsx
--- On *Mon, 11/28/11, Sanjib Chatterjee chatterjee.kolk...@gmail.com*wrote:
From: Sanjib Chatterjee chatterjee.kolk...@gmail.com
Subject: $$Excel-Macros$$ how to open a 2007 excel file
Thanks ankit.
On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hello All,
In our daily life we calculate so many thing use different calculator.
Here is one excel file which contain almost all calculator.
Calculate enjoy !!!
Regards,
Ankit
--
Dear Ankitji,
Can u please re-send the worksheet ?
Regards,
Sujit
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Amit Gandhi silkyro...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 28 Nov 2011 17:38:31
To: excel-macros@googlegroups.com
Reply-To:
2011/11/28 vijayajith VA vijayajith...@gmail.com
Thanks ankit.
On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal
ankit.agrawal...@gmail.com wrote:
Hello All,
In our daily life we calculate so many thing use different calculator.
Here is one excel file which contain almost all
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
Application.ScreenUpdating = 0
Range(F1).CurrentRegion.Clear
With Cells.Find(What:=Machine, Lookat:=xlWhole,
Even when presented with a problem for xl2007+, I usually write in 2003 .xls
and tell user to convert to .xlsm if desired. Prevents these problems. However,
sometimes there ARE things later versions can do or do better.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai
A TEXT can never be lesser than a number. At least in the Excel world.
Santhosh, please replace the entire code in form1 with this
Private Sub CommandButton1_Click()
If CDate(TextBox1.Value) Date Then
msg = MsgBox(You cannot make a transaction for a future date,
vbCritical, Your
For the sake of readers, and for posterity, you CANNOT just change the file
extension (xlsx to xls) and make it compatible with Excel 2003.
Regards,
Sam
On Mon, Nov 28, 2011 at 6:58 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
2011/11/28 Kenil Gala keni...@yahoo.com
Rename the file.
Do you mean gannt chart?
On Nov 28, 1:50 am, Brajesh Kumar Porwal
brajeshkumarpor...@gmail.com wrote:
Hi Expert,
I have some activity. i want to create grant chart on this activity.
How's make it. for help see enclose file.
give me best solution.
Regards,
Brajesh
Activity.xlsx
thanks all of you.
Regards,
Aamir Shahzad
On Mon, Nov 28, 2011 at 10:22 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Aamir,
You can also try.
*=LOOKUP(C4,$F$9:$G$14)*
0 upto 50 M
51,000,000 51- to 100M
101,000,000 101 to 300M
How about AFTER example using your data.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: shashank bhosle
Sent: Monday, November 28, 2011 1:14 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Criterria based copy DATA FROM THIS Summary AND PASTE
IT ON SHEET 2 TRANSPOSED
Dear Experts,
It there any Formula to count worksheets in a Excel File. I know VBA code
for this but i want any Formula or any combination of formula's only to
solve this. kindly Help. This is very critical for me.
Thanks in Advance..
--
Pankaj Pandey
Bhopal
--
FORUM RULES (934+ members
One way would be to select all sheets and put 1 in cella1 (or any cell
desired). Assuming sheet1 names shf and last sheet named shl
=sum(shfhl!A1)There are other ways
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Secret Shot
Sent: Monday, November 28, 2011 3:36 PM
To:
Contact Details Recruiter :-
*New*star **Consulting** *| Email: ash...@newstarconsulting.com | T:
+91-11-43142000 (100 Lines)|
| No.6, Corner Market, Malviya Nagar | **New Delhi** - 110017| *
***India |
Requirement:
*1. VBA Macros + Advanced Excel + MS
Thanks you so much deepak for your great support lastly i just want to ask
you 1 thing that when ever i clicked on
Macro for mail send microsoft gives me pop up for stating that whould you
like to send this mail (with allow or dinied option ) so every time i have
to click allow buttion is there
Dear Pankaj,
Please find attached sheet i hope it will help to you.
Press F2 in Formula for Refresh..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue,
Hi,
Gantt charts can be used to show current schedule status using
percent-complete shadings and a vertical today line as shown here.
Regads,
Brajesh
On Mon, Nov 28, 2011 at 8:57 PM, larry laurence.tha...@navy.mil wrote:
Do you mean gannt chart?
On Nov 28, 1:50 am, Brajesh Kumar Porwal
*Recruiter Id* i...@tekshapers.com
Greetings!!
Interview Tomorrow( candidate who can attend interview tomorrow need to
apply)
We are looking for the position of Data Analyst for one of our
prestigious client.
Location- Gurgaon
Exp- 2 -4yrs
Skills-Need people with Advanced excel exp(V Lookup,
Hi Aamir,
1. Click the *Microsoft Office Button* [image: Button image], click *Excel
Options*, and then click *Add-Ins*.
2. View the add-ins and application extensions that are categorized as
follows:
- *Active Application Add-ins* Lists the extensions that are
Create a Name in your workbook (ribbon Tab Formula Name Manager
Name (for Excample) : SheetsCount
Refer to: =GET.WORKBOOK(4)
[image: Create a NAME.PNG]
in the sheet you can use
*=SheetsCount*
resultling number of sheet in the workbook
they called it : Macro Excel4
Thank you experts,
But would the Convert run in Windows 2000?
Thanking you in Advance
Sanjib
On Mon, Nov 28, 2011 at 9:02 PM, Sam Mathai Chacko samde...@gmail.comwrote:
For the sake of readers, and for posterity, you CANNOT just change the
file extension (xlsx to xls) and make it
Sorry, I didn't find the way to unsubscribe. Please help
Regards
Smitha
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, November 28, 2011 10:36 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ stop
34 matches
Mail list logo