Search:

Type: Posts; User: JumboCactuar; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: How can I pass a number with leading zero's as a parameter in PQ?

    Norie

    Thankyou this is working :)
  2. How can I pass a number with leading zero's as a parameter in PQ?

    Hi, I've looked all over for a solution to this but nothing. I'm trying to pass a number as a parameter into a URL, keeping the leading zero's.

    Example: 000129832 When I enter this it gets passed...
  3. Re: VBA: Preventing numbers automatically changing to dates ?

    Thankyou I will try this
  4. Re: VBA: Preventing numbers automatically changing to dates ?

    Thankyou though this didn't work as expected and formatted some of my numbers as blank

    I forgot to mention my original data is also mixed with correctly formatted data so that could be why
    ...
  5. VBA: Preventing numbers automatically changing to dates ?

    Hi,
    this only happens with numbers that look like a date:

    I have data like this:
    1 to 9
    10 to 12
    13 to 15
    17 to 19

    Now i need it to look like
  6. Replies
    3
    Views
    278

    Re: ie.Navigate save file to folder?

    @Worf
    Thanks for the reply but it isn't this simple as the site requires secure login.

    I managed to automate this with IE, though stuck at the (Open /Save) notification bar that pops up.

    Tried...
  7. Replies
    7
    Views
    75

    Re: How can this vlookup be achieved between 2 dates ?

    Expected output as the 2nd table I posted, from only the dates in row 1, names output below for each in table 1 range
  8. Replies
    7
    Views
    75

    Re: How can this vlookup be achieved between 2 dates ?

    Thankyou Matty
    This looks correct I will try it when I get on PC
  9. Replies
    7
    Views
    75

    Re: How can this vlookup be achieved between 2 dates ?

    Ye vlookup isn't the right thing for this, in the 2nd table I'm wanting to output the names for each date.

    I think I maybe need an array or an helper column in the first table
  10. Replies
    7
    Views
    75

    Vlookup between 2 dates ?

    Hi,
    Not sure if vlookup is the correct thing to use for this but i have data like below:


    <tbody>
    Name
    StartDate
    EndDate
  11. Replies
    3
    Views
    278

    ie.Navigate save file to folder?

    Hi,
    I managed to login to site then navigate to specific URL which is a JSON

    After loading the page, a prompt comes up to open/save JSON

    Is there a way I can save this to a specific folder...
  12. Re: Can anyone figure out or explain why this code doesnt work? (passing SQL string)

    @RoryA
    That's done it thankyou

    I build the region variable into the SQL string using CONCATENATE before passing it to the sub and it's working correctly now
  13. Re: Can anyone figure out or explain why this code doesnt work? (passing SQL string)

    Thankyou I will try this, though this likely won't work as the variables are on the same sheet as intended. Plus when I F8 through the code and hover over them, they show correct
  14. Re: Can anyone figure out or explain why this code doesnt work? (passing SQL string)

    @Trebor76 thanks for the reply

    ive tried this and it throws an error:
    https://puu.sh/DrE7F/17a621148d.png


    at this stage of the code, the sql string looks perfectly correct...
  15. Re: Can anyone figure out or explain why this code doesnt work? (passing SQL string)

    Bump
  16. Can anyone figure out or explain why this code doesnt work? (passing SQL string)

    Hi,
    cant figure out whats wrong here:

    This Works with the following SQL string in cell P9
    SELECT * From [DataSheet$] WHERE Region='UK'

    But it fails with this, where the Region is in cell P7...
  17. Re: Using ADO to query other Excel Workbooks - Questions

    Also if using the code in the same workbook multiple times, it would be a lot of code.
    Instead, would it be possible to create a UDF where I can simply pass the source / variables and query?
    ...
  18. Using ADO to query other Excel Workbooks - Questions

    Hi,
    i found this great code which allows you to query the current workbook, and also closed workbooks. Allows you to SQL query which i am finding a better way of "advanced filtering" data in the...
  19. Need help with SQL query UPDATE from worksheet

    Hi,
    i used the following methods on this page to update an access table from excel (ADODB) but unsure the best or correct way to update an SQL table ...
  20. Re: Making this XML data readable? VBA or powerquery

    Thankyou I will try and work with this


    Type2 = Table.TransformColumnTypes(Promote,{{"NAME", type text}, {"LOCATION", type text}, {"IDNO", Int64.Type}}

    This line, does it mean will only work...
  21. Re: Making this XML data readable? VBA or powerquery

    i cant as its confidential data, ive tried to find a similar example but no luck

    basically when i load it in to powerquery it shows as multiple tables which i can expand to get the data like in...
  22. Making this XML data readable? VBA or powerquery

    Hi,
    i get data from web which is an XML file with metadata and when loaded it is output like this:
    (COLUMN1 / COLUMN 2 is actual header in A1/B1)


    <tbody>
    COLUMN1
    COLUMN2
  23. Re: Cool Customized standard InputBox to allow validating input as you type in.

    not everyone uses userforms

    thanks Jaafar Tribak , these are useful especially the password mask
  24. Re: Formatting all 1 as ✔ and all 0 as Blank (with vba ? )

    Perfect it works, thankyou :)
  25. Formatting all 1 as ✔ and all 0 as Blank (with vba ? )

    Hi,
    i have the following working directly on worksheet

    ✔;;;@

    but the problem is when trying to reapply the formatting with VBA, as the tick isnt recognised.

    example, when i record myself...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4