Good morning,

I have another silly question. In a macro, is it possible to open a workbook without using the path name?

I get one sheet with data. This sheet will have a different name every day. I'll call this one NewSheet. From this I wish to transfer data to a fixed sheet, for which I do have a file path (FixedSheet). Moving from NewSheet to FixedSheet is easy, beacuse I can use the path, but how can I go back to the other sheet? There are no other workbooks open.

I have worked out an alternative, which is to save the NewSheet as TempSheet in a fixed location, replace the previous one and use that file path, but I am wondering if there is an actual command to do this.

Does anybody know?