Thread: array to access
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
sali[_2_] sali[_2_] is offline
external usenet poster
 
Posts: 24
Default array to access

"RB Smissaert" wrote in message
...
What I am trying to achieve is simply showing an array (a data table) that
is too big for the sheet.
Probably it is best to make this an optional feature for people with

Access
or otherwise show it
as a text file. Will have a look into an Access viewer.


just as idea, don't know how rich viewer functions you need,
but if your data file has fixed line length maybe to use pure file i/o
functions
to read in a couple of lines of text file and show them,
also to have simple controls for basic navigation, scroll up-down.

for example, i made a sub (based on raw file i/o) for reading dbf file much
larger than excel row count limit. this helps me to do the job without
having a need for any software except excel.
this comes from the old win3.1 days, but is still compatible!