Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a successfully running Macro code which exports the Table Box data in QlikView into a Notepad at desired path mentioned in a Server/ Repository. (Below code).
Highlighted sections are path defined in the QVW.
Now I want to replace the path with something like - User's Desktop. User will click the button (to run macro), so that the table Box data can be exported in to their personal desktop from any environment.
function Export() {
var dt = new Date();
var yr = dt.getYear();
var m = dt.getMonth()+1;
var d = dt.getDate();
var hh = dt.getHours();
var mm = dt.getMinutes();
var ss = dt.getSeconds();
var vExportTime = dt.getYear()+((m<10?'0':'')+ m)+((d<10?'0':'')+d)+' '+((hh<10?'0':'')+hh)+':'+((mm<10?'0':'')+mm)+':'+((ss<10?'0':'')+ss);
var doc = ActiveDocument;
var vDocName = doc.GetVariable('vDocName').GetContent().String;
var vRootFileLocation = doc.GetVariable('vRootFileLocation').GetContent().String;
var vQVDs = doc.GetVariable('vQVDs').GetContent().String;
obj = doc.GetSheetObject("TB_Export");
obj.ServerSideExport( vRootFileLocation + vQVDs + 'Delete_' + vDocName + '_' + yr + m + d + hh + mm + ss + '.txt' , 1) ;
How to replace the existing highlighted path with User's Desktop path. Please suggest?
Hi Dicky,
Check this script to get Desktop path
set WshShell = WScript.CreateObject("WScript.Shell")
strDesktop = WshShell.SpecialFolders("Desktop")
wscript.echo(strDesktop)
Source:windows - What's the environment variable for the path to the desktop? - Stack Overflow
jagan,
Hey Jagan,
Thank you for the help here.
I am defining the path in the script itself with a variable and using the same variable in Macro.
Can your script somehow converted like that or in a JScript please? My whole above in JScript, so would be easy for that. ( can you help here Petter?petter-s)
Regards!
This piece of code will give you the desktop path.
set WshShell = WScript.CreateObject("WScript.Shell")
strDesktop = WshShell.SpecialFolders("Desktop")
Debug and check whether it is working properly.
Regards,
Jagan.
Thanks jagan for this.
But am not able to fit this in my existing JScript macro. This VB needs to be converted to a JScript format. A bit novice in JScript. Couldn't use the appropriate keywords.
Check for any converters available, some websites are there which converts from one language to another. Like Java to .NET etc.