Function call on left side of assignment must return Variant or Object.

[Venom_V]

so the code was created to export files from excel to text file( the program also makes the txt file)i have been trying to figure out this issue by myself for a couple of hours and i cannot figure it out, Sadly i cannot attach the excel file because it surpasses the upload limit so i copied the code here.Thank you in advance.

Please Login or Register  to view this content.

[sktneer]

Declare all the variables properly and use Long datatype instead of Integer for row and column variable.

To avoid the error you are getting, remove the "=" from the MsgBox line. That should be written as...

Please Login or Register  to view this content.

[Venom_V]

Thank you very much

[sktneer]

You're welcome!

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.


You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.