I have a java script that was written by a tech friend of mine that executes a query on a networked database. I thought I could run it at the command prompt, but instead all that happens is the opening on the text file itself. I am not to technically inclined and need some guidance on how to...
Calling all gurus - Is it possible to get control of the macro list that appears in the XL Macro Dialog when a user chooses Tools>Macro>Macros? For instance, given ten users and ten macros in a given workbook can I restrict the macro list to a set of macros available, actually visible, so that...
Hello again, I thank everyone for their help. Here's the lowdown on what I've come to. I realize that there are a number of different ways to reformat a date and had actually many of them, all with success. I had written separate "sub" routines and got the reformatted dates without...
How can I disable the dialog window that opens when opening an XL workbook that contains VBA code? I prefer not to have the dialog display when the workbook opens.
I'm using XL but the VBA code I'm looking for should work in any app that supports VBA. While I'm not sure, I think there is an API function that returns the Regional Settings on a user's machine. I haven't found it yet.
Does anyone know how to get the Date Time settings on a user's machine? I need to get the D/T setting in order to pass the correct format to a routine so that it will run correctly where ever in the world (US, Eur, AP) the app is being used.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.