Posted to microsoft.public.excel.programming

Richard Leclezio Richard Leclezio is offline

external usenet poster

Posts: 4

Updating date

I am showing you a cross section of some code :

Sub Download_Nostros()
Sheets("Data").Select
ActiveSheet.Unprotect
Range("All_NOSTRO").Select
Selection.ClearContents
Workbooks.Open FileName:= _
"\\my_documents\downloads\P51GRPR-SEP15.xls"
Range("A1:K500").Select
Selection.Copy

How do I automatically update or change "P51GRPR-
SEP15.xls" to the next working day. Any help would be
greatly appreciated.

Richard

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
automatically updating a date	Pascale	Excel Discussion (Misc queries)	1	September 16th 08 05:23 PM
Updating with current date	Gloria Lewis	Excel Discussion (Misc queries)	0	February 26th 08 08:55 PM
date updating	Katie	Excel Worksheet Functions	1	August 17th 07 11:48 PM
updating date!	via135	Excel Worksheet Functions	3	February 23rd 06 05:31 PM
printing while updating date...	soundgarden	Excel Discussion (Misc queries)	1	November 1st 05 10:57 PM

All times are GMT +1. The time now is 02:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us