Ii) use this directory in a Application.FileFind search. I) identify a directory using Application.GetOpenFileName() in single file mode. Right now I'm using a very cludgy workaround that goes like this: There are probably more elegant solutions, but I have a lot of ground to cover.Īnother one: Application.GetOpenFileName() always seems to fail for selecting multiple files. String1 = Right(string1, Len(string1) - InStr(string1, string2)) RevSearch = RevSearch + InStr(string1, string2) For this one I just created a new function to handle it under both Mac and Win:įunction RevSearch(ByVal string1 As String, ByVal string2 As String) As Integer the InStrRev() function is not recognized and gives a compiler error. UserForm.Picture = LoadPicture(picturename) Right now I have to use conditional complilation to avoid compiler errors: Haven't found any useful workaround yet although I've read that it's been fixed in Office 2004 SP1. The LoadPicture() method above hits me hard because I use it to update images in UserForms. (Yeah, I'm too cheap to get Office 2004 yet). Right now I'm converting Excel VBA code from Office 2000 to Office X on my new machine and hitting plenty of problems. OK, I'll make it 4 of us using VBA on Mac! Looks like we need some activity around here, so I have a few to add to the list when I remember them. Okay, somewhere MS has claimed "cross-platform compatibility". Range.Copy method doesn't Work from Userformĭeleted or renamed procedures corrupt module Text in Outline format prints as Bold (MSKB)ĭouble Underlines print as thick Underline (MSKB) "Smart formatting" doesn't format a range of date cells "Permission for this document is currently restricted" when opening XL03 files (MSKB) Pasting from XL04 to another application fails (MSKB) He lists some of the bugs/limitations related to XL 2004 and with discussions about each: Jim McGimpsey is a MS MVP and a Mac specialist.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |