Variable Uses An Automation Type Not Supported In Visual Basic. My suggestion is set the option explicit on at the top of your code and force explicit declaration of all variables and check whether has variables not support by vb. If i create a blank workbook with nothing else loaded xlstart directory empty i have the following issue.
Why keep it a secret. 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.
Variable variablename hides a variable in an enclosing block.
Why keep it a secret. That line declares s r and f as variant. If yes no problem with the vb code. 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.
