Re: writing to a users "My Documents" folder

perl -e 'print "$_ = $ENV{$_}\n" for sort keys %ENV;'
[download]

Run that. It will print of all your system environmental variables. Which includes the current users 'My Document' folder.

It should be noted, that if you are using Win32::OLE to create the excel file that simply saying

$Book->SaveAs('file.xls');
[download]

will save to the users My Documents folder. (The OLE object does not default to using your programs current working directory).

Comment on Re: writing to a users "My Documents" folder Select or Download Code

Replies are listed 'Best First'.
Re^2: writing to a users "My Documents" folder by Anonymous Monk on Sep 30, 2013 at 06:32 UTC
but if I want the excel to be saved in my current directory then how do I do?? PS: giving the path has not worked for me.	[reply]