Results 1 to 4 of 4

VBA SQL Query from Cell

Threaded View

  1. 03-05-2018, 09:41 AM #1
    LePig
    LePig is offline
    Registered User
    Join Date
    08-26-2016
    Location
    england
    MS-Off Ver
    ms office
    Posts
    26

    VBA SQL Query from Cell

    Hi I am trying to get data from a cell and need a little help.


    sSQLSting = "SELECT * From (" & Sheets(SpreadsheetName).Cells(firstAddress, Colname + 2) & ")" & vbCrLf
    This is returning nothing?

    Any help would be appreciated.

    https://www.mrexcel.com/forum/excel-...uery-cell.html

    http://www.vbaexpress.com/forum/show...uery-from-Cell
    Last edited by LePig; 03-05-2018 at 10:05 AM. Reason: Updating to include links as requested by Kyle123
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Web Query from cell value?
    By miso.dca in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-09-2017, 12:05 PM
  2. Web query where url is in a cell
    By Mulberry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 01:48 AM
  3. Reference/use a cell value in a SQL query in Excel 2007 - Query Wizard
    By trizzo in forum Excel General
    Replies: 2
    Last Post: 02-01-2013, 04:21 PM
  4. web query cell changes
    By spursrule68 in forum Excel General
    Replies: 0
    Last Post: 05-31-2012, 07:34 AM
  5. Web Query - Change a word in query to form a new query
    By scottymelloty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2011, 04:13 AM
  6. Web Query through URL in Cell
    By Unibot in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-01-2009, 08:53 PM
  7. [SOLVED] Cell value for Query
    By CLR in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2006, 03:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1