Karthik,
The following will do the trick:
Set aRange=[define the range that contains the cells you wish to
clear]
For each aCell in aRange.Cells
If Not aCell.HasFormula then
aCell.Clear
End If
Next aCell
Best regards,
Justin
On Jan 2, 4:00 am, Karthik Naidu wrote:
> Hi all am new to this
Karthik,
The following routine will do the trick:
Set aRange=[Define the range you want to clear cells in]
For each aCell in aRange.Cells
next aCell
Best regards,
Justin
On Jan 2, 4:00 am, Karthik Naidu wrote:
> Hi all am new to this grp..
> Happy New Year.
>
> Query: in macros how it ca
t"
' which is incorrect behaviour and occurs even if the protection
password is "password"
set wkb = Excel.Workbooks.Open
("WorkbookProtectionPassword.xlsx", , , , "password")
I hope that makes things clearer for people.
Regards,
Wazza
On Jan 28,
Excel throws an exception if there is a password parameter AND
if the file has a workbook protection password (to stop changes to
structure and windows). This should NOT happen and doesn't happen
with the xls format file.
Regards,
Wazza
On Jan 23, 1:16 am, Paul Schreiner wrot
I have an application that opens Excel files and loads data into an
Access database. This app runs unattended and so I have to take
various precautions to ensure that Excel doesn't produce any prompts
that require human input.
One such situation is where a user decides to password protect the
fil
