split excel rows into separate files

[weedeemer]

hello everyone

can someone help me with macro that splits excel document into separate files.
filename must be as first cell in the document (+ eventual text that can i add, that would be the same for all of the newly created documents)
i need *.xlsx output filetype


ie:

b5gq40.png

into:

32zt3du.png

(Hren Hrvoje.xlsx)
or
(Hren Hrvoje Street no1.xlsx)

and

21cwokw.png

(Lazar Bojan.xlsx)
or
(Lazar Bojan Street no1.xlsx)

etc...


thank you very much!

[JBeaucaire]

This should do that:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[weedeemer]

yes. that solves the actual question,
but, this is for my mother, who explained me the problem a bit wrong:

her actual problem is to c/p each name somewhere into some "template" document (ie. D5 cell) and c/p the number assigned with each name into another cell (ie D7) of that template.

and save each document as explained.

thanks!

EDIT: now i see that number is in wrong type that can't be used in formula. she needs only number, without anything past decimal dot. ie: 95.00(6.33%) --> 95 (integer)