Search results for query: *

In the workbook as I described it, there were text values in the first three rows. To see if these mattered, I just created a new column to the left of the one that was giving me trouble. Nothing in any of the cells. All formatted as general. Filling in numbers in the cells from the top down...

None whatsoever. Workbook saves as a .xlsx Additional information: Right now I'm getting around the problem by copying a (manually fixed) cell with the general formatting down into all cells below. Excel only auto-formats with percent when the cell is empty. Rob [flowerface]

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...

Nope. In any case, I was able to resolve the problem. Using a DLL export viewer, I found that indeed there were no subroutines being exported. I don't know why, but a "rebuild all" on the fortran end created a working DLL, where a simple build didn't work. Another note added to my "when problem...

Although I'm not entirely sure what you're trying to accomplish, it appears to me you want to use your counter variable (e.g., i or NBR_EE) as the array index, rather than the constant index 0. As written, the first element of the array (number 0) is written to (and on subsequent calls...

I'm not sure what you're suggesting, PHV. As far as I know, there is no reference involved - just a line of code: Declare Sub ITMSG Lib "itmsgmod.dll" (inp1 As Double, inp2 As Double, out1 As Double, out2 As Double, out3 As Double, out4 As Double, out5 As Double) and a subsequent call to the...

Afraid not. The location of the dll hasn't changed, the wintt\system32 folder is still in the system path. I'm suspecting it may be a problem in the DLL itself, even though there too nothing has changed that I'm aware of - but maybe a compiler setting got mangled? Not sure how to troubleshoot...

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...

xlhelp, I forgot you could do that - thanks for jogging my memory :-) Yeah, I know there are better charting packages out there, but I'm constantly interacting with the data in a what-if mode, so I really need the plot inside the tool itself. Rob [flowerface]

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...

Excellent! Now I just need to read up on the syntax so I understand what's behind that! Rob [flowerface]

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...

Well wouldn't you know, the fix was easy, if non-intuitive (arrived at entirely by trial and error): composing the message in Outlook in HTML format instead of in rich text format preserves the small size of the image. It appears that regardless of the native format, when pasting into a rich...

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...

Thanks strongm. That will be helpful for sure. I already feared that customization was partly taken away from me. I'll try to salvage what I can... Rob [flowerface]

Nope, not looking for something that will do everything for me. A site/page addressing VBA issues arising from the transition to Office2007, with some best practices, would be helpful :-). Rob [flowerface]

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...

So simple! Thanks much. Rob [flowerface]