Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Add a function to web file Name
I am downloading a file daily from net.In order to automise this task I wrote
a code in my workbook.But filename is changes daily with current date.how to add a funnction to the code of filename.I wrote workbooks.Open Filename:= _ "http://www.nse-india.com/content/historical/EQUITIES/2005/DEC/cm02DEC2005bhav.csv" in this address 2005/DEC both changes on change of year and month and 02DEC2005 changes daily.how to incorporate this change of filename daily in my code |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling Text from Another File | Excel Worksheet Functions | |||
Issues with saving text file | Excel Worksheet Functions | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
Date & Time | New Users to Excel | |||
Weekly Transaction Processing | Excel Worksheet Functions |