Hi

I have misunderstood, and it is an excel file. When generating the report,
from AS400 system tne file is an attachement and a sheet name is allocated
each time it is run, ie, `OASISCSV(48). then next time `OASISCSV(49) etc.
This stopped the macro running owing to the sheet name when i defined a range.
It does run if i amend the sheet name to sheet1.
Is there an way of giving it any wild cards etc, say OASISCSV**** or
something, in the macro, to prevent it looking for the sheet1. Also the
shortkut cut does not operate, but selecting from tools/macro does?

All help is appriciated

Brian


BNT1 wrote:
it has excel in the top right hand corner
will take another look at when at work in the morning and try and get more
info

regards

There are no modules in a CSV file so can't tell what you're doing.

[quoted text clipped - 5 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200910/1