Saving a .xla File

[Sheldon Potolsky]

I have a .xla file written in VBA with a Sheet and Module. When I
selct the module, make changes to the VBA code and save, it tells me
that the .xla file is saved. However, when I do a search, the save
date of the .xla file has not changed. When I reopen the module, it
does reflect the changes I made. I need to share this with another
person and I'm pretty sure it used to save correctly to a network
drive, I'm confused as to what's going on now. I have a copy in my
PERSONAL.XLS and even saving that copy doesn't change the date though
the code changes are reflected. Any help/suggestions would be greatly
appreciated!!

Thanks, Sheldon Potolsky

 

[GS]

Sheldon Potolsky formulated on Wednesday :

I have a .xla file written in VBA with a Sheet and Module. When I
selct the module, make changes to the VBA code and save, it tells me
that the .xla file is saved. However, when I do a search, the save
date of the .xla file has not changed. When I reopen the module, it
does reflect the changes I made. I need to share this with another
person and I'm pretty sure it used to save correctly to a network
drive, I'm confused as to what's going on now. I have a copy in my
PERSONAL.XLS and even saving that copy doesn't change the date though
the code changes are reflected. Any help/suggestions would be greatly
appreciated!!

Thanks, Sheldon Potolsky

Try closing the file and see if the save date (ergo
DateLastModified) changes

 

[Sheldon Potolsky]

Sheldon Potolsky formulated on Wednesday :

I have a .xla file written in VBA with a Sheet and Module.  When I
selct the module, make changes to the VBA code and save, it tells me
that the .xla file is saved.  However, when I do a search, the save
date of the .xla file has not changed.  When I reopen the module, it
does reflect the changes I made.  I need to share this with another
person and I'm pretty sure it used to save correctly to a network
drive, I'm confused as to what's going on now.  I have a copy in my
PERSONAL.XLS and even saving that copy doesn't change the date though
the code changes are reflected.  Any help/suggestions would be greatly
appreciated!!

Thanks, Sheldon Potolsky

Try closing the file and see if the save date (ergo
DateLastModified) changes

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

I should've mentioned that I had closed the file(s) and the Date
Modified when viewing in Windows did not change.

Sheldon

 

[Sheldon Potolsky]

Sheldon Potolsky formulated on Wednesday :

I have a .xla file written in VBA with a Sheet and Module.  When I
selct the module, make changes to the VBA code and save, it tells me
that the .xla file is saved.  However, when I do a search, the save
date of the .xla file has not changed.  When I reopen the module, it
does reflect the changes I made.  I need to share this with another
person and I'm pretty sure it used to save correctly to a network
drive, I'm confused as to what's going on now.  I have a copy in my
PERSONAL.XLS and even saving that copy doesn't change the date though
the code changes are reflected.  Any help/suggestions would be greatly
appreciated!!

Thanks, Sheldon Potolsky

Try closing the file and see if the save date (ergo
DateLastModified) changes

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Apparently I never closed the file yesterday because it's working
correctly now. Thanks Garry!