Windows(Filename).Activate

[c_mei83]

I write my macro like this...

Please Login or Register  to view this content.

but when come to :Windows(Filename).Activate"..it will pop out to debug wit error..."Subcript out of range"...any1 can help me...urgent!

it also not work with the filename without space....i did not open the file also during run...any idea?

[DonkeyOte]

A few points...

I wouldn't use Filename as a variable name ... GetOpenFilename will return a Full Path as required in the Workbooks.Open command whereas when using Windows(name) you require just the filename (as you use later for the other file)

... it's not clear whether the Rogin Pareto1.xls is the workbook in which the code resides ... I'm assuming it is... does the following help:

Please Login or Register  to view this content.

Note: when you open a workbook it immediately becomes the activeworkbook so you don't actually need to run the Activate command

[c_mei83]

seems no error but did not copy anything into the pareto rofin sheets...what is the problem?

[DonkeyOte]

With no knowledge of what resides in the file you're opening it's pretty hard to comment.

I would first suggest that you enter "a" into cell A1 on "Raw Data" sheet, run the routine... once the routine has run check to see if A1 on "Raw Data" sheet is still "a" ?