Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What is your value of hwnd ?
This should be the Windows handle of the parents window, hence Application.hwnd. This only works in Excel 2002 and higher. In earlier versions, you should use the FindWindow API. NickHK "videor" wrote in message . .. I had done that. But based on your assurance that was what should be done, I did a little troubleshooting and found the problem: The call as you sent it was: (without quotes) "RetVal = ShellExecute(Application.hwnd, "open", FileName, vbNullString, "C:\", SW_SHOWNORMAL)" I changed it to: "RetVal = ShellExecute(hwnd, "open", FileName, vbNullString, "C:\", SW_SHOWNORMAL)" and that seems to work. Any reason not to do it that way? Thanks for all the help. bern "NickHK" wrote in message ... This is part of the Windows API. Excel/VBA know nothing about it, so you have include the declarations that I included, in the top section of the code module: Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long Const SW_SHOWNORMAL = 1 NickHK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding Jpegs in excel | Excel Discussion (Misc queries) | |||
Is there a way to hide JPegs in excel? | Excel Discussion (Misc queries) | |||
Inporting JPEGs | Charts and Charting in Excel | |||
jpegs in cells | Excel Discussion (Misc queries) | |||
transferring jpegs | Excel Discussion (Misc queries) |