Copying from a closed Jira export csv file to an open Workbook

Thanks for helping me.

I have a wizzbang workbook with lots of code. I haven't yet figured out how to import directly from a Jira query to this workbook, but I have figured out how to take rows from a Jira CSV that has been copied to a worksheet called "Import", to the whizzbang worksheet with lots of features.

What I want to do is:
1. Export Jira to some File Name
2. Click a button which will ask for the Jira export file name
3. Macro in whizzbang workbook will copy all rows from Worksheet #1 in Jira export file to "Import" worksheet in whizzbang workbook


I know how to do steps 1 and steps 2, I just don't know how to do step 3.

I have googled this, and there are examples for copying from the open workbook to a closed workbook, but I haven't found how to copy from a closed workbook to the open workbook.

Also, the examples given here: http://access-excel.tips/excel-vba-copy-worksheet/ blindly copies worksheets to before and after existing worksheets. i don't want that. I want to copy [some worksheet] to an existing worksheet, not create new worksheets.

Thanks!!

When you copy from JIRA_export.csv to Import sheet in Wizzbang, will you be replacing all the content there, or adding it after the last row?

You code will be something like this (but not exactly like this--I would need more details). This copies sheet 1 of the JIRA file to sheet Import of wizzbang, replacing any data that is already there.

Please Login or Register  to view this content.

Here is the code I have so far

Please Login or Register  to view this content.

The code fails at the red part - can't seem to paste.

Originally Posted by 6StringJazzer

When you copy from JIRA_export.csv to Import sheet in Wizzbang, will you be replacing all the content there, or adding it after the last row?

You code will be something like this (but not exactly like this--I would need more details). This copies sheet 1 of the JIRA file to sheet Import of wizzbang, replacing any data that is already there.

Please Login or Register  to view this content.

Thank-you so much sir!!!! it works. And yes, the import will replace all contents.

Here is the completed code, modified for my use:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

Workbook does not have an attribute called FileString. This should not even compile.

I think what you want is

Please Login or Register  to view this content.

I think your problem is that when you ClearContents, it clears the clipboard and your Copy is lost.

Also you do not have to Select the destination before you paste to it. In fact, you can copy and paste all in one call.

I would do the rest of it like this:

Please Login or Register  to view this content.

We crossed in the mail. You still have one problem.

Please Login or Register  to view this content.

Do not use quotes around False here, and FileStr must be declared as Variant.