Run-time error '13': Type mismatch

[celias]

Hello, brilliant people!
I am trying to adjust a file with macros that was previously built and I need some help, if possible. After making a few changes, I get the error mentioned above when running a macro.
When debugging, it points the Line 44: "SheetName = SheetNames(i, 1)"


The code is below.
Any help is very much appreciated. Thank you in advance for your time.

Please Login or Register  to view this content.

[WasWodge]

Cross-posted http://www.mrexcel.com/forum/excel-q...-mismatch.html

[celias]

Yes, I posted there too... However the presented solution didn't solve the problem. Would you have any other suggestion?

[WasWodge]

Have a read in both forums rules about posting links when cross-posting and in the other forum the link within the rules explaining why you should do this.

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[celias]

I clicked "Go Advanced" and then nothing happens when I click on the paper clip. A small white rectangle appears, but it doesn't give me a window to browse the file. I am using internet explorer. Could that be an issue?

Thank you.

[WasWodge]

The paperclip doesn't work at the moment, you need to click on Click on GO ADVANCED then scroll down to manage attachments. See the link below

http://www.excelforum.com/showthread.php?t=1130062

[celias]

I used the Manage Attachments link. Let's see if the file goes through...

[Norie]

Celias

There's 3 files in that zipped folder, what do we need to do?

PS I don't mean to unzip the files.

[Norie]

Actually, I think I might have found the problem.

When I run the code SheetNames is a single value not an array.

[celias]

The original file was working perfectly. I made a copy of the original files to another folder and started changing it to adapt this system to another company. I changed the names of the employees, the names of the clients and the location where the linked files are located (line 30).

When I changed the original Sheet Names to "Employee1", "Employee2", "Employee3", ... and made all the mentioned changes, the macro stopped working. I then reduced the list of employees names to just one to make it simple to test it.

Does this make any sense to you? Would you have any other suggestion that might help solving this problem?

Thank you.