ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Path\File name length problem Excel Crash on save as (https://www.excelbanter.com/excel-discussion-misc-queries/21171-path%5Cfile-name-length-problem-excel-crash-save.html)

Datasort

Path\File name length problem Excel Crash on save as
 
I have a problem saving a file in code using:

thisworkbook.SaveAs

The problem is if the file and path length is greater than 150 then the
Excel app crashes. I have tried this over a network as well as a local drive.

Has anyone ever seen this problem?

Thanks in advance,

Stewart Rogers


All times are GMT +1. The time now is 03:20 PM.

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