Copy worksheet from outside workbook using path located in cell

[freybe06]

Hello,

I have some code here that isn't working and I'm not sure why... I'm trying to copy a worksheet from an outside workbook (the path and filename are located in B2 and B3 of the "Info" tab. I keep getting an "Compile error: Expected: end of statement" message when it gets to the ":=" in the Set CopyFromWbk line.

Please Login or Register  to view this content.

If someone could help, that'd be great.

Thanks!

[JOHN H. DAVIS]

Does Range("B3") have a file extension?

[freybe06]

Yep. It's .xlsx and it's located in the cell with the rest of the filename.

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[freybe06]

I'm getting a "Subscript out of range" error for "Set CopyFromWbk = Workbooks(CashFile)"

[JOHN H. DAVIS]

Are you intending to add a workbook? Or does it already exist and your trying to open it?

[freybe06]

Both workbooks already exist. There is the CopyTo workbook (the one with the macro) and the CopyFrom workbook (the one that the macro opens up to take a spreadsheet from).

[JOHN H. DAVIS]

Then maybe using your first code.

Please Login or Register  to view this content.

You left off the .Open

[freybe06]

Thats giving me the "Compile error: Expected: end of statement" message on that line again...

[freybe06]

I think I got it... I ran in to a new issue where the worksheet was copying to the new workbook instead of the workbook with the macro, but I got around that by changing the order of the dimensions/sets. Here is what I'm using:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Glad to hear you found a solution!