Recent content by Creto

xlbo, In regards to your first comment, I direct you to my first comment... "Thanks for the reply. Perhaps I have the syntax wrong..." which is exactly what the case was. I was incorrectly using the INDIRECT function *after* I had read the help file. Anyways, thanks for clearing up how I was...

xlbo, Thanks for the reply. Perhaps I have the syntax wrong, but I do not see how the Indirect function will perform what I am looking for. If there is a file named 20060515.xls and there is a cell, B5, that has the value 20060515, how can I make B6 reference the 20060515.xls file *using* the...

Just realized I only half wrote the last line how i wanted it... idealy it would be something like this... IF('[' & B2 & '.xls]TRACKING!$B$3="Org"','[' & B2 & '.xls]TRACKING!$C$3',0)

I'm not sure if this one is even possible, but if it is, it would make things a lot easier. I have a template that I use weekly and it summarizes category data from other spreadsheets during that week's time. Since the template is doing a week at a time, I have columns for the dates that...

It will function, just not reliably, and of course, it isn't supported. Also, if you do manage to get 8.6 installed, the free patch upgrade will not function on 2003.

ScriptX will do what you're wanting. http://www.meadroid.com/scriptx/intro62.asp

This may get you headed in the right direction, however, I do not know if you can use NEWID() in Access (you can use it on MS SQL). SELECT TOP 1 key, quote FROM Results ORDER BY NEWID() This basically generates a random unique identifier as an additional field and then sorts by...

Here's a little something I wrote that should do what you're looking for with a quick spot of error checking thrown in... <% Function numDaysMonth(intMonth,intYear) intMonth = cint(intMonth) If intMonth > 0 and intMonth < 13 Then Select case intMonth Case 4,6,9,11 intMaxDays = 30...

I ran the IIS Lockdown tool and in the process, it managed to reconfigure some settings and *after* that point, when I changed the Execute Permissions, the server responded correctly. So, problem solved.

Running IIS 5 on W2K. Did not have FrontPage Server Extensions installed and everything (all ASP pages, etc) ran fine. Installed the server extensions and then received 403.1 errors on the ASP pages. So I went in and changed the Execute Permissions on the root web directory to "Scripts and...

Shows what my mental state was at the end of yesterday that I didn't catch that either. Glad you found the problem.

If it's possible to have an error at i=0 and max "i" is larger than 0, then with your current for loop, it's going to overwrite the strReason. May want to change that line to: strReason = strReason + table(i).firstChild.nodeValue + "<br>"

What is the name of the variable you are storing the text to? And show me your now modified code.

<% .. nodataerror = "error.asp?error=nodata&reason=" & server.URLEncode(strReason) .. Response.redirect nodataerror .. %> Where strReason holds the value you want to pass

Good to hear. Thanks for the follow up and the star.