Simple task: Open a workbook, copy a range, paste into another workbook

**fbonetti** · 04-21-2011, 12:35 PM

Hi everyone,

My macro skills have improved quite a bit since joining this site but I'm currently running into a problem that's driving me crazy. It's frustrating because the task is so simple and yet my code simply isn't working!

Here's what I'm trying to do:

1. Open Workbook2
2. Copy a range Workbook2
3. Paste range in original workbook

When I run the following code, nothing gets selected and nothing is copied. It's very strange because I've programmed similar tasks in VBA and never had a problem until now. Why does this not work??

Please Login or Register  to view this content.

**fbonetti** · 04-21-2011, 01:12 PM

Nevermind :D

I found the solution. The files I'm opening are in [Read-Only] format, thus not allowing me to copy or select cells. All I had to do was add "Editable:= True" to the first line.

Workbooks.Open Filename:="C:\Users\dasoftware\Documents\IHDA files\Complete\" & FilePath, Editable:= True

Simple task: Open a workbook, copy a range, paste into another workbook

LinkBack

Thread Tools

Rate This Thread

Display

Simple task: Open a workbook, copy a range, paste into another workbook

Re: Simple task: Open a workbook, copy a range, paste into another workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions