View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cool Sport Cool Sport is offline
external usenet poster
 
Posts: 21
Default Save a range to binary file (including its format)

Hi there,

I am doing something similar to the autoformat function in Excel. But I
want to save each set of format to a file that can be exchanged between
users.

Is this possible to save a sample range of cells (about 6 cols and 3
rows) to a binary file including the cell format information.

After that, the content of the file will be loaded into a range
variable. Formation information will be obtained from that variable.

Please give some ideas or sample code.

Best regards,

coolersport

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!