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 derfloh 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: *

  • Users: ame12
  • Order by date
  1. ame12

    Bookmarking an Access query in your browser!

    From an earlier reply: easy way to set up remote MDB connectivity. Effectively, it lets you send a URL to a remote user - which they can bookmark - and when they plug the URL into their browsers, they can cut CSV, tab-delimited or XML versions of the database data. So it easily allows a user to...
  2. ame12

    Formula: days since sheet was last modified?

    Thanks. For a newcomer to Excel development (but pretty good at general software development) the distinction between a standard-code-module and a worksheet-code-module seems to be hidden from me. My email address is support@badblue.com - and again it is very much appreciated. And if you...
  3. ame12

    Okay, idiotic question: how to call a user-defined function

    I've defined a simple function in the VB editor: Function Test412() As Integer Test412 = 412 End Function When I try to call it in a cell as =Test412 or =Test412() or =Sheet1.Test412() or any other variant I can think of, I get "undefined function". I've tried defining the...
  4. ame12

    Formula: days since sheet was last modified?

    Arghhh... what's really strange about the cell's function call is that I used the formula builder to help me construct the right syntax. It shows me the correct user-defined functions (both sheet3's original and sheet1's equivalent). I choose either one and I get a "paperclip" error...
  5. ame12

    Formula: days since sheet was last modified?

    Still can't quite get it to work. Here's what I have in sheet3 (you have to save the modified-date of sheet1 in sheet3, otherwise you get a recursion/stack overflow): Sub SaveModifiedDate() ThisWorkbook.Worksheets("Sheet3").Range("A1").Value = Date End Sub Function...
  6. ame12

    Formula: days since sheet was last modified?

    RMikeSmith - almost have it working... i defined the functions in a new sheet ("sheet3"). i'm tracking sheet1 - all the labels have been changed to refer to sheet1. i defined the Worksheet_Change function in sheet1's worksheet-chnage event. however, when it runs, i get "compile...
  7. ame12

    Formula: days since sheet was last modified?

    RMikeSmith - and Larry - thank you so much for the code and link... I will try this asap and will post any results. Again, thank you for your incredible responses! ...!...
  8. ame12

    Installing MS Office on an application server

    well if you want full office capabilities without full installs, you can buy microsoft terminal server and then run the terminal client on each box. check out terminal server or citrix. if you just want to make the files accessible (e.g., automatically convert the documents or spreadsheets...
  9. ame12

    Formula: days since sheet was last modified?

    Dear M. Smith, yes - any detail you could provide as to how to do this would be very much appreciated. Thank you!
  10. ame12

    Formula: days since sheet was last modified?

    Howdy... is there a formula that will display the number of days since the sheet was last updated? I tried days360(today(),now()) days360(now(),today()) it just always displays 0 - any help would be great, cool, you name it!
  11. ame12

    Synchronizing Outlook Contacts

    Check http://www.intellisync.com (I think it's a free synch service that will sync Outlook with remote machines). =========================================== http://badblue.com/helpxls.htm Free small footprint web server for Windows Browse Excel shared workbooks over the web...
  12. ame12

    cc:Mail...

    CC:mail really is ornery and I don't know whether you can automate it via DDE or not. I wanted to sound one cautionary note: I've heard tell that CC:mail has many Y2K issues and that if you use it without predating your system to <1-1-2000, expect bad behavior and perhaps crashes...
  13. ame12

    automatic logon to IE from NT

    You can't retrieve a username and password from NT. No such API call (security risk, I suppose). If you're trying to specify the credentials for an external site, you can shell to something like: http://username:password@http://nasdaq.com ===========================================...
  14. ame12

    sending headers manualy

    Try this: <?php header(&quot;Status 200 OK&quot;); header(&quot;Content-type: text/html&quot;); ?> <html>... before you output any HTML! =========================================== http://badblue.com Small footprint P2P web server for Windows, File-sharing, PHP, wireless apps & more...
  15. ame12

    $PHP_AUTH_USER doesn't work

    Also, note that certain web servers don't support the $PHP_* built-in variables. For instance, IIS under NT would use $REMOTE_USER. =========================================== http://badblue.com Small footprint P2P web server for Windows, File-sharing, PHP, wireless apps & more...
  16. ame12

    Saving Excel spreadsheet ad .gif, .jpg, etc

    Wax, check out the screen shot here: http://badblue.com/helpxls.htm This lets you share Excel spreadsheets and Word documents (even password-protect them) over the web. Email me if you have any questions.
  17. ame12

    Wonderware???

    Also, check out Brooks Automation's FactoryWorks - it's supposedly the leader in high volume discrete control (e.g., semiconductor manufacturing) but applicable to lots of different discrete mfg apps. =========================================== http://badblue.com Small footprint P2P web server...
  18. ame12

    HTML not being served

    Check the file extensions properties on IIS. My guess is you have an extension that is not mapped correctly (e.g., .PHP not set up as either a CGI or DLL correctly). =========================================== http://badblue.com Small footprint P2P web server for Windows, File-sharing...
  19. ame12

    For IT newbies, which IT field is better?

    You've got a great background! My first reco is to learn SQL (either Oracle syntax, MySQL or SQL Server, depending upon what area you think you will go into - enterprise, messaging or SME, respectively). Where are you located? =========================================== http://badblue.com...
  20. ame12

    Programmer Question

    IMO, recommendation is to really know XML, parsing, SAX, DOM, XSLT, etc. This will be a good foundation for B2B, P2P and other data interchange solutions. It's also language agnostic - you can use it with C, C++, Java, PHP, you name it. ===========================================...

Part and Inventory Search

Back
Top