View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Malinsky[_3_] Michael Malinsky[_3_] is offline
external usenet poster
 
Posts: 45
Default Updating distributed Excel applications

I have a VBA application that I've distributed to a couple of clients. Now
some changes need to be made to the worksheets to conform to various
regulatory requirements. These changes would need to be made to what could
be called "data" worksheets from which various "form" worksheets pull
information based on lookup (and other) functions.

Say, for example, I need to add a column to the middle of one of the data
sheets. Is it possible to do that programatically without destroying the
data so the client does not have to recreate the data?

TIA
Mike

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh