Search results for query: *

This is driving me crazy. I have a workbook in Excel 2007 with a column where every time I make an entry, Excel decides to interpret it as a percent input. I enter 33.1, Excel puts 33.1% (0.331) in the cell. The cells in the column are all formatted "general", none of the adjacent cells have...

I'm trying to put a rewrite rule in place - for a specific file for now, to be broadened more generally when the specific one works. I have in plants/.htaccess: RewriteEngine on RewriteBase /plants RewriteRule ^AcantMolli$ AcantMolli.php A request for /plants/AcantMolli fails with a 404. If I...

I have an Excel macro that calls on a dll created in Fortran. The dll is compiled, and placed in my c:\winnt\system32 folder. Everything worked just ducky, until suddenly today I'm getting an error 48: "File not found: itmsgmod.dll". The file is where it has been all along; I recently recompiled...

Hi all, Something that frustrates me to no end is the way Excel 2007 doesn't allow me to select the item I want in a chart - for example, when a trend runs close to an axis, clicking on the trend selects the axis instead. Individually selecting two trends that run close together is often...

I have a database with tables of the older (not innoDB) type where I want to set up some checks on data integrity. What's the easiest way to return rows in a second table (let's call it "species") whose foreign key (let's call it "genusid") does not exist as a primary key in a first table (let's...

I apologize for the crosspost - I know some of you are more active in here than in the Office forum, where I haven't gotten a reply. My excuse is that the charts got generated using VBA [blush] I frequently compose email messages with embedded charts from Excel. My modus operandi has always...

I frequently compose email messages with embedded charts from Excel. My modus operandi has always been to create the chart in Excel (on a chart sheet), selecting and copying the chart, and then in Outlook doing a "Paste Special" into a message, choosing Windows Metafile as the format. The...

Well, my company decided to upgrade to Office 2007. Which means that all of my VBA add-ins, which defined custom menus and added items to standard menus, are just about completely non-functional. Can anyone point me to a good online resource to help me sort out a solution? A quick web search...

I'm looking for the syntax that will find the record whose key is equal to, or as close as possible but smaller than, the value sought. Can it be done in a simple query, or do I have to use a MAX of all that are <= to get this job done? Thanks in advance, Rob [flowerface]

I'm doing some URL analysis, and would like to know, for a particular request, not just IF the url redirected (which I can learn from $r->is_redirect) but also what the ultimate URL is for which the content was retrieved. I can do this via a sequence of simple_request calls and doing my own...

I'm sure this is done all the time, but I didn't manage to find a good example: I have two frames - one frame is for navigating through a set of static html pages. The other one contains a server-side scripted page, where notes about the static page are displayed (and can be updated). I'd like...

This is strange - I've been using a VBA routine to import CSV data from an external instrument into Excel for a long time. Recently, the software on the instrument changed, and the CSV has an additional column. I cannot find any other changes, at least not obvious ones. But while Excel will...

I've done the header("location: ...") thing many a time for a simple redirect. Now I'm looking for a way to have php do some preprocessing, change the POST data, and then redirect to a different url as a POST. How would I go about that? Rob [flowerface]

I'm trying to use PHP to pre-process form data, and send the processed data on to an external form, using POST methodology. I know this must be really easy, but so far I've not found how to do this. I've read about headers for content length, content type, and everything else - but where does...

I use js in a script to prepare input for an external form processor that uses UTF-8 encoding. My users want to input the information in a URL-encoded format, i.e. when they input "Amat%c3%b6rradio" into the form, I want to convert it to "Amatörradio". Is there a js function that will do that...

I have directory-level authentication set up for some parts of my website. Accessing pages within these directories requires me to log in (or face a 403), and my being logged in is reflected in the server logs, e.g. ##.27.156.146 - MyUserName [05/Nov/2004:10:12:02 -0500] "GET /play/auth.php...

Looking at my logs, I see that the page size returned for one of my main dynamic (php) pages varies by as much as 6000 bytes (for a 40000 byte max size). The page is database-driven, and the database is not changing. When I capture the html with "view source" from my browser, the pages are...

Looking at my logs, I see that the page size returned for one of my main dynamic pages varies by as much as 6000 bytes (for a 40000 byte max size). The page is database-driven, and the database is not changing. For all I can tell, the page is staying the same - at least what's presented to the...

Here's an odd persistent problem I'm having. I am working through Microsoft's paid tech service to help me with this, but I figured the collective expertise here may be at least as good :-) The problem is with workbooks that have macros using the solver addin. The VBProject has a reference to...

I have a workbook containing numerous function calls to an AddIn function, each of which takes some time to process. Since for the most part the inputs don't change, there is hardly ever a need to recalculate the majority of the cells. However, when I first open the workbook, Excel insists on...