Copy data from workbook selected in combobox (recieving object error)

**cadams** · 01-06-2017, 07:58 PM

I am trying to have my Workbook copy the data from another workbook. The workbook to copy data from is based on the selection from combobox1, which lists all open workbooks. After the selection is made, my macro to copy data will run.

When I run the macro, it opens the combo box and I select the data I want copied and click “OK”. After I click “OK”, it runs the sub named “ClearandPullStatsinArray1”. However, I get a “no object defined” error when it is running this sub.

I cannot figure out why. Screenshot below. Thank you for your help!

USER FORM:

Please Login or Register  to view this content.

IN ANOTHER MODULE:

Please Login or Register  to view this content.

**mike7952** · 01-06-2017, 08:17 PM

Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**cadams** · 01-06-2017, 08:26 PM

I tried that and got the error "Invalid attribute in Sub or Function" and it highlighted the word "Public" in the "ClearandPullStatsInArray1".

Please Login or Register  to view this content.

**mike7952** · 01-06-2017, 08:35 PM

Also need to change at the top of your code. Remove Public MyFile as Workbook from inside of your Sub ClearAndPullNewStatsInArray1

From

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

**mike7952** · 01-06-2017, 08:40 PM

Like this

Please Login or Register  to view this content.

**cadams** · 01-06-2017, 08:45 PM

Thank you for responding so quickly! I am new to VBA and I am still learning.

After I followed your steps above, it seemed to resolve the error in my "ClearandPullStatsInArray1" sub.

But now I have an error in my UserForm. It highlighted my code "MyFile = Me.ComboBox1.Value", and gave me the error "Object Variable or With Block Variable Not set".

Do you know what that could fix that?

Please Login or Register  to view this content.

**mike7952** · 01-06-2017, 09:53 PM

Not sure what you are trying to do in the CommandButon1.Click. You are closing the form? But same as the other. If you are setting the Workbook object with the Variable MyFile need to use Workbooks(.....)

Please Login or Register  to view this content.

**cadams** · 01-07-2017, 12:13 AM

I do not have any experience with userforms or combo boxes so I got my code for the Userform from this thread here. Does this help? Could you suggest some code to use if this is wrong for what I want.

**cadams** · 01-07-2017, 06:48 AM

I have figured it out. Thank you for your help Mike!

Copy data from workbook selected in combobox (recieving object error)

LinkBack

Thread Tools

Rate This Thread

Display

Copy data from workbook selected in combobox (recieving object error)

Re: Copy data from workbook selected in combobox (recieving object error)

Re: Copy data from workbook selected in combobox (recieving object error)

Re: Copy data from workbook selected in combobox (recieving object error)

Re: Copy data from workbook selected in combobox (recieving object error)

Re: Copy data from workbook selected in combobox (recieving object error)

Re: Copy data from workbook selected in combobox (recieving object error)

Re: Copy data from workbook selected in combobox (recieving object error)

Re: Copy data from workbook selected in combobox (recieving object error)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy data from workbook selected in combo box "object error"

[SOLVED] Object variable error with combobox

[SOLVED] Copy selected data from one workbook to another

ComboBox Value to use in VBA formula gets Run-time error 424 Object Required

Recieving the error "the object invoked has disconnected from its clients"

Open Workbook .Copy to Wb Causes Object Error 424

Copy selected data to Workbook on Desktop

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions