sql within a workbook
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: sql within a workbook

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    hey, I have a database on sheet3....names, numbers, unitname, etc. Now, On sheet1 I have a cell(A12) that I want to type in the unit name and have it place the all records that have that unit name from sheet3 and place them on sheet1 in rangeA14 on sheet1.
    do anyone know of a vb code to do so. thanks!

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Is it an Access Database?

    If so, establish your link to the database and record a macro where you "refresh" the data. Add this to code where you update your "paramater[s]"


    HTH. Cheers, Nate

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com