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...
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...
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...
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...
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...
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...
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! ...!...
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...
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!
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...
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...
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
===========================================...
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...
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...
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.
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...
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...
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...
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.
===========================================...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.