Activating a workbook you just opened

[Dante_Blake]

This strip of code is designed to open all .raw delimited text files in a folder, delimit them, and save them in another folder in .xlsm format. The script runs in a blank workbook and opens a text file one at a time in another workbook.

It gets as far as opening the first .raw file in the folder and then immediately failing. I am assuming that I am not properly activating the workbook I just opened.

Note that I cut some of the code out that isn't relevant to this question.

Please Login or Register  to view this content.

If my assumption is correct, how do I properly activate the workbook?

Thanks!

[Andrew-R]

Is it failing when it opens the workbook or when you try to activate it?

If you put a break-point in the code and step through which line generates the error?

[tlafferty]

I'd suggest modifying this line:

Please Login or Register  to view this content.

Change to:

Please Login or Register  to view this content.

My assumption is that Excel is looking for an object for the columns reference, in this case, a specified sheet.

[Dante_Blake]

That change got me past that line. However, I am having the problem that every cell, column, etc... command wants sheets(1). before it.

Is there a way to activate the sheet so that it assumes all commands are performed on that sheet without having to name it? Or is that not possible since I am running the code from a different workbook.

Thanks!

[Andrew-R]

What you could try:

1. Dim a workbook variable at the start of your procedure:

Please Login or Register  to view this content.

2. Modify your open line to be:

Please Login or Register  to view this content.

3. Change your activate line to:

Please Login or Register  to view this content.

4. See if it works.

[Dante_Blake]

Thanks for your suggestion but I was still getting errors. I went ahead and added sheets(1). to everything. I figure that's a good habit to get into anyway. The code runs fine, cycles through everything!

Thanks again!