Create a new workbook

[mc84excel]

Why am I getting a run time error on the first sub?

Please Login or Register  to view this content.

[AlphaFrog]

A Workbook is an element in the Workbooks collection. To create a new workbook within the collection requires using the .Add method. The New keyword doesn't add to the collection.

[mc84excel]

Please forgive my ignorance. I have two questions on your reply:

1. Is it possible to create a new Excel file/WB without adding to a collection?
2. When would you use New to create a new object?

[shg]

create a new Excel file/WB without adding to a collection?

Please Login or Register  to view this content.

[Norie]

Where would the workbook exist if it wasn't a member of the Workbooks collection?

[mc84excel]

Please Login or Register  to view this content.

I get a run-time error 53 File not found?

[mc84excel]

Where would the workbook exist if it wasn't a member of the Workbooks collection?

Of course. That was a stupid question of mine wasn't it?

[shg]

I get a run-time error 53 File not found?

Please Login or Register  to view this content.

You should install Help on your computer.

[mc84excel]

Please Login or Register  to view this content.

You should install Help on your computer.

That would create a new workbook as a copy of an existing workbook no? (I was after creating a new blank workbook).

[shg]

Then create someexistingfile.xlsx as an empty workbook.

It is surely possible to duplicate Window's ability to create a new .xxx document in a folder. If I learned how, I would make no attempt to remember it or write it down.

[mc84excel]

It is surely possible to duplicate Window's ability to create a new .xxx document in a folder.

I agree.

If I learned how, I would make no attempt to remember it or write it down.

Same here. I'm sticking to Workbooks.Add.