Another Excel VBA Question

[HaxSoft]

Could you submit a listing of the code that attempts to activate the work sheet? Maybe that would make it clearer to me what the exact problem is.

[royjacob]

Yea like he said, i could probably be able to help if the problem were more clearer

[DouglasAB]

Well I dont have any code that is doing anything at the moment. I was trying to use the macro recorder. Let me try to explain this.

I have a macro that the user starts that opens all the files in a specific folder. It creates a list of all the files opened, and then closes them.

The list it creates is used to populate a drop down menu. Which I am hoping to find a way to select a file name from, then click on a command button to re-open that file and perform some copy paste functions into the active workbook.

I cant figure out a way to get Excel to open the Excel file. The name of the file I want to open is listed as the value of cell AC1. I would like a macro that would look at the file name in that cell and open that file.

is this possible?

[HaxSoft]

This command opens whatever filename is stored in cell AC1:

Workbooks.Open Filename:=Range("ac1").Text

Is that what you needed to find out?

[DouglasAB]

Thank-you yes
that part works now..

Douglas

[HaxSoft]

Great, I am glad to hear that.

Now that you have my attention: Was there anything else?

[DouglasAB]

why yes there is something else. How would you go to a given cell on a workbook. the active cell is A1. the value of cell A2 is ac45. How would you go to cell AC45?

the value in cell A2 changes and I need the active cell to change to whatever the value of cell A2 is.

Any Ideas?

Douglas