Hi,
I urgently need help on this issue. I have written a vba program that is supposed to run different lines of code based on the conditions met. The code converts a .xlsx file to .xltm with additional features. The .xltm is used to create ,xlsm versions as and when required in the lab. Depending on the conditions, the .xltm file is created or the .xlsm file is activated. The code works beautifully from the desktop or My documents folders. However, if the .xlsm is stored to my folder or any other folder on the secure network server, it always starts with a warning regarding Macros and a button to choose if we wish to continue editing. Normally if the trust center is not fully enabled for Macros, this happens. However, even though the trust center is enabled on my PC on the network, I get this message when accessing my folder on the server. On clicking the continue editing button strange things happen. The .xlsm file, created on certain conditions from the .xltm file, now tries to create a .xltm file again! It is not supposed to do that. Clicking cancel makes it go to its normal opening screen and then behave peculiarly as given below.
The With and If condition opening lines are ignored and lines that are NOT supposed to run are executed, resulting in errors at several stages and the ultimate debug *** erro message with the only the End button enabled. Sometimes the error is 1004, sometimes it says With block error or Object missing error. However from the desktop or My documents folders no such error occur. Why is this happening? How do I get around this? Pls help ASAP. Thanks in advance.
11/06/2015
I find that the problem lines involve selecting a range or a sheet for some search, etc. With this line I get the error - Application defined or object defined error 1004
Modifications of the same line gives method Range of object _global failed.
How do I resolve this issue? The code works perfectly from the desktop, not from any server folder.
Thanks in advance.
Regds
Other options tried:
All fail on the network.
Bookmarks