split file

Hi, I wonder whether someone could help me please. I'm using the script below to split files into more manageable chunks. Sub SplitTextFile() Dim sFile As String 'Name of the original file Dim sText As String 'The file text Dim lStep As Long 'Max number of lines in the new files Dim vX...

Hi - I opened up my spreadsheet (call it "ABC") in Excel and the file opens up as several spreadsheets with a different file names ABC:1, ABC:2, etc I can't figure out what the heck is happening to cause this. Thanks, Brian

Hi, I am quite new to VBA but learning (slowly). I have a table in cells A20:CM520, the first 19 rows are instructions and a header which I wish to keep if possible. I would like to filter by column X and paste the visible cells (preserving their format) to a new worksheet for each name...

Hi, I am a newbie to excel, and many thanks in advance. I have a very large excel file, and I want split it into multiple files base on a column's value (say, column A), and I want the new files to use the values in column A as the file name (e.g. value.xlsx). Thanks a lot!

Excel 2010 -- Windows XP Pro SP3 History: I work for a company with 120 locations, each location has a 3 digit letter code. Up until yesterday I would get this massive excel report and send it off to all of our locations that showed them their appointment show/no show rate. Anywho today I was...