I have a problem with Access97 security wizard: when I start it I get a message saying that I am currently connected as the network manager and if I will continue than the data base and all its objects will become unsecured.
What does this message mean ? Is it a problem or should I continue ...
If I understand correctly, the Personal.xls file is located on my computer. This means that if I move the Excel file to another directory on my computer, the macro would be found and activated correctly. But what if I copy the Excel file to another computer ?
When I assign a macro name to a user-defined menu item in an Excel workbook file, the macro name is assigned with the full path of the Excel workbook file name. The problem is that if I copy the Excel file to another folder and open it, the macro cannot be activated because the location points...
I need to find out whether a file which is actually a URL (i.e. it is located on a web-server) exists, from a VBA subroutine in Excel.
Any way to do that ?
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.