Dear NRao,
Please try it...
Change path as per your requirement and Select Tools-Reference-Microsoft
Scripting Runtime before run the macro
Sub Consodilate_workbook()
Dim wb As Workbook
Dim rng As Range
Dim fil As File
Dim i As Integer
Set wb = ThisWorkbook
Dim fld As Folder
Dim
Dear Sanotsh,
If you are using Excel 2007+, Attached sheet will also helpful for you.
On Sat, Jul 21, 2012 at 4:38 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
Need another help to count and sum data between two fixed dates.
Regards
Santosh
Hi,
Need Help on Vlook Up in Excel 2007:-
A Case is assigned to Person 1 (Column B) ...As a back up it is sometimes
assigned to Person 2 (Column C)
So if Case ID is in Column A , there is always name of Person in Column B.
But only some cases are Assigned Person 2 in Column C.
I want to lookup
We want to use data validation... Please see the attachment
Ashok Maroti
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Solution Attached.
Regards,
Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-3054 Extn 1915
Email:
Hello Experts,
We have created a VBA form. When we have the form open, we are unable to
open any other Excel workbooks.
Is there any way where we can enable multiple instances parallel to VBA
form?
Thank you in advance.
Regards,
Sharath
--
--
FORUM RULES (986+ members already BANNED for
It's possible to do what you're asking, but it's not entirely necessary.
There is a property called modality.
What it basically refers to is the mode of the form you display.
If the form is modal then it is tied to the Excel workbook and must be dealt
with before anything Excel can proceed.
If
Hi,
I want to take backup of excel files periodically from some specified
path and to specified path, is there vba code for same.
Thank you
with regards
Raghu
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Sub Backup() 'kept in personal.xls assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir \Backup
BackupFile:
Here are some
sub backup()
With ActiveWorkbook
MyWB = .Path \BACKUP\ .Name
.SaveCopyAs MyWB
.Save
End With
End Sub
Sub Backup1()
FNAME = ActiveWorkbook.Name
Thanks Paul..
On 24 July 2012 21:38, Paul Schreiner schreiner_p...@att.net wrote:
It's possible to do what you're asking, but it's not entirely necessary.
There is a property called modality.
What it basically refers to is the mode of the form you display.
If the form is modal then it is
http://appscout.pcmag.com/your-questions/274021-excel-2007-can-t-save-as-dbf
http://www.dbforums.com/microsoft-excel/1644233-excel-2007-add-save-dbf.html
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Govind Mori
Sent: Tuesday, July 24, 2012 12:02 AM
To:
He was elected a year ago I think...
Should he rest in peace!
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
Thanks man.
He was elected in 2009 and was going to run for the 2nd term in Dec this year
The vice president has just been sworn in as President
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: bpascal123 bpascal...@gmail.com
Sender:
Have you tried managing your data with a pivot table?
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
Hi,
Have you thought about a pivot table before going coding a macro?
cells(i,j) notation is about 2 dimensional array. If you want to work any
values in there, you then need 2 loops. Now, you must know before hand
which direction you need to take, are you going by rows or by columns? This
is
dsum formula can help with transactions related to ledger accounts
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
As there is no data in column N of the Master sheet it is correctly
returning the value of a blank cell which is 0
Regards
David Grugeon
On 24 July 2012 21:16, Zibraan lucky60...@gmail.com wrote:
Hi Team,
Attached is the sheet but somehow its not working please help me
regarding this...
Team,
How to count a cell based on color .
file is attached for your's reference.
--
J.Gaurav
Call-7838594954
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
dear Jayendra
Pls find Attached Excel sheet for your ref
Regards,
Anil Gawli
On Wed, Jul 25, 2012 at 10:10 AM, jayendra gaurav wrote:
Team,
How to count a cell based on color .
file is attached for your's reference.
--
J.Gaurav
Call-7838594954
--
--
FORUM RULES (986+
19 matches
Mail list logo