You should download and install Office 2007 Compatibility Pack. It is free.
Here is the link to download :
http://www.microsoft.com/downloads/details.aspx?FamilyId=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
After installing this, you will be able to open file produced in office
2007.
Re
Thank you very much Harmeet!
Just curious to know whether we can done it through VBA coding? because i
suppose to apply this formula in all the checklists its around 50 workbooks.
Any ways thanks for your swift response!
Regards,
Sharma
On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh wrote:
> Hi
Dear Akhilesh Karna,
Thank you very much for your help.
On Thu, May 7, 2009 at 9:56 AM, Akhilesh Karna wrote:
> You can use the following code (slightly changed from original).
>
> Sub RedemptionsUSD()
>
> Dim ModelCash As Worksheet
> Dim CashFlow As Worksheet
> Set ModelCash = Wor
Dear Group,
1 reuested to u pls if u r reverting some one's query then pls save ur
attachment in XLS not XLSX,
i thing there are some Learner like me who havent excel 2007, if file in
XLSX format then we are unable to open
Regards
Harish Upadhyay
--~--~-~--~~~---~--~
You can use the following code (slightly changed from original).
Sub RedemptionsUSD()
Dim ModelCash As Worksheet
Dim CashFlow As Worksheet
Set ModelCash = Workbooks("Model.xls").Worksheets(1)
Set CashFlow = Workbooks("Model.xls").Worksheets(2)
Dim j As Integer
Dim c As Int
SQL Server has a windows based system easy to do there putting selection
creteria
On Wed, May 6, 2009 at 8:13 PM, Yu wrote:
>
> Hi Dear members,
>
>I need to extract some data from Database. For instance, I have
> such an column in a table. I wanna extract Jan1 ,Feb2 and records
> starting w
WHERE table.Cal LIKE 2009%
OR table.Cal = 'Jan1'
On Wed, May 6, 2009 at 10:17 PM, Harmeet Singh wrote:
> Use and operator as:
>
> WHERE table.Cal LIKE 2009%
> AND table.Cal = 'Jan1'
>
> I hope that solves the issue.
>
>
>
>
> On Wed, May 6, 2009 at 8:13 PM, Yu wrote:
>
>>
>> Hi Dear
Good. Glad to help.
> Date: Wed, 6 May 2009 05:22:51 -0700
> Subject: $$Excel-Macros$$ Re: VBA code to search a column for a string
> From: dsrmccl...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Dave,
> Thanks. With a little bit of tweaking that's just what I needed!
>
> Doug
>
> On
Thanks to all
On May 6, 7:19 pm, Harmeet Singh wrote:
> Instead of vba use conditional formatting, would be better.
> if u need help in conditional formatting for ur query then lemme know.
>
> On Wed, May 6, 2009 at 5:04 PM, xxx wrote:
>
> > I need help in writing this macro
>
> > if the cell c
Plz help me to crack the password for MS - Word.
Thanks and regards,
Kamal Gulati
On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte wrote:
> Install Ultimate Add-in attached along with the mail. Explore the options,
> I m sure you can break passwords of excel *worksheet* and *module*.
> In cas
You can use SUMIF function.
2009/5/6 Samir Agayev
> Dear Group members,
>
> In attached excel file, I have a little vba code.
>
> It gets data from Column B in Sheet2 to Column D in Sheet1 if Column D in
> Sheet2 equals Column A in Sheet1.
>
> The only problem occurs when the Items of Column D i
pls help me.
On Sat, May 2, 2009 at 9:46 AM, jayendra gaurav
wrote:
>
> Dear all
> Pls help me for below point.in attached file
>
>
> 1. When chage the calender year the data reamins same on that day. 2.
> Required daily task( TO DO) to be cary forward next day if not done/closed
> 3. Tas
Hi,
I need to hide a worksheet on closing the workbook.
I have tried doing this using Workbook_BeforeClose and also
Workbook_Open but these have not consistently perfomed this task.
When using Workbook_BeforeClose and closing the workbook using the
workbook x (not the excel x) the first time I
You will need to use the indirect formula, which converts an addres to
a reference
=indirect(b1 &c1)
Regards!
Fabio L. Lemos
cel.: 8122-1206
Em 06/05/2009, às 11:34, Yu escreveu:
>
>
> Hi dear all,
>
> For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
> has. Now B1 has
Instead of vba use conditional formatting, would be better.
if u need help in conditional formatting for ur query then lemme know.
On Wed, May 6, 2009 at 5:04 PM, xxx wrote:
>
> I need help in writing this macro
>
> if the cell content is empty fill it with Red
> if cell content contains "Y" the
Use and operator as:
WHERE table.Cal LIKE 2009%
AND table.Cal = 'Jan1'
I hope that solves the issue.
On Wed, May 6, 2009 at 8:13 PM, Yu wrote:
>
> Hi Dear members,
>
>I need to extract some data from Database. For instance, I have
> such an column in a table. I wanna extract Jan1
Hi
Try this,
If ActiveCell.Value = "" Then
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Else
If ActiveCell.Value = "Y" Then
With Selection.Interior
.Patt
Hi Yu,
Please use
=INDIRECT(B1&C1)
Please let me know if it helps.
Regards,
Andy
On Wed, May 6, 2009 at 9:34 PM, Yu wrote:
>
>
> Hi dear all,
>
> For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
> has. Now B1 has value"A", and C1 has value "1", I want D1 has the
> formula
Hi dear all,
For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
has. Now B1 has value"A", and C1 has value "1", I want D1 has the
formula "=A1"
It doesn't work when I type "=B1&C1" in D1... Can anyone gives
some shine on it?
I know how to do it in VBA..quite easy: ra
Hi Dear members,
I need to extract some data from Database. For instance, I have
such an column in a table. I wanna extract Jan1 ,Feb2 and records
starting with 2009
Jan1
Feb2
20081001
20091092
20091093
20091094
20091095
I know how to extract record
more tips on Command line:
start a new Excel session:
call "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"
"Q:\Summit\Prod\Excel\test.xls"
start a workbook in existing Excel session
call "Q:\Summit\Prod\Excel\test.xls"
But any one knows how to save or close or other manipulation on Exc
I need help in writing this macro
if the cell content is empty fill it with Red
if cell content contains "Y" then fill it with Yellow
if no "Y" and any content then fill it with Green
thanks...its urgent
--~--~-~--~~~---~--~~
-
Dave,
Thanks. With a little bit of tweaking that's just what I needed!
Doug
On May 5, 10:12 pm, Dave Bonallack wrote:
> Hi, try this code somewhere in your sub:
>
> With Range(A1:A1000)
>
> D = "Seed-BOD"
> Set C = .Find(D, LookIn:=xlFormulas)
> If Not C Is Nothing Then MsgBox "Samp
Hi Maulik,
Just press key F7 after completion of sentence - which is similarly for word
where you can replace or spell check.
Cheers
Surya
On Wed, May 6, 2009 at 12:11 PM, maulik desai wrote:
> Hi All,
>
> I want some tool or any idea that how we can change or correct the spelling
> which we wr
If you are using Excel 2003 you shoul access Insert>> Name >> Define then
you cal select varGroupSize and edit it.
If you´re using 2007 just goto Formulas >> Name manager
then you cal select varGroupSize and edit it.
Regards!
2009/5/5 Michael Fowler
> Thanks. My data is mostly larger than
You can also use wild card characters like *, ?
eg.
copy c:\*.xls to d:\ - willcopy all excel files from c drive (root directory
only) to d drive (root directory only)
or
copy c:\??art.xls to d:\ - copy all files which have any first 2 characters
but name should end with art and are xls type to
Hi for spelling check u can use F7 funciton key.
select the data and press F7 key it will cheque for spelling.
Regards
On Tue, May 5, 2009 at 11:41 PM, maulik desai wrote:
> Hi All,
>
> I want some tool or any idea that how we can change or correct the spelling
> which we write in excel (i wante
What does paracept and ceizg mean?
Thank you.
From: tinu...@baja.hu
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Sum
Date: Tue, 5 May 2009 23:37:57 +0200
Brilliant!
From:
excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of
Hi
For copying files from command prompt. First you have to determine
source and destination of a file.
for ex- D:/ramesh copy myfile.xls E:/naidu
through the above command myfile.xls file copy from d drive to e drive.
Thank you
Ramesh
On Tue, May 5, 2009 at 9:26 PM, yogesh yerawar wrote
Hi All,
I want some tool or any idea that how we can change or correct the spelling
which we write in excel (i wanted like word that if u write some uncorrect
word or wrong word ,ms word automatically uderline that word in Red & gives
us option when u right click for auto correct, related words et
Hi
Just open excel sheet then go to Tools > option > View > under Window
Options just remove the ticmark of *Row & column Headers then click ok & u
can find ur solution.
---
*
On Tue, May 5, 2009 at 11:31 AM, sha
Dear Group members,
In attached excel file, I have a little vba code.
It gets data from Column B in Sheet2 to Column D in Sheet1 if Column D in
Sheet2 equals Column A in Sheet1.
The only problem occurs when the Items of Column D in Sheet2 are not unique.
You can see there three 15-May-09. So it
32 matches
Mail list logo
