vba to open and save file on desktop

**Anil2007** · 01-30-2009, 04:35 AM

Hi

I need some help on the attach macro which get the file name on the directory mentioned wat i want is tht after getting the file name is that possible that the user have a option to open & save ( on any path) the file just by clicking on the file name

thnk

**mudraker** · 01-30-2009, 06:39 AM

You could use a Workbook_SheetBeforeDoubleClick macro

Any macro would need a method of being able to identify the path the file list was generated from.

At present you can run your file list macro multiple times & save the report to different sheets but you do not save the path so any macro to open a file will not know wehere to look for that file

**Anil2007** · 01-30-2009, 07:05 AM

Originally Posted by mudraker

You could use a Workbook_SheetBeforeDoubleClick macro

Any macro would need a method of being able to identify the path the file list was generated from.

At present you can run your file list macro multiple times & save the report to different sheets but you do not save the path so any macro to open a file will not know wehere to look for that file

Hi

Thank for reply but i am not so good in VBA can u please help me how i code my macro so that it can save the path and then give the option to user for save the file which user click

**ravishankar** · 01-30-2009, 08:07 AM

Hi
Save the attached file in the folder where you wish to list from. run the macro. it will ask for extention. (Say .xls) the output will be a list of files in col A with hyperlink so that when you click on them it opens the file.
Ravi