I have a VBA module that uses the URLDownloadtoFile function to grab some table data from a company website and paste it into excel.
The function works fine, but it converts some of my text to scientific. As I am using the function instead of copy and pasting the data, I cannot specify the column as text, etc.
Does anyone know of a potential solution?
(My workaround solution is to download the file to a word document and then copy the word table into excel. However, this is a less than optimal fix.)