Announcement

Collapse
No announcement yet.

Search Result

Collapse
3 results in 0.0143 seconds.
Keywords
Members
Tags
  • You can also choose from the popular tags.

vba x

  • jpmurph
    started a topic Web Query From Multiple Cell References

    Web Query From Multiple Cell References

    In my first worksheet I have a list of states and state abrivations I want to refreence each of the states and return their results on a new worksheet. I've been able to scrap together most of the code, but i'm missing the first part of the code which declares the reference...I Think?!

    Looking forward to you input, thanks!

    Code:
            MyName = "Query" & State
            ConnectString = "URL;http://sites.target.com/site/en/spot/state_results.jsp?state=" & State
            ThisWorkbook.Worksheets.Add
            ActiveSheet.Name = State
     
            ' On the Workspace worksheet, clear all existing query tables
            For Each QT In ActiveSheet.QueryTables
                QT.Delete
            Next QT
    ...
    See more | Go to post

  • AwesomeSwelles
    started a topic Parse Delimited String to Rows in VBA

    Parse Delimited String to Rows in VBA

    Hi there,

    I'm sure there's an answer to this that I simply don't know the search terms to discover, so my apologies in advance if it's a dumb question.

    I currently have a function which grabs a csv file from a variable URL, saves it to a temporary directory and then imports it neatly and delimited into a new sheet. If possible though, I'd love to just do the whole process in VBA and skip the saving and opening steps.

    I have got as far as xmlhttp-ing the csv into a string, which is working perfectly. My dilemma now is that I haven't the foggiest idea how to parse that string (delimited by spaces) into rows. The closest I've come to an answer is automating Text to Columns on my string and then transposing the resulting columns to rows, but that just seems...
    See more | Go to post

  • awilkins
    started a topic Merge Duplicates then Sum and Count values

    Merge Duplicates then Sum and Count values

    I often need to merge multiple occurences of data (tax addresses & tax names) and to sum or count the values associated with each invividual instance (i.e number of units per tax address). Data can often be thousands of rows and varies every time. I would like to keep all of the associated information with each entry for mailing purposes. I saw this link...
    http://www.ozgrid.com/forum/showthread.php?t=83101

    However, the VBA macro, when run, only keeps my tax address an the associated sum. Please let me know if there is a way to alter the code to make this possible. I will attach the file I am working with....
    See more | Go to post
    Last edited by AAE; May 26th, 2010, 04:47. Reason: Amend thread title
Working...
X