Thread: visual basic
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw[_2_] Keith Willshaw[_2_] is offline
external usenet poster
 
Posts: 15
Default visual basic


"mike allen" wrote in message
...
this is my interpretation so far:
a full (not an upgrade), used version of Microsoft Visual Basic 6.0 from
ebay for $150-200 will allow me to essentially use the same code i am used
to using in excel/vba, but i will be able to create stand-alone programs
that others can use w/out excel. it will have matix's/spreadsheets for
input and output, i assume.


No sir. Your user will need to have Excel installed. The Excel specific
functions
are accessed via the Excel object dll's and you cannot distribute them.

you mentioned "Excel-specific functions." what are those? vlookup,

match,
isnumeric, len, trim, count, counta are some of the functions i use often
in code. are these "Excel-specific functions?" thanks, mike allen


Any and all Worksheet Functions are Excel specific, this is very true
of Vlookup and Match which are reliant on values on the Excel
spreadsheet.

Keith