Recent content by nslemmons

Thanks Skip and Geoff. Skip, I'm not sure where to include this code. Can you point me in the right direction? Thanks, Nate

Thanks again Geoff. The first several fields are in fact text. So ADO doesn't import information verbatim? Is there a way to just copy the information and paste it into another sheet? Thanks, Nate

Thanks John!

Hi I poseted earlier this morning about a problem with a group of functions in Excel VBA. Geoff helped me out with that but I have discovered another problem. The macro is used to get data from an Excel workbook I select from a popup. It gets all of the information except for numbers. I'm not...

Hi I poseted earlier this morning about a problem with a group of functions in Excel VBA. Geoff helped me out with that but I have discovered another problem. The macro is used to get data from an Excel workbook I select from a popup. It gets all of the information except for numbers. I'm not...

Thanks Geoff. That did it. --Nate

Hi everyone, I copied a handful of functions to get data from a group of Excel workbooks in a directory I defined in the code. I'm not really good with VBA so I'm stumped pretty easily when something like this happens. Below is the code snippet. Public Sub GetData(SourceFile As Variant...