View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] halimnurikhwan@yahoo.com is offline
external usenet poster
 
Posts: 113
Default How to embed a macro in a flat file?

hi,

record a macro by --- Tools Macro Record New Macro
then press Alt + F11 then you'll in VBA session

I think you need to split the UNIX file into cells in excel ?!

rgds,

Halim

menuliskan:
I am creating a tab delimited file in UNIX environment. User use Excel
to view it. I need to run a macro so it will display correct page
break. However, I don't know how to embed the macro so the user will be
prompted to run the macro. Is there anyone that has an insight on how
to do it?
Thank you
-Cal