Macro to create network path folder

[orchbelt00]

I'm trying to create a network structure where a series of daily exports are put into subfolders where the date is the subfolder name. I've got this running overnight by naming the Macro "AutoExec", but the folder naming isn't working.

I'm using Action "OutputTo"

Object Type: Table
Object Name: Table1
Output Format: Excel Workbook (*.xlsx)
Output File: ="\\network_path\" & format(now(),"YYYYMMDD") & "\Table1.xlsx"
Auto Start: No
Template File:
Encoding:
Output Quality: Print

I'm not very skilled with VBA (even though I'd love to learn), so a Macro would be great or detailed VBA would help.

Thanks!

 

[Mile-O]

Output File: ="\\network_path\" & format(now(),"YYYYMMDD") & "\Table1.xlsx"

Try taking the spaces out, assuming you haven't just put them in to make your path more readable:

Output File: ="\\network_path\"&Format(Date(),"yyyymmdd")&"\Table1.xlsx"