Macro to export the file from one machine to a different server with user name and password

[#1]

Hi All,

I have to export a table box as text file from qlikview.The export is working fine.

but i have to place the file in different server.

so i have to specify a username and password in the script in such a way that it can be accessed.

Please suggest.

the code which i am using

------------------------- 

'' Export QC Chart Routine 

''------------------------- 

'sub ExportChart   

'   

' output_dir="\\servername\06_DataTransfer\AD\" 

' Filename="DataFile.txt" 

' set obj = ActiveDocument.GetSheetObject("CH01") 

' obj.Export (output_dir & Filename) , "|" 

'end sub 

Br,

Reena

[Chanty4u]

may be

Sending Different Reports to Different Users

[ajaykumar1]

Hi,

Just my thought.

I think if you want to export txt file to other server, first we need to make availability of one network shared drive which will use for Export the text file

then import the same file whoever the user wants.

The shared path should provide access to appropriate users.

We need to involve some Network team also in this.

Am also waiting for more proper reply.

Regards,

Ajay

[marcus_sommer]

This could be done with a batch-file with a net use statement, see: How do pass user credentials with net use command? - TechRepublic. In addition this could be used in combination with Runas.

- Marcus