Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RobBroekhuis

    Auto-percent formatting in Excel 2007

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

    Auto-percent formatting in Excel 2007

    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]
  3. RobBroekhuis

    Auto-percent formatting in Excel 2007

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

    Rewrite failure - clash with 303?

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

    dll subroutine suddenly awol

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

    Trouble with Array overwritting itself

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

    dll subroutine suddenly awol

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

    dll subroutine suddenly awol

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

    dll subroutine suddenly awol

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

    Selection accuracy in Excel charts

    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]
  11. RobBroekhuis

    Selection accuracy in Excel charts

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

    Find rows where foreign key invalid

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

    Find rows where foreign key invalid

    ...key (let's call it "genusid") does not exist as a primary key in a first table (let's call it "genus")? In pseudo-mySQL, what I'm after is select * from species where count(select * from genus where species.genusid=genus.genusid)=0 Thanks for any help - I suspect it's simple, but I've not...
  14. RobBroekhuis

    Ballooning Excel charts

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

    Ballooning Excel charts

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

    Excel graphs pasted into Outlook message are huge

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

    Getting my add-ins to run in Excel 2007

    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]
  18. RobBroekhuis

    Getting my add-ins to run in Excel 2007

    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]
  19. RobBroekhuis

    Getting my add-ins to run in Excel 2007

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

    Selecting record with closest key value

    So simple! Thanks much. Rob [flowerface]

Part and Inventory Search

Back
Top