Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write Worksheet To Network Directory
I would like to output Sheet1 worksheet contents to a CSV file format to a certain network directory listed below. I would like the file name to be in the format listed below. Network directory: F:\Marketing\June07 File Name Format : LINKSYS_YYMMDDHH Today Today's File Name: LINKSYS_07100816 Please help me complete this task. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write Worksheet To Network Directory
On Oct 8, 5:15 pm, Joe K. <Joe wrote:
I would like to output Sheet1 worksheet contents to a CSV file format to a certain network directory listed below. I would like the file name to be in the format listed below. Network directory: F:\Marketing\June07 File Name Format : LINKSYS_YYMMDDHH Today Today's File Name: LINKSYS_07100816 Please help me complete this task. Thanks, Sub tester() Dim networkDirectory As String Dim fName As String networkDirectory = "F:\Marketing\June07\" fName = "LINKSYS_" & Format(Now(), "yymmddhh") ActiveSheet.SaveAs networkDirectory & fName, xlCSV End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unknown excel backup files created in network directory | Excel Discussion (Misc queries) | |||
How to change options for saving when old directory(network) gone | Setting up and Configuration of Excel | |||
Saving files in the same network directory takes too long time!! | Setting up and Configuration of Excel | |||
Populating listbox from network directory | Excel Programming | |||
Changing to Network Directory | Excel Programming |