Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Object Orientation / atpvbaen.xla


begging for hints on 2 questions:

1: i did a little experimenting on xl97 formatting.

saving an empty worksheet results in a 13 kb file
saving a worksheet with the ENTIRE column marked with a different
color than default will result in 14 kb filesize (a mere 500 bytes
overhead compared to the empty file), but marking every SECOND column
with a single different color blows the file up to 1094 kb. evidently
a result of object orientated programming, which adds 16 bytes to the
individual object "column" resp. "cell" (strangely also to the
"unchanged" cells remaining in the default color. i assume, that excel
nevertheless assigns specific code to these cells priorly undefined)

so: do i have to assume, that excel assigns object code to a cell,
which remains the default, but is expressively assigned the default ?

to keep file sizes as small as possible: where can i get a hint, by
how many bytes excel files increases in size by special objects? do
all cell properties always have 16 bytes size/cell? or are there
exceptions? for example: how many bytes are used by conditional
formatting of a certain range ? some might argue, that in times of
100s of megabyte RAM this isn't a relevant question any more, but the
files from this special project might get real large and for certain
reasons i'm bound to spreadsheets the common user is accustomed to.


2: atpvbaen.xla

what is the use of GETMACROREGID(function) ?
where do i get the info for the correct calling convention from this
add-in without the proper password (which again raises the question,
why ms programmers are such fans of wildlife ;-))? )

vba-help does not include calls like hex2bin or bin2oct. do i overlook
any readme or hlp-file ?

totally happy with some useful links...

klaus


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pagesetup.Orientation need VBA routine to "Best Guess" Orientation [email protected] Excel Discussion (Misc queries) 3 November 10th 09 05:53 PM
atpvbaen.xla cound not be found MIRA Excel Discussion (Misc queries) 2 July 20th 07 12:46 PM
Atpvbaen.xls FilippoRotolo Excel Worksheet Functions 0 July 14th 06 05:47 PM
ATPVBAEN XLA [Number casual] Aristotele64 Excel Programming 5 April 12th 04 12:50 PM
ATPVBAEN.XLA!Random Call in Macro Frank & Pam Hayes Excel Programming 4 February 18th 04 08:20 PM


All times are GMT +1. The time now is 08:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"