Run Excel Spreadsheet with macros from the browser - Web Development Discussion Boards

OmegaMan15-Dec-05 9:41

15-Dec-05 9:41

The company I am working for wants its password field not to have more than two repeating alphabetic characters in a password. For example

aA3234

would be OK but

aAA3234

would fail (AA). How can I setup a generic regular expression to cach any repeating upper case alphabetic character and any lower case repeating character? I have found a brute force way to check but it is cumbersome..here is what it looks like

aa|AA|bb|BB|cc|CC|dd|.....

advTHANKSance

Re: RegEx issue repeating characters

OmegaMan15-Dec-05 11:10

OmegaMan

15-Dec-05 11:10

I figured it out thanks to searching some other postings....to match use this expression

([A-Z]|[a-z]|[\d]|[\W])\1

The group ( ) will group the target character, A or a or 1 or $
while the \1 tells it to look for the match found previous and if it is the same, bingo a match is born.

Inscrutable Type Mismatch Errors

Corbett Kroehler15-Dec-05 8:07

Corbett Kroehler

15-Dec-05 8:07

I've taken Charles Oppermann's wonderful address book command line VBScript (which works perfectly) and tried to adapt it to run inside a basic web application. I keep encountering ASP 0106 : 80020005 errors when I run the following. The method is identical to the way it's done in the command line .vbs so I can't figure out why my variable throws a type mismatch. Help!

= = = = = = = = = =<br />
<br />
<%@ LANGUAGE="VBSCRIPT" %><br />
<br />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><br />
<html><br />
<head><br />
<title>LDAP Lookup</title><br />
<style type="text/css"><br />
body, input, select, table, textarea<br />
{<br />
font-size: 9pt;<br />
font-family: arial;<br />
<br />
}<br />
<br />
.niceButton {<br />
	font-size : 9pt;<br />
	font-family : arial;<br />
	background-color : #eaeaea;<br />
	color : #333333;<br />
	font-weight : bold;<br />
	border-width : thin;<br />
}<br />
</style><br />
<%<br />
dim strPerson<br />
strPerson = trim(request.form("last"))<br />
    Set objADsRootDSE = GetObject("GC://RootDSE")<br />
        <br />
    strADsPath = "GC://" & objADsRootDSE.Get("rootDomainNamingContext")<br />
    <br />
    ' Wrap the ADsPath with angle brackets to form the base string<br />
    strBase = "<" & strADsPath & ">"<br />
    <br />
    ' Release the ADSI object, no longer needed<br />
    Set objADsRootDSE = Nothing<br />
    <br />
    ' Specify the LDAP filter<br />
    ' First, indicate the category of objects to be searched (all people, not just users)<br />
    strObjects = "(objectCategory=person)"<br />
    <br />
    ' If user enters "*", then filter on all people<br />
    If (strPerson = "*") Then<br />
        strName = "(sn=*)"<br />
    Else<br />
        strName = "(sn=" & strPerson & "*)"<br />
    End If<br />
    <br />
    ' Add the two filters together<br />
    strFilter = "(&" & strObjects & strName & ")"<br />
    <br />
    ' Set the attributes we want the recordset to contain<br />
    ' We're interested in the common name and telephone number<br />
    strAttributes = "cn,telephoneNumber"<br />
    <br />
    ' Specify the scope (base, onelevel, subtree)<br />
    strScope = "subtree"<br />
    <br />
    ' Create ADO connection using the ADSI OLE DB provider<br />
    Set objADOConnection = CreateObject("ADODB.Connection")<br />
    objADOConnection.Open "Provider=ADsDSOObject;"<br />
    <br />
    ' Create ADO commmand object and associate it with the connection<br />
    Set objADOCommand = CreateObject("ADODB.Command")<br />
    objADOCommand.ActiveConnection = objADOConnection<br />
    <br />
    ' Create the command string using the four parts<br />
    objADOCommand.CommandText = strBase & ";" & strFilter & ";" & strAttributes & ";" & strScope<br />
    <br />
    ' Set the number of records in the recordset logical page<br />
    'objADOCommand.Properties("Page Size") = 20<br />
    <br />
    ' Set the maximum result size<br />
    objADOCommand.Properties("Size Limit") = 20<br />
    <br />
    ' Sort the results based on the cn attribute<br />
    objADOCommand.Properties("Sort On") = "cn"<br />
    <br />
    ' Execute the query for the user in the directory<br />
    Set objADORecordset = objADOCommand.Execute<br />
    <br />
    If objADORecordset.EOF Then<br />
        strDisplayLine = "No records were found."<br />
    Else<br />
        ' Loop through all the returned records<br />
        While Not objADORecordset.EOF<br />
        <br />
            ' Display the row using the selected fields<br />
            strDisplayLine = objADORecordset.Fields("cn") & vbTab<br />
        <br />
            ' Check to see if telephone number field is null<br />
            If IsNull(objADORecordset.Fields("telephoneNumber")) Then<br />
                strDisplayLine = strDisplayLine & "(number not listed)"<br />
            Else<br />
                ' Retrieve telephone number and add to line<br />
                strDisplayLine = strDisplayLine & objADORecordset.Fields("telephoneNumber")<br />
            End If<br />
        <br />
            ' Advance to the next record<br />
            objADORecordset.MoveNext<br />
        <br />
        Wend<br />
    End If<br />
            <br />
    ' Close the ADO connection<br />
    objADOConnection.Close<br />
