For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:. Start the bit version of Microsoft Excel that is running on a Windows bit operating system. In each Declare statement, manually change the name of any parameter that is passed from "ms" to "millisecs. When you change the second Declare statement, Visual Basic for Applications 7. However, the report is incorrect because the line is in a section that only runs in Visual Basic for Applications 6.
VBA 6. Therefore, you can safely ignore the error message. Skip to main content. This browser is no longer supported. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Learn more.
Asked 11 years ago. Active 11 years ago. Viewed 51k times. FullName, ". Community Bot 1 1 1 silver badge. Add a comment. Active Oldest Votes. You can't nest a function inside a procedure. Thanks for taking the time to read the code and make sure everything is right; wise I code say my code was better, but never used Excel's VBA.
It is illegal to declare a function within a sub. Martin Broadhurst Martin Broadhurst 8, 2 2 gold badges 26 26 silver badges 34 34 bronze badges. Fionnuala Fionnuala Remou: There's no reference to "sFilename" in the code, don't think that'd work.
Blunder Do you forget that I wrote this function?
0コメント