Forum Home
Press F1
Thread ID: 27332	2002-11-20 06:07:00	Excel and renaming files	Mike (15)	Press F1

Post ID	Timestamp	Content	User
99800	2002-11-20 10:53:00	I suspect it could be done using VBA.	mikebartnz (21)
99801	2002-11-20 18:58:00	> Old name column A, new name column B, formula column > C reads: > > ="REN "&A1&" "&B1 > > Note spaces after REN and in " ". > > Copy down, then copy results and paste as values in a > sheet, save as text file called newames.bat. > > At the Dos command prompt get into the directory and > type newnames.bat and press <enter > > > Assuming everything is in one directory. Brilliant, Robo, just brilliant :D - pity I had some dupilcates in my spreadsheet :) I didn't fill my spreadsheet properly to start with (silly me cutting corners again) > Or am I missing something and being an utter twat? > robo. You're never an utter twat Robo (sucks up for some odd reason) Ah well, I guess I should get back to work... see you all tonight :p Mike.	Mike (15)
99802	2002-11-20 19:26:00	> pity I had some dupilcates in my spreadsheet I didn't fill my > spreadsheet properly to start with (silly me cutting corners again) AHA! I figured it out, and now it's completed. Thanks everybody :D Hmmm... Now I've got nothing to do for the next 4 hours (I guess that's how long it would have taken me to rename them all manually :)) What a team :D Mike.	Mike (15)
99803	2002-11-20 19:44:00	All part of the service, Ma'am. <doffs cap, and looks for the next story out there in PC land>	robo (205)
99804	2002-11-20 20:28:00	>>> <doffs cap, and looks for the next story out there in PC land> How about something on all the different types of work us PressF1ers are doing in the IT industry :p Mike.	Mike (15)
99805	2002-11-20 20:34:00	>How about something on all the different types of work us PressF1ers are doing in the IT industry >Mike. Mike wanna start a new post then??????????? .Clueless	Clueless (181)
1 2