Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving each row of an excel file in separate excel files
Hi,
I have an huge size of excel file, it contains personnel list. I need to save each row of the file as seperate excel files. Could it be possible with using macro codes. Meanwhile naming for the new files, "A" coulmn can be used, it includes unique identification numbers with 6 digits. If someone have similar codes, could it be shared? Thanks for your help. ACAMCI |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving each row of an excel file in separate excel files
Have you thought of moving a database approach instead of "huge" number of
Excel files to work with ? NickHK "acamci" wrote in message oups.com... Hi, I have an huge size of excel file, it contains personnel list. I need to save each row of the file as seperate excel files. Could it be possible with using macro codes. Meanwhile naming for the new files, "A" coulmn can be used, it includes unique identification numbers with 6 digits. If someone have similar codes, could it be shared? Thanks for your help. ACAMCI |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving each row of an excel file in separate excel files
Hi Acamci,
I have an huge size of excel file, it contains personnel list. I need to save each row of the file as seperate excel files. So, if the data comprises, say, 10,000 rows, you wish to create 10,000 workbooks? May I ask why? What is your overall objective? --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto saving sheets from a workbook as separate files. | Excel Worksheet Functions | |||
Seeing Text File Names when Saving Excel Files | New Users to Excel | |||
Excel Saving to Temp File for files on network | Excel Discussion (Misc queries) | |||
Open Separate Excel Files in Separate Windows | Excel Discussion (Misc queries) | |||
Open Excel files in separate sessions, not just separate windows? | Excel Discussion (Misc queries) |