<br />
%><br />
</head><br />
<body text="#333333"><%=strDisplayLine%></div></html><br />

-- modified at 14:07 Thursday 15th December, 2005

E-recruitment

marmosha15-Dec-05 8:06

marmosha

15-Dec-05 8:06

Hello,
I need to design an e-recruitment project which I’m having difficulties in,
So please if anybody has an idea about such projects or knows how/where to get help, please let me know...
Regards

marmosha

Re: E-recruitment

Brian Van Beek15-Dec-05 9:33

Brian Van Beek

15-Dec-05 9:33

What are the requirements for this project. I'm sorry but "e-recruitment" doesn't give me a good enough picture to help you with. If you post some requirements, I'll try to help you.

Brian Van Beek
Inside this room, all of my dreams become realities, and some of my realities become dreams.
Just started a new blog, yeah! [^]

Re: E-recruitment

marmosha16-Dec-05 22:48

marmosha

16-Dec-05 22:48

Dear Brian Van Beek,
My project is about posting resume (CVs) online and saving them to a database, with vacancy to apply to.

marmosha

Regd. Printing html tables

DotnetProVan15-Dec-05 6:24

DotnetProVan

15-Dec-05 6:24

Hai,

How can I paginate the tables which is in the HTML page. For example if a table starts almost at the end of the page it should start in the next page when I print or preview.

I tried with page-break-inside: avoid; which doesn't work.

Thanks for any help.
DotnetProVan

Run Excel Spreadsheet with macros from the browser

DarkAngel78615-Dec-05 5:30

DarkAngel786

15-Dec-05 5:30

Hi,

I want to run an excel spreadsheet that contains macros off a web browser. I create a hyperlink to the excel spreadsheet. When the user clicks the link, the excel spreadsheet loads in the browser. When i click a button in the excel spreadsheet, it says object libary not found.

What can i do, to fix this, so that it looks for external referenced DLL's, xla's, etc, from the web server?

Opening a new Window from a Word Document in an IFrame

bwhittington15-Dec-05 4:35

bwhittington

15-Dec-05 4:35

I am having an issue with an IFrame at the moment. The IFrame contains a word document with a link inside of it and I need it to open up a new window when someone clicks on the link. I went to several different sources to figure out an anwser. I am using the Hyperlinks.Add property and it contains 6 paramaters. The last parameter is suppose to contain the target window or from the link is supposed to link to. From all the sources I have read I should be able to put a "_blank" in that parameter and should open a new window just fine. However this does not work. Any suggestions?

