ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Issue saving file in excel 97 SR2 (https://www.excelbanter.com/excel-programming/381026-issue-saving-file-excel-97-sr2.html)

S. Zahid

Issue saving file in excel 97 SR2
 
I would appreciate any help regarding the issue described below.

I experienced the following when I tried to update the file name (file
is opened on the network) based on a cell value, say "A1", during the
save event:

- if "A1" change then the file save works properly and file name gets
updated

- if "A1" does not change then excel crash

I also noticed that above happens when the Total characters in file
name (including path) 149. Excel doesn't crash when the characters
in file name =149 or <149

Has anybody experienced this behavior in excel 97 SR2?

Regards

S. Zahid



All times are GMT +1. The time now is 05:54 PM.

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