![]() |
vba documentation and filefilter property on os x
hi to all,
I'm running microsoft office 2004 with vba 11.2 on a os x 10.4.5 Informed about the different handling on File I/O on Windows and Mac Office, I'm still curious where I could find some documentation about vba on os x. to be precise and to give an example: fName = Application.GetSaveAsFilename(initialFilename:="so mething.txt") works fine, but I'd like to force the user to choose 'save as text file' from the save as dialog box. therefore I tried various forms of: fName = Application.GetSaveAsFilename(initialFilename:="so mething.txt", fileFilter:="*.txt*) 'the fileFilter in all different shapes but as soon as I add the fileFilter parameter to the GetSaveAsFilename Excel crashes.. the official documentation tells me, that fileFilter:="TEXT" would be the right one.. but since Mac doesn't run on OS 9 anymore, nothing happens using that value. as far to the official documentation... does anyone know the solution to the above particular problem? does anyone know a source for a documentation for vba on os x? appreciated simon |
All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com