Brett A. Whittington
Application Developer

Re: Opening a new Window from a Word Document in an IFrame

Brent Lamborn15-Dec-05 5:06

Brent Lamborn

15-Dec-05 5:06

Just to clarify a bit..is the link inside the word document or just in the IFrame (but outside the word doc)?

"Half this game is ninety percent mental."
- Yogi Berra

If you can read thank a teacher, if you can read in English, thank a Marine.

Re: Opening a new Window from a Word Document in an IFrame

bwhittington15-Dec-05 5:40

bwhittington

15-Dec-05 5:40

The link is inside the word document.

Brett A. Whittington
Application Developer

shell32.dll file source code

ramialadwan15-Dec-05 2:33

ramialadwan

15-Dec-05 2:33

i want from any one to help in getting the full source code of shell32 or the code of creating user by the way mentioned below :

my computer---->right click------> manage ---->system tools--->local users and groups---->users----->go to right window appeared----> right click -------------> new user

rami adwan

creating user for windows from logon screen by using internet not intranet

ramialadwan15-Dec-05 2:25

ramialadwan

15-Dec-05 2:25

i am working in a project using java this project is to create users to windows from logon screen without using tools for active directory after logon to windows but not by intranet ,i.e. controling windows active directory over internet not intranet and from logon screen.

rami adwan

problem using dll on server

uktrips00715-Dec-05 2:22

uktrips007

15-Dec-05 2:22

