Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
i have such a module: Function Picturedimensions(filePath As String) As String Set FSO = CreateObject("Scripting.FileSystemObject") If FSO.FileExists(filePath) Then strParent = FSO.GetParentFolderName(filePath) strArgFileName = FSO.GetFileName(filePath) With CreateObject("Shell.Application").Namespace(strPar ent) Picturedimensions = .GetDetailsOf(.ParseName(strArgFileName), 26) End With End If Set FSO = Nothing End Function and it is working fine but only at work. i get empty value at home (also win XP SP2, Office 2003, almost the same configuration). I checked paths, names, VBA references... and nothing helps.. i guess that there may be problem with windows scripting, but.. anyone experienced such a behaviour?? regards |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I noticed that problem is he
Picturedimensions = .GetDetailsOf(.ParseName(strArgFileName), 26) GetDetailsOf method returns null. antivirus check, firewall check, what else may cause this strange behaviour... Użytkownik "God Itself" napisał w wiadomo¶ci ... Hi, i have such a module: Function Picturedimensions(filePath As String) As String Set FSO = CreateObject("Scripting.FileSystemObject") If FSO.FileExists(filePath) Then strParent = FSO.GetParentFolderName(filePath) strArgFileName = FSO.GetFileName(filePath) With CreateObject("Shell.Application").Namespace(strPar ent) Picturedimensions = .GetDetailsOf(.ParseName(strArgFileName), 26) End With End If Set FSO = Nothing End Function and it is working fine but only at work. i get empty value at home (also win XP SP2, Office 2003, almost the same configuration). I checked paths, names, VBA references... and nothing helps.. i guess that there may be problem with windows scripting, but.. anyone experienced such a behaviour?? regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining Single Dimension to Multi Dimension Array | Excel Programming | |||
Can you dimension Range more than 1 way | Excel Programming | |||
3 dimension chart | Charts and Charting in Excel | |||
two dimension look up table | Excel Worksheet Functions | |||
Array transfer - 1 dimension v. 2 dimension | Excel Programming |