Variable Uses An Automation Type Not Supported In Visual Basic. Value of type type1 cannot be converted to type2. That line declares s r and f as variant.
Visual basic variable uses an automation type not supported in visual basic error dim s r f filename as string and there s the problem. Variable variablename is used before it has been assigned a value. If i create a blank workbook with nothing else loaded xlstart directory empty i have the following issue.
Value of type type1 cannot be converted to type2.
Variable uses an automation type not supported in visual basic. Cause of the error. This error will be caused by you trying to use a variable defined in a type library or object library that has a data type not supported by visual basic. Variable uses an automation type not supported in visual basic i thought my peers out there mysql fans naturally will benefit from this post.