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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- ame12
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
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...- ame12
- Post #14
- Forum: Microsoft: Office
-
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...- ame12
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
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...- ame12
- Post #12
- Forum: Microsoft: Office
-
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...- ame12
- Post #11
- Forum: Microsoft: Office
-
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...- ame12
- Post #9
- Forum: Microsoft: Office
-
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! ...!...- ame12
- Post #8
- Forum: Microsoft: Office
-
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...- ame12
- Post #2
- Forum: Microsoft: Office
-
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!- ame12
- Post #3
- Forum: Microsoft: Office
-
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!- ame12
- Thread
- Replies: 13
- Forum: Microsoft: Office
-
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...- ame12
- Post #2
- Forum: Microsoft: Office
-
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...- ame12
- Post #2
- Forum: Microsoft: Office
-
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 ===========================================...- ame12
- Post #2
- Forum: Microsoft: Office
-
sending headers manualy
Try this: <?php header("Status 200 OK"); header("Content-type: text/html"); ?> <html>... before you output any HTML! =========================================== http://badblue.com Small footprint P2P web server for Windows, File-sharing, PHP, wireless apps & more... -
$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...
