Hi,
I am new to Excel/VBA, working on a Mac, and have tried searching around for an answer, but even the answers I find that seem like they would help, have not. I'm selecting a row from my current workbook/sheet, copying and pasting it into a new workbook, saving that one row as a .csv file (that all works)...and then trying to close the new, open workbook and go back to the first one. I have tried variations of the .Close and I have tried setting variables for the active workbooks when the two different ones are active, but I keep getting an error on the close.
All of my code for this part is commented out because every attempt has failed, but the rest of the code for everything else will not work if I don't get this workbook closed and back to the original workbook. Below is what I've tried so far. I hope I've made at least some sense.
Thanks in advance for any help!
Bookmarks