Menu
While the code here is VBA, it should be directly transcribable to other languages and platforms. The core process is really just a reiteration of previously submitted answers but I thought it was important to demonstrate how to deal with ActiveWindow when you are not within Excel's own VBA. SaveAs FileName:=fn, FileFormat:=xlOpenXMLWorkbook If CBool(Len(Dir(fn, vbNormal))) Then Kill fn 'This is where the Freeze Pane is dealt withįn = CurrentProject.Path
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |