Results 1 to 7 of 7

Thread: Mschart and Excel

Hybrid View

  1. #1

    Thread Starter
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Re: Mschart and Excel

    Thanks RobDog, so would my example query work or would it need to be re-written?

    VB Code:
    1. SELECT * FROM WorkSheetName Range A1 to A1000

    Also, if the spreadsheet was already open would it be a problem when connecting to it? If so, is there a way around it since it will be open when I want to run the query?
    Last edited by lintz; Oct 9th, 2005 at 07:35 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width