passing a dataset from one sub to another
Does anyone know how to pass a dataset from one sub to another. I populate a dataset in one sub and I am trying to send the dataset to excel in another. the dataset will populate fine and then when I click a button to send it to excel I get the object not set to reference an object error. Do I need to pass the dataset to this sub and if so how would I do this?