Delete a row in a different workbook

[enphynity]

I am trying to delete a row in a workbook, from another workbook. How do I go about getting access to the properties of one workbook from another?

[Leith Ross]

Hello enphynity,

To perform operations on another open workbook, fully qualify your object reference. Here is an example that will delete row 2 in "Book2" from code in "Book1".

Please Login or Register  to view this content.

If a workbook has already been saved, be sure to add the workbook's extension (.xls, .xlt, xlsx, etc.).

Please Login or Register  to view this content.

[enphynity]

Thanks a bunch! I have another question though. How can I use the file name given from the Application.getopenfilename function to use in the above code?

[Leith Ross]

Hello enphynity,

That's a broad question. Can you tell more about what you want to do?

[enphynity]

I want to allow someone to open 2 workbooks with the application.getopenfilename function, and then format data in the first book to import into the second book. I am avoiding putting code into the second book because it will be sent to people that may or may not be able to open it because of macro security issues. So basically one workbook will be one with all the code and the other 2 will be code free.

[enphynity]

bump.......

[Leith Ross]

Hello enphynity,

This macro will copy "Sheet1" of the main workbook (the one with the macro) to the active sheet of the workbook opened by the user.

Please Login or Register  to view this content.

[enphynity]

Thank you so much!

[enphynity]

Actually, I do have one more question. How do I go about putting the filename retrieved from the application.getopenfilename into the "Set DstWkb = Workbooks.Open(Filename)" line?

[Leith Ross]

Hello enphynity,

Sorry, that line should read...

Please Login or Register  to view this content.