VBA - Changing the username of a print job

[faniedt]

Hi everyone,

I'm new to this forum and mainly use C# and I am a bit stuck now with a VBA code (which I use for our Word templates and printing macro).

I have been following thread (http://www.vbforums.com/showthread.p...or-a-print-job) to change the username of a print job.

I am stuck in the sub SavePrintJobInfo() with buffer(3) = LPCSTR(.lpUserName). What is the purpose of the function/sub LPCSTR, as there are no declarations for it or any examples.

I figured that it is supposed to convert the string value (.lpUsername) into a long value as buffer is declared as a long array (Private buffer() As Long).

I tried the following, but I get a type mismatch error:

Private Function LPCSTR(str As String) As Long

LPCSTR = CLng(str)

End Function

I then changed it to LPCSTR = CLng(Val(str)), but now I get a "Subscript out of range" error.

Can someone please assist with this?

[westconn1]

http://www.vbforums.com/showthread.p...le-Please-Help!
see if post #9 can help you