wrote in message oups.com
I have created a pivot report against a .CSV data file.

Everymonth I want to email the combination of the CSV file and the
Excel pivot report to our users. So once the user clicks on the zip
file it must save the CSV file in say c:\temp and then save the Excel
pivot report as well in c:\temp and the Excel workbook pivot report
start against the file in C:\temp

Please help with code how I can do this.

Hi Karen,

How about using self extracting cabinet file instead of zip file?
You can write desired post setup procedure in "Setup.vbs" at
the source folder.

See this post on microsoft.public.scripting.wsh
" Duplicate folder tree"


Some meaningless characters are included at the line using MsgBox
function, though.

--
Miyahn (Masataka Miya****a) JPN
Microsoft MVP for Microsoft Office - Excel(Jan 2005 - Dec 2005)