I need to save data to file by macro.

I have a small project that need to split one big file to splitted
files (by 50 Lines for file)
I read the data file to excel and need to write macro for splitting
I need the command for save to file (lines/rows)

Please help