.save method for iSeries IFS file

I have an excel file that exists on an iSeries IFS file system.
I open the Excel workbook from iSeries IFS file system and I delete a column and then use .save to save.
I have .visible = true and I can see the Excel workbook from iSeries IFS file system open, delete the column I wanted deleted.

When the save happens there are no errors message. When .close happens the Excel workbook from iSeries IFS file system closes like expected.

When I copy the Excel workbook from iSeries IFS file system to my desktop PC the column I saw deleted remains in the workbook. However, when I went to open this file in Excel from my desktop I received an error message: "Office File Validation detected a problem while trying to open this file. Opening may be dangerous."

Being there were no error messages when .save happened I was looking forward to the file being saved correctly.

This post may be a long shot for the forum. I am new to VBA projects and there may not be that many folks out there with both iSeries IFS and VBA experience.
Any help would be appreciated.

Below is the code:
The sub I have been testing .save is "DeleteDWRColumn"
In the main excel workbook with these macros there is a path and file for an Excel workbook on IFS file system

Please Login or Register  to view this content.

To followup with a conclusion to this post. Many tests were done with trying to save a workbook that was opened from an iSeries IFS and many variations of results were produced. I have found that, being new to VBA, that there are many objects, methods etc. that effect the behavior of processing. No news for the guru. To summarize: A simple .save method finally did work and it seems this was due to our operations team granting the correct authority to the IFS. Up to that point the code that is now working was previously saving the file to many different locations. I had files saved to My Documents, current root directory, there were access denied messages in certain instances. I cannot explain all the behaviors of the .save and .saveas method, however it seems that once operations was able to grant authority to iSeries IFS I was able to save the workbook back to the IFS. This is not espcially helpful as far as a thourugh technical solution, however it does confirm that a workbook opened from an iSeries IFS can be modified and saved back to IFS.