Dear all
I m using a dll file in asp pages which generates an html file after processing.It's working successfully on local server.but when i Uploaded asp pages to actual server and register my dll file there at.now my dll file is not generating html file.it's on actual server.Could any body tell my why it is happening? and how to solvr it?
Thanks N Regards
Mr.Uttam Kumar Frown | :(

try to be the best... whereever you go,

Re: problem using dll on server

enjoycrack15-Dec-05 7:33

enjoycrack

15-Dec-05 7:33

Hi there,

Just wondering....
- is the registration of dll successfull on the actual server?
- what happen when calling the dll's function to generate html code there?

<< >>

Re: problem using dll on server

uktrips00715-Dec-05 18:27

uktrips007

15-Dec-05 18:27

I don't know what the problem is It got registered sucessfully,but it's not generating html file which it is generating on local server.

generally,while calling dll function, it perform search then create html file for the result.then from asp i m caliing this page.

Help me pls........

Thanks n Regards
Uttam Kumar
Sleepy | :zzz:

try to be the best... whereever you go,

Re: problem using dll on server

enjoycrack16-Dec-05 8:15

enjoycrack

16-Dec-05 8:15

is the html result file created?

<< >>

popup window

priti shetty14-Dec-05 19:30

priti shetty

14-Dec-05 19:30

hi, I had made a letter in frontpage and i have given a pop window script in that letter and it works properly but i try to eml that letter through outlook express the letter opens in my account properly but the popup window doesnt opens i have to email it to several clients pls. can u help me i need this problem to be solved as soon as possible

waiting for urs response
thanks & regars

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

send mail problem

morgan8514-Dec-05 15:18

morgan85

14-Dec-05 15:18

Hi,

I read the article submitted by Nathan Ridley entitled A versatile html form mail script for classic ASP.

I'm confused and really need some help! I've spent about 3 hours preparing my form and my email template and I'm unclear on how to change the .asp file.

The instructions say what are required changes, but I don't know where to make those changes in the .asp file or in my form file.

I can see in the asp file where it says:

dim redir, mailto, mailfrom, subject, item, body, cc, bcc, message, html, template, usetemplate, testmode
redir = request.form("redirect")
mailto = request.form("mailto")
cc = request.form("cc")
bcc = request.form("bcc")
mailfrom = request.form("mailfrom")
subject = request.form("subject")
message = request.form("message")
template = request.form("template")
testmode = lcase(request.form("testmode"))="yes"

and i'm guessing that that's where i make my changes, but i don't know what I'm supposed to put or where. Someone please help!!!!

My files are located at www.geeks-ink.com/Clients/kos/application.shtml and www.geeks-ink.com/Clients/kos/kodonnells-application-email.html (that's the template)

Thanks in advance for your time.

Morgan85

Re: send mail problem

enjoycrack14-Dec-05 19:18

enjoycrack

14-Dec-05 19:18

You might need to ask the author....or put the link to the article here....

<< >>

wwwroot$ - How do you change it?

gmhanna14-Dec-05 10:10

gmhanna

14-Dec-05 10:10

Hi, I know I changed the definition of wwwroot$ when I first setup my system but I don't recall how I did it.

Let me explain my configuration and what is happening.

I am developing on a W2K machine using VS2003.net. The webserver (MSP-WEBSERVER) is another machine running Windows 2003 Enterprise Server. Something happened to the webserver this weekend whenever it went to serve up a page it would get memory read errors and crash.

I reinstalled Windows 2003 Enterprise Server and now I don't remember how I had things configured. The Server has two drive partitions C:\ for the OS and D:\development for my development projects. Under development I have additional directories for each project. IE: MCP, Buydown, etc.

I have added D:\development as my default website and added a "Development" website as well and added MCP and Buydown as virtual directories under the Development website. I'm not sure this is how it was configured, maybe the virtual directories were attached to the default website, i'm not sure.

When I try to access the initial signon screen of the MCP project, it displays perfectly (http://dev.merchantsoftwareplus.com/mcp). I signon, click "Authorization" and I get a page can not be displayed (404 error). Looking at the project in VS, it says the path name for the authorization screen is: msp-webserver/wwwroot$/mcp/authorization.aspx. BTW, it took me all afternoon just to be able to open the project, so I'm still not sure I have IIS configured properly, as I'm not able to open other development projects and I haven't been able to create a project.

When I try to create a project it says: The Web was created successfully, but an error occured when trying to configure the application root for this Web. Web projects may not operate correctly without an application root. The returned error was: Active Directory Services can not find the web server.

When I try to debug my project I get an error message saying the project is not configured for debugging, yet it is.

I backed up the configuration of IIS before I reinstalled but once you install, it can't find the backup files. I didn't format either Frown | :(

- what good is backup if you can't restore it.

Any ideas on what I'm doing wrong and how do you configure this thing? Is there something that I can read?

*** UPDATE ***

I have moved the virtual directories under the "Default Web Site". This allows me to edit all of the projects, however I still can not debug. It says that I'm not a member of the debug group. I have tried adding just about every userid into that group and it still doesn't work. I even tried adding Everyone, still no go. Any ideas? This also did not improve the ability to create new projects.

Thank you,

Glenn

-- modified at 18:34 Wednesday 14th December, 2005

CreateObject ("Word.Application")

Rajkamal_dfine13-Dec-05 20:37

Rajkamal_dfine

13-Dec-05 20:37

I have using the CreateObject ("Word.Application") code to create a word document in my asp application, when I am using this I am always getting error like the following

Error is:
Microsoft VBScript runtime (0x800A0046)
Permission denied: 'Create Object'

Any one please help

N.Rajakumar B.E.,
Application Developer,

Re: CreateObject (&quot;Word.Application&quot;)

Guffa13-Dec-05 21:35

Guffa

13-Dec-05 21:35

Use Server.CreateObject instead of CreateObject.

---
b { font-weight: normal; }

Re: CreateObject (&amp;quot;Word.Application&amp;quot;)

Rajkamal_dfine14-Dec-05 17:37

Rajkamal_dfine

14-Dec-05 17:37

Dear,
I already tried with Server.Createobject it also throwing the same error
is there any other option

N.Rajakumar B.E.,
Application Developer,

Re: CreateObject (&quot;Word.Application&quot;)

uktrips00715-Dec-05 1:45

uktrips007

15-Dec-05 1:45

why don't u use dll file in asp page.make a dll file wich will call ms word. and use it in ur asp pages.

Thanks n Regards
Uttam Kumar

try to be the best... whereever you go,

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.