Forums / Setting Up Categories, Products, Attributes / mass way to add download file name...?

mass way to add download file name...?

Locked

Views: 833

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
29 Jul 2009, 3:12 AM
#1
durtdawber avatar

durtdawber

New Zenner

Join Date:
Jul 2009
Posts:
1
Plugin Contributions:
0

mass way to add download file name...?

I have zen setup with over 350 download products using easy populate. I also have added the 'download' attribute to all the products.

Is there a mass or fast way to all the download file name?

3 Aug 2009, 9:33 AM
#2
maxii avatar

maxii

New Zenner

Join Date:
Jul 2009
Posts:
14
Plugin Contributions:
0

Re: mass way to add download file name...?

you could use the folder look up which goes

'------------------------------

Function ShowFolderList(folderspec)

Dim fso, f, f1, s, sf, n

Set fso = CreateObject("Scripting.FileSystemObject")

Set f = fso.GetFolder(folderspec)

Set sf = f.SubFolders

n = 1

For Each f1 In sf

s = f1.Name

Cells(n, 2).Value = s

n = n + 1

Next

ShowFolderList = s

End Function

'Run this to get things started.

'x must have a valid path

Sub MakeTheList()

Dim x As String

x = "C:\Documents and Settings\user\My Documents\folder name"

Call ShowFolderList(x)

End Sub

or just concatenate in excel.