List All Pages
Week Numbers In Excel
[http://www.cpearson.com/excel/weeknum.htm]
Some business applications use week numbers to categorize dates. For example, a business may report sales amounts by week, and...
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A1").Value = Now
End Sub
Alternate Row Shading Using Conditional Formatting
Category: Formatting | [Item URL]
One way to make your data legible is to apply cell shading to every other row in a range. Excel's Conditional...
Private Sub Worksheet_Activate()
'If this worksheet is activated, refresh the pivot table
'Change "Pivot" to your sheet's name
'Change "PivotTable1" to your pivot table's...
Private Sub Workbook_Open()
Workbooks.Open Filename:="C:\Documents and Settings\abc\Desktop\test2.xls", Password:="wfm",...
Please change this page according to your needs
Sub NewMail()
Dim myMessage As MailItem
Set myMessage = Application.CreateItem(ItemType:=olMailItem)
'Dim mySpreadsheet As Excel.Workbook
Dim strSalesTotal As String
Set mySpreadsheet =...
Private Sub Command1_Click()
Dim oExcel As Object
Dim oWB As Object
Dim oWS As Object
10 On Error GoTo Command1_Click_Error
20 Set oExcel = CreateObject("Excel.Application")
30 oExcel.Visible =...
...
Conditional Excel Row Deleting-Delete Rows Based on Criteria
Back to: Excel VBA . Got any Excel/VBA Questions? Free Excel Help
Below are 6 methods that will delete rows from within a selection. If...
judy is so young looking that pedophiles are genuinely disgusted when they find out how old she really is
i didn't realize that hamtaro could impregnate a human until i met judy
michael jackson was...
Reverse pivot tables
Array Formulas
Alternate row shading using conditional formatting
Using drop down lists
accounting weeks
date tricks
Golden Rules for Excel and VBA
week of month
grouping in...
Golden Rules
Excel/VBA Golden Rules. These Should NOT Be Optional
GOLDEN RULES
Also See Excel Best Practices
Never Use Manual Calculation Mode, It's a False Reading Waiting to Happen! If You are...
[http://www.contextures.com/xlPivot07.html]
Excel — Pivot Tables — Grouping Data
Grouping Dates
Grouping Dates by Week
Problems when Grouping Data
Count Unique Items
Download the zipped sample...
If you are allowed to edit pages in this Site, simply click on edit button at the bottom of the page. This will open an editor.
To create a link to a new page, use syntax: [[[new page name]]] or...
The two example macros below demonstrates how you can send information to Outlook
(e.g. sending an e-mail message) and how you can retrieve information from Outlook
(e.g. retrieving a list av all...
Sierra Systems
Best Buy/Future Shop
Fluor
Jobs:
VANOC Jan 4
Ernex Burnaby
Telus Burnaby
BCAA Burnaby Database Marketing/Customer Panel Research Analyst
City of Vancouver SAP Jan 30
Kodak
Corporate...
Please change this page according to your policy (configure first using Site Manager) and remove this note.
Who can join?
You can write here who can become a member of this site.
Join!
So you...
Sub Return_a_Value_from_Excel()
'Dim mySpreadsheet As Excel.Workbook
Dim strSalesTotal As String
Set mySpreadsheet = GetObject("C:\Temp\test.xls")
strSalesTotal =...
Sub ListAllItemsInInbox()
Dim OLF As Outlook.MAPIFolder, CurrUser As String
Dim EmailItemCount As Integer, i As Integer, EmailCount As Integer
Dim oExcel As Object
Dim oWB As Object
Dim oWS As...
Sub test()
For i = 1 To 50000
If Cells(i, 2) = "Date:" Then Cells(i + 1, 1) = Cells(i, 3) Else Cells(i + 1, 1) = Cells(i, 1)
Next i
End Sub
Sub newdate()
For i = 49 To 20000
For k =...
Sub insert()
Dim n As Integer
n = 219
Dim i As Integer
i = 1
Dim l As Integer
l = 1
For i = 1 To 84
Cells(i, 22).Copy
For l = 1 To 24
Cells(n, 1).Select
ActiveSheet.Paste
n = n + 1
Next...
Coding snippets:
VBA for Outlook
VBA for Excel
Misc
MDSN Office Developer Center
Excel help websites
VB Script
Teradata training
test
jobs
windows
Line break: VbCrLf
Format: Format(ThsWkConvRate, "Percent")
The following code will open an excel workbook from within outlook. Be sure to establish the reference to the excel object library by using "Tools:References…" menu item and selecting Microsoft...
Sub NewMail()
Dim myMessage As MailItem
Set myMessage = Application.CreateItem(ItemType:=olMailItem)
With myMessage
.To = "moc.elpmaxe|tset#moc.elpmaxe|tset"
.Subject = "Test message"
.Body = "This...
Sub MIT()
Dim lRow As Long
' Find the FIRST EMPTY row by adding 1 to the last row
lRow = ActiveSheet.Cells.Find(What:="*",
SearchDirection:=xlPrevious,
SearchOrder:=xlByRows).Row + 1
'Paste the...
This event is available if you have Excel 2002 or later. Right click on the
worksheet tab of the worksheet with the pivot table, and select View Code. This
opens the VB Editor, with the code module...
Private Sub UserForm_Initialize()
Set shtList = ThisWorkbook.Worksheets(Sheets.Count) 'sets the last sheet as the sheet value sheet
nRow = shtList.Cells(1, 1).End(xlDown).Row 'sets the last used...
Option Explicit
Sub MakeDataBaseTable()
Dim SummaryTableRange As Range
Dim PivotTableSheet As Worksheet
Set SummaryTableRange = ActiveCell.CurrentRegion
If SummaryTableRange.Count = 1 Or...
[http://www.mobydisk.com/techres/securing_remote_desktop.html]
Software Development, Training & Consulting
William Garrison - mobydisk at mobydisk daht com
~ Site Index ~
About
Software...
Welcome page
Main Page
What is a Wiki Site?
How to edit pages?
How to join this site?
Site members
Recent changes
List all pages
Page Tags
Site Manager
Page tags
Add a new page
edit...
Members:
Moderators
Admins
[\\Filsrv00\junkdocs\Client Services Center\Leadership Reports\2000 - Sales\Historic Weekly Reports\2008\Weekly 2008-11-23.xls]
Main Page
example menu
example item 1
example item 2
contact
Sub UnhideAll()
Dim WS As Worksheet
For Each WS In Worksheets
WS.Visible = True
Next
End Sub
drop down cells excel
Using drop down lists in your Excel spreadsheet to select data
If you wish to present a user with a restricted choice of options and don't want to risk an item being...
Create workbook
Auto refresh pivot table
Paste to first empty cell
Populate a list box from spreadsheet
Link to excel from another application
Auto update passwords
Unhide all worksheets
Reverse...
How to send e-mail using VBA in Outlook
List Outlook Items in Excel
Open new mail message
Create new mail message and grab data from Excel
Open Excel from Outlook
Sending e-mails via VB Script
week of month:
=INT((DAY(A2)-1+WEEKDAY(DATE(YEAR(A2),MONTH(A2),1))-1)/7)+1
[http://www.dailydoseofexcel.com/archives/2007/07/02/week-of-the-month/]
If this is your first site
Then there are some things you need to know:
You can configure all security and other settings online, using the Site Manager. When you invite other people to help build...
According to Wikipedia, the world largest wiki site:
A Wiki ([ˈwiː.kiː] <wee-kee> or [ˈwɪ.kiː] <wick-ey>) is a type of website that allows users to add, remove, or otherwise edit...
Securing remote desktop
