I need a script to create alternate file types

[chadlmiller]

OK this is a two part question.
First, if I can creat a button to run a Macro fine or VBA fine; which would you recommend if the Macros security issues are different between Orgs using a templated Excel spreadsheet.

Second, what I need the macro/script to Execute.
I have a data template (DATA Sheet)that the staff will complete. Once it is complete, I have three "Hidden sheets" (H1,H2,H3)

I only want the staff to use the data template to fill in the data as required. Once they complete the data it is validated manually. Once that is complete, I want three buttons:
One will run a Script on "Select" call it "AB" the script should begin to "save as" sheet "H1" as a .txt text file. tab delimited.

Second will run a Script to "Select the Button" call it "nom" And when I have done so the script should begin to "save as" sheet "H2" as a .prn file

Third will run a Script to "Select the Button" call it "dat" And when I have done so the script should begin to "save as" sheet "H3" as a .prn file

Vista windows, and Excel 2007.

Any additional information you require let me know.

 

[AnotherHiggins]

First, if I can creat a button to run a Macro fine or VBA fine; which would you recommend

Which would we recommend between a macro and VBA? They're the same thing. An Excel macro is written in VBA.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.