Getting the user created file through dw.saveas()

1. I am exporting the data of a datawindow through dw.saveas(). I am not passing any filename to it, and hence the user has the flexibility to save it wherever desired and in whtaever name. How to get the path and filename of the resultant .xls file?
2. Even if I could lock the columns in the resultant .xls file, users can copy the contents to a new file. I want the copy menu item to be disabled, so that the contents can't be copied.
sisirpatAsked:
Who is Participating?
 
diasroshanCommented:
Hi,

1) Try using the following API to get the current directory,
Declaration:
Function ulong GetCurrentDirectoryA (ulong textlen, ref string dirtext) library "KERNEL32.DLL" alias for "GetCurrentDirectoryA;Ansi" //alias for "GetCurrentDirectoryA;Ansi"

Code:
ulong         lul_size = 260       /* MAX_PATH */
ulong         lul_Rc
String          ls_currentDir
ls_currentDir = Space ( lul_size )
lul_rc = GetCurrentDirectoryA ( lul_size, ls_currentDir )


Cheers,
Rosh
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.