mywb

the code below should copy specified cells from open workbook and paste them into a new workbook and save it with yesterdays date. On first pass it opens a new workbook that doesnt have anything in it. On second pass it works. Any ideas? Option Explicit Private Sub CopytoNewWorkbook() Dim myWB...

Hello, I have this code: Dim myWB as string Dim ws as worksheet myWB = "myWorkBook.xlsx" I now want to refer to myWB as a Workbook object. In other words, I'd like do something like this: for each ws in my WB ... next s Any ideas how to accomplish this? Thanks! Dennis

At my Workplace which is a Home Office, running PC: Windows 10 Pro MS Office 2016, released via Office 365 Problem with: A specific MS Excel File (xlsm), that has been working perfectly fine since 2013. MS Office 365, has been on the machine for past 2 years. The Wb (lets say MyWB) is...