Parse date and time from one cell and paste it to another for all files in a folder?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Parse date and time from one cell and paste it to another for all files in a folder?

07-02-2014, 04:55 PM

charlesdh

Windows 7 32bit Parse date and time from one cell and paste it to another for all files in a folder?

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

HI,

If you are already putting the data in
B2 why don't you just have the data written to W1 instead of B2.
So no need for a "New Macro"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to format cell in order to display both time and date	SamyCode	Excel	3	01-22-2013 03:30 PM
Make table cell active add date count date	MelHerndon	Word VBA	3	01-21-2013 04:23 PM
Word Macro - change date in footer for all files in a folder	patidallas22	Word VBA	2	03-09-2012 08:14 AM
Add a period of time to a referenced "Time" cell?	derelyth	Excel	4	03-27-2011 04:31 PM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 AM.