Thanks to antville.org
Sunday, 13. April 2003
Insert filename in a Excel cell

The following formulas will include the filename, filepath and name in a cell in your workbook.
The application.volatile means that is will calculate everytime, just like a normal formula.
This way your filename will always be up-to-date.

Public Function ASAPFullFileName() As String
'i.e. [c:\test\file.xls]
Application.Volatile
ASAPFullFileName = ActiveWorkbook.FullName
End Function

Public Function ASAPFileName() As String
'i.e. [file.xls]
Application.Volatile
ASAPFileName = ActiveWorkbook.Name
End Function

Public Function ASAPFilePath() As String
'i.e. [c:\test]
Application.Volatile
ASAPFilePath = ActiveWorkbook.path
End Function

... Link (0 comments) ... Comment


One more JavaScript tip

Well, here's a cool tip to disable the ability to select text on a page.
Just replace your opening tag with this line:
(BODY onselectstart="return false")
Then check out your page. You will see that you can't drag across the text to highlight it.
This will help you if you don't want the users to copy the text from your website.

... Link (0 comments) ... Comment


Friday, 11. April 2003
What is piracy?

I think we have to define piracy, and I believe piracy to be the theft of intellectual property for commercial gain, at least in this regard. If you made a copy and gave it to your friend, why don't you give the original to your friend and keep the copy? There's absolutely nothing wrong with that whatsoever. If you buy a DVD, you are able to give it, sell it, rent it, do whatever you want with your property, are you not? The same thing would apply here. I wouldn't go along with the definition that piracy is making a copy of a movie and letting your friend watch it. That's not something that's going to impact Hollywood's revenue streams. We're talking about piracy, which is what the MPAA is claiming, that this product is being used for widespread piracy reasons. That's a completely false statement with no credible shred of proof.
- 321 Studios CEO Robert Moore

... Link (0 comments) ... Comment


Thursday, 10. April 2003
register globals in PHP

Create a file with the following code in it.

<?php
phpinfo ();
?>

Save it on your server and access it through a browser.
On my server it says..

Configuration
PHP Core

Directive Local Value Master Value
register_globals On On

Master value is the value set in php.ini.
Local value is a setting set with something else, a .htaccess file for example. You can create an .htaccess file with one of the following line in it...

php_flag register_globals on
php_value register_globals 1

Now next time you can access variable just by printing it to the browser..

print $username;

... Link (0 comments) ... Comment


Friday, 4. April 2003
Better Form submission

To add a helpful function to your form, you can include a contact email form that would submit an email to Manager with a subject line that starts with "Product Questions."
This would allow Manager to create rules in Outlook to easily sort emails having to do with Gnomedex.
The form posts to itself rather than a separate ACTION page.
This allows for elegant error handling.
For example, if you enter a question but LEAVE OUT your email address and submit it. You'll see an error, but if you look at the form,
you can see that your text is still there.
It didn't vanish when the missing data produced an error.
Obviously, the form is requesting a subject line, so I needed to prepend "Gnomedex Questions" to that string.
Here's the snippet of PHP code that allowed me to do that:

(?php

// Set the from address from the form
$fromaddr = "From: ".trim($emailaddr)."\n";

// Set the to address
$toaddr = "shantanuo@hotmail.com";

// Prepend Product Questions to the submitted subject value
$msgsubject = "Product Questions: " .stripslashes(trim($mysubject));

// Append the user's IP address to the message
$msgbody = stripslashes(trim($mymessage))."\n\nIP: ".$_SERVER["REMOTE_ADDR"];

// Send the email
mail($toaddr, $msgsubject, $msgbody, $fromaddr);

?)

... Link (0 comments) ... Comment


Sunday, 30. March 2003
How do I know about latest websites?

You can visit the page...
http://picks.yahoo.com/
Subscribe for the Daily or Weekly email deliveries while you are at it.

... Link (0 comments) ... Comment


Saturday, 8. March 2003
Advantages of Quickbase

  • Reduce your administrative workload as much as 80 percent.
  • Your entire team operates more efficiently from having round-the-clock, real-time access to a central source of account information.
  • Secure access from any location.
  • Faster analysis of the data collected.

... Link (0 comments) ... Comment


Tuesday, 4. March 2003
Excel tips

Shorcuts:

  • Ctrl + ~ Displaying formulas and values
  • Shift + Ctrl + ~ General Format
  • Ctrl + D fill Down one cell
  • Ctrl + Enter Fill Down selection
  • Alt + Enter Line break
  • Ctrl + Shift + * Select the current region
  • Ctrl + Shift + Enter Enter an array formula
  • F4 Repeat
Options you can change:
  • Tools - Options - Calculation - Precision as displayed
  • Tools - Options - Calculation - Iteration
  • Tools - Options - General - Standard Font and size
  • Tools - Options - View - Gridlines
Tips:
  • To enter text in formulas, enclose the characters in double quotation marks ="total for" & 1994 or (a1) would display the text "Total for 1994".
  • Hold down shift while dragging to insert. Hold down shift and control while dragging to insert and copy.
  • To change the reference Hit F4 within the formula to change the reference from Relative Reference, Absolute Reference, Mixed reference.

