Pages

▼
Saturday, May 05, 2007

Visual Basic Get Screen Area

›
Windows API Get Screen Area Declare Function GetSystemMetrics Lib "user32" _ (ByVal nIndex As Long) As Long Const SM_CXSCREEN As L...
1 comment:

Retrieve the file properties - VBA

›
Sub Get_WorkBook_Properties() Dim oWB As Workbook ' Here is the program to retrieve the file properties. Set oWB = ActiveWorkbook '-...
11 comments:
Friday, May 04, 2007

Drag & DRop Files to Text Box

›
Show File Name in Text Box using Drag & Drop Private Sub TextBox1_OLEDragDrop(Data As DataObject, Effect As Long, Button As Integer, Shi...
2 comments:

Automaticaly Resize Text Boxes

›
Resizing Text Boxes Sub Initialize_TextBox() ' To automatically resize the text box set the AutoSize to True. This will resize the tex...

Primitive File Handling Functions

›
Copying Files/ Deleting Files / Moving Files Sub Moving_Files() Dim oFS As FileSystemObject ' Copying Files FileCopy "c:\temp\IamAS...
1 comment:

Check Workbook Attributes

›
Get File Attributes - GetAttr Sub Check_Workbook_Attributes() Dim oXL As Excel.Application Dim oWB As Workbook Set oXL = Excel.Application o...

Validate Dates

›
Validate Date between Ranges Sub Feed_Check_Date_Function() ' Date is within the Valid Range Check_Date "2007-05-...

Run Macro on Image Click

›
Tag Macro to an Image Sub Run_Macro_On_ImageClick() Dim sht As Worksheet Dim shp As Shape ' Use OnAction Property to set the macro that ...

Changing File Attributes

›
SetAttr Function - Modifying File Atrributes Sub Changing_File_Attributes() ' Using the SetAttr Function, We can set the file as read-on...
5 comments:

Choose the Right Value

›
VBA - Choose Function Sub Easy_To_Choose() Dim iGroupCode As Integer Dim sGroupName As String iGroupCode = 1 If iGroupCode = 1 Then sGrou...

Flip Shapes

›
Rotate Images - Flip Images Sub Flip_Shapes() Dim sht As Worksheet Dim shp As Shape ' Flip the Image - Turn the Image Upside Down Set sh...
1 comment:

Environmental Variables using VBA

›
Get OS Name / Get Windows Directory Sub Environ_Vars() ' Get Environmental Variables using VBA ' Get the LOGON SERVER sLOGONSERVER =...
1 comment:

Format Images

›
Format Images - Change Size of Images Sub Format_Image_In_Excel() Dim sht As Worksheet Dim shp As Shape ' Reduce the Height and Width of...

Compare Files by Date

›
Function to Find the Latest File Sub Exec_Get_Latest_File() File1 = "c:\temp\Sample.txt" File2 = "c:\temp\Sample1.txt" M...
1 comment:

Find Image Range - Excel

›
Format Images - Range of Image Sub Find_Image_Range_In_Excel() Dim sht As Worksheet Dim shp As Shape For Each sht In Sheets For Eac...
1 comment:

Get the File Size

›
File Size - VBA Function Sub Get_File_Size() File1 = "c:\temp\Sample.txt" MsgBox "The Size of the File is " & FileLe...
12 comments:

Removing Pictures from Spreadsheet

›
Delete Images from Spreadsheets Sub Delete_Images_From_Excel() Dim sht As Worksheet Dim shp As Shape For Each sht In Sheets For Each ...
4 comments:

Filtering Array Elements

›
Filtering Array Elements Most often there will be a neccesity to filter content from the Array. Filter Function comes as a blessing: Sub Get...
Tuesday, May 01, 2007

Visual Basic Command Line Arguments

›
Retrieve Command Line Arguments from a Microsoft Visual Basic or an executable program developed with Visual Basic from Command Line Sub Com...
2 comments:

Get Computer Name

›
Get Computer Name / Get User Name Environ$ can be used to retrieve information from an operating system environment variable Sub Get_Environ...
7 comments: