View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Excel sheet analyzer/generator

Sub NoToolsRequired()
ActiveSheet.Copy
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Tomasz Klim"

wrote in message
Hi
I need a tool, that can analyse existing Excel Sheet, and generate
Visual Basic 6.0 / VBA code, which in turn generate this sheet from scratch
(add new blank sheet, apply all changes).
I'm interested in column/row sizes, cell colors, borders, cell values,
and formulas. I don't need support for VBA.
Does anybody know such tool?