... Link (0 comments) ... Comment


Sunday, 23. February 2003
Antville Bookmarklet

Here is the bookmarklet that provide an interface for posting from "anywhere" into the story editor.
javascript:blog='oksoft';str='';if(top.frames.length==0)str=document.selection.createRange().text;void(location.href='http://'+escape(blog)+'.antville.org/stories/create/?text='+escape('&lt;a href="'+escape(location.href)+'"&gt;')+escape(document.title)+escape('&lt;/a&gt; ')+escape(str));
hence this could be a simple version of the desired antville bookmarklet...

... Link (0 comments) ... Comment


Monday, 17. February 2003
Google bloggle?

Google has bought Pyra Labs. Pyra Labs is the creator of the Blogger software and runs the blogger.com and blogspot.com services. In weblog fashion, founder Evan Williams reported the news on his weblog in the middle of the Live from the Blogosphere event.
This is one of the coolest things to happen internetwise in a long time.

... Link (0 comments) ... Comment


Online for 8131 days
Last modified: 10/13/24, 10:18 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
November 2024
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
October
Recent updates
Extract words Extract all incorrect
words in first.txt file and all correct ones in second.txt...
by shantanuo (10/13/24, 10:18 AM)
Remove hyperlink in LO writer
1) Select "Internet Link" from Character styles. 2) Right click...
by shantanuo (10/9/24, 8:09 AM)
Templates in LO writer 1)
File > Templates > Save as Template 2) Give it...
by shantanuo (10/9/24, 8:07 AM)
discretize continuous features You can
"discretize" or "bin" continuous features into categorical features. from sklearn.preprocessing...
by shantanuo (4/24/24, 9:33 AM)
User Defined Property You
can create User Defined Property in libreoffice writer. File – Properties...
by shantanuo (1/9/23, 8:52 AM)
Arranging Chapters in the Navigator
To use a custom paragraph style for a heading, choose...
by shantanuo (1/4/23, 8:26 AM)
Use focus mode using Android
phones Settings > Digital Wellbeing and parental controls. Tap your...
by shantanuo (1/1/23, 3:59 AM)
Embed Fonts in document If
you use a font that the recipient is unlike to...
by shantanuo (12/18/22, 10:07 AM)
Using Navigator in Writer To
open the Navigator, select View > Navigator, or press the...
by shantanuo (12/18/22, 10:06 AM)
More about hyphenation The settings
for Tools > Options > Language Settings > Writing Aids...
by shantanuo (12/18/22, 10:04 AM)
link or unlink template If
you are using Libre office then template changer extension is...
by shantanuo (12/16/22, 5:27 AM)
Finding Styles you can select
Edit > Find and Replace > Other Options > Paragraph...
by shantanuo (12/14/22, 7:17 AM)
regex in clac In LibreOffice
Calc, you can use function REGEX for e.g. Begins with...
by shantanuo (12/14/22, 4:40 AM)
Libre Calc tips Turn Off
Grid Lines If you want to turn off grid lines...
by shantanuo (12/13/22, 8:14 AM)
More about Styles You can
goto View - Styles and change "All Styles" to "Applied...
by shantanuo (12/13/22, 7:49 AM)
Page Break Before Every Chapter
If your chapter titles are using the "Heading 2" Style:...
by shantanuo (12/13/22, 6:36 AM)
View and print in different
color Displaying Color in LO but Printing as White Page...
by shantanuo (12/13/22, 6:26 AM)
Change Normal Template in Libreoffice
Writer 1) Open a new file and set your font;...
by shantanuo (12/12/22, 8:45 AM)
Short english words in Devanagari
The list of short english words written in Devanagari. #...
by shantanuo (10/5/22, 9:05 AM)
Card issuing banks CITI
Standard Chartered HSBC American Express HDFC ICICI AXIS INDUS IND Kotak...
by shantanuo (7/16/22, 4:46 AM)
Activate IAM Access To activate
the Activate IAM Access setting, you must log in to...
by shantanuo (7/12/22, 5:52 AM)
use cheat instead of man
wget https://github.com/cheat/cheat/releases/download/4.2.3/cheat-linux-arm64.gz gunzip cheat-linux-arm64.gz chmod 770 cheat-linux-arm64 ./cheat-linux-arm64 mv cheat-linux-arm64...
by shantanuo (7/4/22, 8:53 AM)
python module itertools list of
useful methods of itertools module. permutations combinations combinations_with_replacement zip_longest count...
by shantanuo (9/8/21, 7:50 AM)
wikipedia tools 1) Collection of
useful utilities https://wikipediatools.appspot.com/ 2) all history of a user https://xtools.wmflabs.org/ec/mr.wikisource.org/Shantanuo...
by shantanuo (8/20/21, 6:36 AM)
Duration/Term of Copyright In the
case of original literary, dramatic, musical and artistic works, the...
by shantanuo (8/20/21, 6:26 AM)

RSS feed

Made with Antville
Helma Object Publisher