Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2007 convert one sheet into multiples sheets (for excel 2003Compatibility)
Hello everyone,
I am currently working on a research project and I am having issues converting an excel 2007 file with a single sheet (2000 columns) into excel 2003. I would like to break down the main sheet into multiple 256 columns sheets so that this file can be recognized as a excel 2003 files by this research software If anyone has any idea I would really appreciate |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2007 convert one sheet into multiples sheets (for excel 2003
I don't use 2007 but as an idea, you could try and copy data to new sheets. Not sure if I have got the logic righ but an approach like following may work for you: Sub SplitData() Dim NewSh As Worksheet Dim Col As Integer Col = 0 Application.ScreenUpdating = False Do Set NewSh = Worksheets.Add NewSh.Move After:=Worksheets(Worksheets.Count) 'sheet with data to be copied 'change name as required With ThisWorkbook.Worksheets("Sheet1") .Range(.Cells(1, Col + 1), .Cells(65536, Col + 256)).Copy End With NewSh.Paste Destination:=NewSh.Range("A1") Col = Col + 256 'loop 8 x Loop Until Col 2048 Application.ScreenUpdating = True End Sub -- jb " wrote: Hello everyone, I am currently working on a research project and I am having issues converting an excel 2007 file with a single sheet (2000 columns) into excel 2003. I would like to break down the main sheet into multiple 256 columns sheets so that this file can be recognized as a excel 2003 files by this research software If anyone has any idea I would really appreciate |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2007 convert one sheet into multiples sheets (for excel 2003 Compatibility)
Send it to me, I convert for you.
wrote in message ... Hello everyone, I am currently working on a research project and I am having issues converting an excel 2007 file with a single sheet (2000 columns) into excel 2003. I would like to break down the main sheet into multiple 256 columns sheets so that this file can be recognized as a excel 2003 files by this research software If anyone has any idea I would really appreciate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master Spreadsheet with Links to Excel 2003 and Excel 2007 Sheets | Links and Linking in Excel | |||
Convert Excel 2007 data forms to Access 2007 ? | Excel Discussion (Misc queries) | |||
Excel 2003 Workbook I want to convert to Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 to Excel 2003 (Split data to sheets) | Excel Discussion (Misc queries) | |||
How do I convert an Excel workbook that has mulitple sheets into . | Excel Worksheet Functions |