Viewing excel data on a form

  • Thread starter Thread starter v_3kaths
  • Start date Start date
V

v_3kaths

I have an excel spreadsheet that uses macros and then exports info into
a csv file. How can I do this via a form instead of a spreadsheet as
the user interface of a spreadsheet looks messy.

Thanks.
 
Does the data have to be visible?

If not then you could do all the manipulation on a hidden sheet (or a sheet
that is not the active sheet) and inform the user about the progress of it
all
via the Excel statusbar.

If the data has to be visible then you could maybe use a listbox or a
listview
on a userform.

RBS
 
Back
Top