SQL query in Excel 2000 using VBA

  • Thread starter Brandon A. Dreiling
  • Start date
B

Brandon A. Dreiling

Greetings,

I am looking for help on how to reference a specific worksheet cell to be
used in a SQL (Sybase 11) query.

I have working VBA code that will pull data as long as I hard code the date
or date range; however, I would like a single cell, or even a msgbox to be
used for the date.

If anyone has any ideas, I would appreciate it.

Thanks,
Brandon
 
D

Douglas J. Steele

SQL query in Excel 2000 using VBAYou'll probably have better luck asking in
an Excel-related newsgroup (they start microsoft.public.excel)

This newsgroups is for questions about Access, the database program that
comes with Office Professional.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Greetings,

I am looking for help on how to reference a specific worksheet cell to be
used in a SQL (Sybase 11) query.

I have working VBA code that will pull data as long as I hard code the date
or date range; however, I would like a single cell, or even a msgbox to be
used for the date.

If anyone has any ideas, I would appreciate it.

Thanks,
Brandon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
VBA Coding Help for Beginner 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA for Dependents shortcut menu 0
WORD VBA Search and switch to advanced ... 1
How to Change criteria on a saved query using VBA 0
Pasting a cell into bookmarked table from excel vba 1
SQL Where Using Date For Attributes With Date & Time 1

Top