MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell links through FTP secure server

Posted by Jamie on October 20, 1999 8:12 AM

I have a workbook that gets data from an FTP server that requires a username and password
which can be stated in the formula to link to the server and once the sheet
is protected the user cannot see this. But when used offline Excel brings up
a standard message to say that the link cannot be used and innocently gives
away the user id and password. I cannot seem to suppress or change this message box
any ideas?

Posted by Ivan Moala on October 22, 1999 3:30 AM

Not sure but Have you tried putting in
Application.DisplayAlerts = False
in your routine ???
Also if you use this then reset it to true
@ end of your routine.


Posted by Jamie on October 26, 1999 8:17 AM

Yep, tried that first - it tries to update links even before executing the auto_open macro.

By the way in Excel '97 you do not need to turn the alerts back on at the end, '97 now resets most commands like these at the end of a macro,
except the statusbar. You have to respecify even if you call a macro from a macro.

Posted by Ivan Moala on October 27, 1999 12:36 AM

Are you sure about this? (Admittedly I haven't really tried leaving this setting ) other wise
microsoft is incorrect (wouldn't be surprised :-) ) when it states;
Excel 97
The default value is True. Set this property to False if you don't want to be disturbed by prompts and alert messages while a macro is running; any time a message requires a response, Microsoft Excel chooses the default response.
If you set this property to False, Microsoft Excel doesn't automatically set it back to True when your macro stops running. Your macro should always set the property back to True when it stops running.

Note This behavior is different from previous versions of Microsoft Excel. In earlier versions, the DisplayAlerts property was automatically reset to True when the macro stopped running. If you have old code that relies on this behavior, you should change your code to explicitly set the property back to True at the end of the macro.