Using SessionVariable(LOGON_USER) in VBA Excel macro
 

I don't know the ASPTypeLibrary, but are not creating an object.

Dim oRequest as ASPTypeLibrary.Request
Set oRequest = CreateObject("ASPTypeLibrary.Request").

'etc....

So this code is designed to run on the webserver ?
IIRC MS do not support or advise running Excel in this environment.

NickHK

"Teresa E" wrote in message
...
I am trying to use sessionvariable("Logon_User") in the
ASPTypeLibrary.Request object in an Excel macro. I am getting the
run-time
error 91 object variable or with variable not set each time I try to get
the
logon_user. The code I am using is:
I tried to set the oRequest to new asptypelibrary.request but, an error
occurs.

Dim oRequest as ASPTypeLibrary.Request
With oRequest
myUserName = .ServerVariables("Logon_User")
End With

I cannot createobject("ASPTypeLibrary.Request").

Please help me with my syntax to retrieve the logon user (IE) name. I
don't
need the Environ("Username"). The user is logging in from a web page.

I have also created a user defined activex dll to retrieve the logon name.
This works in ASP but not in the macro.

Can this be done using a macro?

Thanks,

Teresa

Using SessionVariable(LOGON_USER) in VBA Excel macro
 

When using the CreateObject("ASPTypeLibrary.Request"), I get an error stating
cannot create library.

"NickHK" wrote:

I don't know the ASPTypeLibrary, but are not creating an object.

Dim oRequest as ASPTypeLibrary.Request
Set oRequest = CreateObject("ASPTypeLibrary.Request").

'etc....

So this code is designed to run on the webserver ?
IIRC MS do not support or advise running Excel in this environment.

NickHK

"Teresa E" wrote in message
...
I am trying to use sessionvariable("Logon_User") in the
ASPTypeLibrary.Request object in an Excel macro. I am getting the
run-time
error 91 object variable or with variable not set each time I try to get
the
logon_user. The code I am using is:
I tried to set the oRequest to new asptypelibrary.request but, an error
occurs.

Dim oRequest as ASPTypeLibrary.Request
With oRequest
myUserName = .ServerVariables("Logon_User")
End With

I cannot createobject("ASPTypeLibrary.Request").

Please help me with my syntax to retrieve the logon user (IE) name. I
don't
need the Environ("Username"). The user is logging in from a web page.

I have also created a user defined activex dll to retrieve the logon name.
This works in ASP but not in the macro.

Can this be done using a macro?

Thanks,

Teresa

Using SessionVariable(LOGON_USER) in VBA Excel macro
 

Teresa,
http://pubs.logicalexpressions.com/P...cle.asp?ID=227

But as you are working in Excel/VBA not ASP, I can't tell you how to do it,
as you do not have "GetObjectContext".

NickHK

"Teresa E" wrote in message
...
When using the CreateObject("ASPTypeLibrary.Request"), I get an error
stating
cannot create library.

"NickHK" wrote:

I don't know the ASPTypeLibrary, but are not creating an object.

Dim oRequest as ASPTypeLibrary.Request
Set oRequest = CreateObject("ASPTypeLibrary.Request").

'etc....

So this code is designed to run on the webserver ?
IIRC MS do not support or advise running Excel in this environment.

NickHK

"Teresa E" wrote in message
...
I am trying to use sessionvariable("Logon_User") in the
ASPTypeLibrary.Request object in an Excel macro. I am getting the
run-time
error 91 object variable or with variable not set each time I try to
get
the
logon_user. The code I am using is:
I tried to set the oRequest to new asptypelibrary.request but, an
error
occurs.

Dim oRequest as ASPTypeLibrary.Request
With oRequest
myUserName = .ServerVariables("Logon_User")
End With

I cannot createobject("ASPTypeLibrary.Request").

Please help me with my syntax to retrieve the logon user (IE) name. I
don't
need the Environ("Username"). The user is logging in from a web page.

I have also created a user defined activex dll to retrieve the logon
name.
This works in ASP but not in the macro.

Can this be done using a macro?

Thanks,

Teresa

Using SessionVariable(LOGON_USER) in VBA Excel macro
 

I talked with Microsoft and they stated that what I want to do is
unsupported. VBA is very limited.

"NickHK" wrote:

Teresa,
http://pubs.logicalexpressions.com/P...cle.asp?ID=227

But as you are working in Excel/VBA not ASP, I can't tell you how to do it,
as you do not have "GetObjectContext".

NickHK

"Teresa E" wrote in message
...
When using the CreateObject("ASPTypeLibrary.Request"), I get an error
stating
cannot create library.

"NickHK" wrote:

I don't know the ASPTypeLibrary, but are not creating an object.

Dim oRequest as ASPTypeLibrary.Request
Set oRequest = CreateObject("ASPTypeLibrary.Request").

'etc....

So this code is designed to run on the webserver ?
IIRC MS do not support or advise running Excel in this environment.

NickHK

"Teresa E" wrote in message
...
I am trying to use sessionvariable("Logon_User") in the
ASPTypeLibrary.Request object in an Excel macro. I am getting the
run-time
error 91 object variable or with variable not set each time I try to
get
the
logon_user. The code I am using is:
I tried to set the oRequest to new asptypelibrary.request but, an
error
occurs.

Dim oRequest as ASPTypeLibrary.Request
With oRequest
myUserName = .ServerVariables("Logon_User")
End With

I cannot createobject("ASPTypeLibrary.Request").

Please help me with my syntax to retrieve the logon user (IE) name. I
don't
need the Environ("Username"). The user is logging in from a web page.

I have also created a user defined activex dll to retrieve the logon
name.
This works in ASP but not in the macro.

Can this be done using a macro?

Thanks,

Teresa

Using SessionVariable(LOGON_USER) in VBA Excel macro
 

VBA is not limited, you are trying to do something the wrong way.
Think of a different method; maybe write a text file from ASP that can be
read in VBA ?

NickHK

"Teresa E" wrote in message
...
I talked with Microsoft and they stated that what I want to do is
unsupported. VBA is very limited.

"NickHK" wrote:

Teresa,
http://pubs.logicalexpressions.com/P...cle.asp?ID=227

But as you are working in Excel/VBA not ASP, I can't tell you how to do
it,
as you do not have "GetObjectContext".

NickHK

"Teresa E" wrote in message
...
When using the CreateObject("ASPTypeLibrary.Request"), I get an error
stating
cannot create library.

"NickHK" wrote:

I don't know the ASPTypeLibrary, but are not creating an object.

Dim oRequest as ASPTypeLibrary.Request
Set oRequest = CreateObject("ASPTypeLibrary.Request").

'etc....

So this code is designed to run on the webserver ?
IIRC MS do not support or advise running Excel in this environment.

NickHK

"Teresa E" wrote in message
...
I am trying to use sessionvariable("Logon_User") in the
ASPTypeLibrary.Request object in an Excel macro. I am getting the
run-time
error 91 object variable or with variable not set each time I try
to
get
the
logon_user. The code I am using is:
I tried to set the oRequest to new asptypelibrary.request but, an
error
occurs.

Dim oRequest as ASPTypeLibrary.Request
With oRequest
myUserName = .ServerVariables("Logon_User")
End With

I cannot createobject("ASPTypeLibrary.Request").

Please help me with my syntax to retrieve the logon user (IE)
name. I
don't
need the Environ("Username"). The user is logging in from a web
page.

I have also created a user defined activex dll to retrieve the
logon
name.
This works in ASP but not in the macro.

Can this be done using a macro?

Thanks,

Teresa