Thanks to antville.org
Tuesday, 5. October 2004
Date Formats in Headers / Footers

When Excel adds a date to a header or footer, the default appears in the “MM/DD/YY” format. You can change this formatting via the following example:

Sub Change_Format()
ActiveSheet.PageSetup.CenterHeader = Format(Now, "MMM DD, YYYY")
End Sub

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


Wednesday, 15. September 2004
Resatrting Windows

Resatrting windows is often necessary after installing an application or making other changes. You can do this in Windows 95/98/ME by selecting Restart from the Shut Down Windows box, holding down the Shift key, and clicking Yes. This performs a warm restart, much faster than a complete reboot.

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


Tuesday, 14. September 2004
Email Alerts

Google will send you email alerts when specific items are mentioned in the news or found on web sites. I have several alerts running. For example, I like to know when any Microsoft MVPs are mentioned on the web. So I have both a news and a web alert set for "microsoft" "mvp." Whenever new info is found, I get an email about it and a link to that information.
http://www.google.com/alerts

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


Friday, 27. August 2004
Simple Worksheet Auditing

These simple VBA routines will quickly highlight cells with formulas, constants, text, or errors. They're great for auditing worksheets.
Sub MapFormulas()
Cells.SpecialCells(xlFormulas).Interior.ColorIndex = 6
End Sub

Sub MapConstants()
Cells.SpecialCells(xlConstants, xlNumbers).Interior.ColorIndex = 6
End Sub

Sub MapText()
Cells.SpecialCells(xlConstants, xlTextValues).Interior.ColorIndex = 6
End Sub

Sub MapErrors()
Cells.SpecialCells(xlFormulas, xlErrors).Interior.ColorIndex = 6
End Sub

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


Outlook file email

Don't open Outlook to email a file. Just right click on the file, scroll to Send To, click on Mail Recipient, enter the recipient's email address, and click on Send.

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


Monday, 23. August 2004
image ascii convertor

Toogle is a Text version of Googles Image Search. It will fetch the first image on google image search result page and convert the image into a text layout. It seems that they have developed a software that will understand the colour shades used in the image and apply the same colour shade at the specific pixel point! Still in the beta stage, looks promising.
http://www.c6.org/toogle

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


Saturday, 21. August 2004
Official Gmail Notifier

The Gmail Notifier is a downloadable Windows application that alerts you when you have new Gmail messages. It displays an icon in your system tray to let you know if you have unread Gmail messages, and shows you their subjects, senders and snippets, all without your having to open a web browser. To use the Gmail Notifier, you need Windows 2000, Windows XP, or a more recent version of Windows.

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


Thursday, 19. August 2004
Image Host

flickr is the best image host service next to yahoo photos. Once you are a registered user, you can upload the photos by e-mailing it to the address given to you. You can also use the bookmarklet to post a photo that you see online. Once it's in your album, you can create sets and organize your photos. Use Tags in the description so that it will be easy to find the photos later. If you decide to publish your photos, you can give a URL to your friends or a RSS feed. Tag based RSS feeds are available as well! What's more, you can even post your photos on blogger or livejornal blog. It means you can turn any blog into a moblog - just like that!
http://www.flickr.com/photos/shantanuo/
neon RSS feeds here...
http://tinyurl.com/3sv2o

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


phpFlashMyAdmin

If you don't like phpMyAdmin becuase of it's framed design and page refreshes, then this user friendly, stripped-down version of phpMyAdmin tool is for you. You can even visually create foreign key relationships among InnoDB tables. All Flash source code is included. Believe me even my aunt can use it!
http://www.tufat.com/script.php?id_num=7

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


Wednesday, 11. August 2004
Resume templates

Recently I was asked to find good resume templates for word. I googled "resume filetype:dot" (without quotes) and found Word templates. You can preview the templates before downloading it to your computer. Choose "View as HTML" link next to search result.

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


Online for 8130 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