Monday, June 16, 2014
How To Get Last Row in Excel VBA code
›
There are many programmatic way to find last row of data input, but the simplest is.... Dim LastRow LastRow = ws.Range("A1")....
Wednesday, May 21, 2014
Creating a file name as a Date stamp in a batch File
›
Source Code line Dir>C:\myFile_%date:/=%.log Output File Name myFile_05212014.log
Friday, April 25, 2014
VBA code for Outlook - Reply Mail With Attachment
›
May times it happens that you want to Reply some mail with attachment but when you click reply, it removes the attachment from your mail, a...
VBA code for Outlook - Forward Mail Without Attachment
›
May times it happens that you want to forward some mail without attachment that you received with attachments, and you need to delete manua...
2 comments:
Friday, January 31, 2014
lotus formula to Extract One Value from Text List.
›
Extract 1 Value from Text List: Normally when trying to extract a particular value from a text list, you would use Script and extract the ...
Saturday, January 11, 2014
Refresh Lotus Notes Document with LotusScript
›
Will work for Refreshing the document. Below script will (Open -> Edit - Save-> Close) the selected document from the view. Sub C...
Tuesday, January 7, 2014
Find and Replace a Line Break Character in EXCEL
›
When you want to create a line break (line feed) in a cell, you press Alt + Enter, to start a new line. You can put one or more line breaks...
‹
›
Home
View web version