ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Detect if spreadsheet is opened off the web (https://www.excelbanter.com/excel-programming/416000-detect-if-spreadsheet-opened-off-web.html)

guest

Detect if spreadsheet is opened off the web
 
is there anyway to detect if an excel sheet is opened off the web?
my requirement is to detect if excel file is directly opened from the web,
and if so, I need to provide a message to the user to save to the local
machine first.

any suggestions??

Barb Reinhardt

Detect if spreadsheet is opened off the web
 
You might check the workbook path and do something based on that.
--
HTH,
Barb Reinhardt



"guest" wrote:

is there anyway to detect if an excel sheet is opened off the web?
my requirement is to detect if excel file is directly opened from the web,
and if so, I need to provide a message to the user to save to the local
machine first.

any suggestions??


guest

Detect if spreadsheet is opened off the web
 
as path is different based on OS and browser settings, its not a wise
solution. can anyone think of better option.

"Barb Reinhardt" wrote:

You might check the workbook path and do something based on that.
--
HTH,
Barb Reinhardt



"guest" wrote:

is there anyway to detect if an excel sheet is opened off the web?
my requirement is to detect if excel file is directly opened from the web,
and if so, I need to provide a message to the user to save to the local
machine first.

any suggestions??


Barb Reinhardt

Detect if spreadsheet is opened off the web
 
Wouldn't you be able to tell if it's a local machine from the path?
--
HTH,
Barb Reinhardt



"guest" wrote:

as path is different based on OS and browser settings, its not a wise
solution. can anyone think of better option.

"Barb Reinhardt" wrote:

You might check the workbook path and do something based on that.
--
HTH,
Barb Reinhardt



"guest" wrote:

is there anyway to detect if an excel sheet is opened off the web?
my requirement is to detect if excel file is directly opened from the web,
and if so, I need to provide a message to the user to save to the local
machine first.

any suggestions??



All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com