Search results for query: *

No deal, Skip. :( Do you know how does it work (Ms query)? I mean, you think it evaluates the data before putting into the sheets? Maybe I could try to send it to an array before, but it seems it only accepts range values...any idea? (Thanks for the answer, btw. I see you are a very active member)

Where is the code at? You should put it in a new MODULE, not on a Worksheet -> On the vba editor, the 'tree' on the left, you have "Microsoft Excel Objects". Right-Click on it and add a `module'. Write your code there, and teka that `private' out of the Sub header. (I can't really say I...

Hi, I'm using Msqury to get external data from a website. One of the imported fields is an id string. the problem is that all of the characters in this string are numerical, and ms excel evaluates the id as such. Some of these id are larger than 17 digit, and so I lose some of my last digits...

Alright, I got it now! It works perfectly. I used MajP's approach (created a dictionary), and it solved my problem. Thank you, Leo

Hi everybody, I'm that I couldn't answer before. Skip and ElectricPete: I've tried to use the .find method before (on vba), but it's just not reliable enough. This dataset i'm dealing with is actually huge, and neither these Indexes ("1010002") nor their corresponding variables (the Column2...

Hi, this is my first post so I apologize in advance for anything. I've been working on this issue for more than a week now, and still haven't solved it. What I need is to dynamically name variables, so it can be 'called' acording to string strings within the sheet. More clearly, my data...