Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hot to change the Excel File Logo (VBA Project)
Hi, I made a vba project, and I want to change the Excel File Logo (Excel File Icon). to give a professional look of my vba program. How it is possible..... If any one knows pls send me reply. Regards. Shahzad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hot to change the Excel File Logo (VBA Project)
On Jul 16, 1:42*pm, Shazi wrote:
Hi, I made a vba project, and I want to change the Excel File Logo (Excel File Icon). to give a professional look of my vba program. How it is possible..... If any one knows pls send me reply. Regards. Shahzad I find the below procedure on the web, but its not working, pls check what is the mistake, if any one knows. ***************** This code shows you how to change the Excel icon: Declare Function GetActiveWindow32 Lib "USER32" Alias _ "GetActiveWindow" () As Integer Declare Function SendMessage32 Lib "USER32" Alias _ "SendMessageA" (ByVal hWnd As Long, ByVal wMsg As Long, _ ByVal wParam As Long, ByVal lParam As Long) As Long Declare Function ExtractIcon32 Lib "SHELL32.DLL" Alias _ "ExtractIconA" (ByVal hInst As Long, _ ByVal lpszExeFileName As String, _ ByVal nIconIndex As Long) As Long Sub ChangeXLIcon() Dim h32NewIcon As Long Dim h32WndXLMAIN As Long h32NewIcon = ExtractIcon32(0, "Notepad.exe", 0) h32WndXLMAIN = GetActiveWindow32() SendMessage32 h32WndXLMAIN, &H80, 1, h32NewIcon 'Icon big SendMessage32 h32WndXLMAIN, &H80, 0, h32NewIcon 'Icon small End Sub ************ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing MS Project File from Excel VBA | Excel Programming | |||
i have an excel file which i badly need for my project. the probl | Excel Discussion (Misc queries) | |||
Open a ms project file from excel using vba? | Excel Programming | |||
VBA Project still on the list despite the Excel File closed | Excel Programming | |||
Assigning the Help 4, *.HLP file for a project programmatically in a protected Project | Excel Programming |