Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |