Thread: Macros
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Macros

It sounds like you would need to create a workbook that open the
originalmake the changessaveclose

--
Don Guillett
SalesAid Software

"Rob" wrote in message
...
I have a quotation program with 4 saparate tabs along the
bottom. I've distributed this to over 200 customers, and
now I need to change prices on some items, about 24 on
each tab, total of nearly 100 prices to change. Can you
think of a systematic way to do this? Due to security,
only qualified customers get this program, so I don't want
to just post an updated .xls file on my web site. I was
hoping to distribute a macro or something that could
automatically find and change the selected prices. Can
anyone out there help me?? THANKS!!!!!