Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. comcon

    Text Boxes in Excel Charts

    Jeff, Is there a way we can create the text box in a VBA macro and put it onto the chart using the program? I would like to insert the text boxes automatically, instead of having to do them manually. Thanks
  2. comcon

    Text Boxes in Excel Charts

    Is there any way in VBA to insert text boxes at selected points in a chart?
  3. comcon

    Excel and DDE

    The following is a piece of my code. When this is operating, the DDE events in the &quot;PressActivity.xls&quot; spreadsheet are stopped. How can I do the following, yet keep the DDE events still processing? Thank you very much. Do While Timer < 75000 If Int(Timer) / 10 = Int(Int(Timer /...
  4. comcon

    Excel and DDE

    Our new press is linked to a computer using DDE, so we have an Excel spreadsheet that is continuously updated with data from the press. I am wanting to save the data for logging purposes. I thought my VB macro was working well as my log file is updated every 10 seconds. However, that was when...
  5. comcon

    Using an ODBC connection with Excel

    Thanks, I had not thought of that, but it certainly would be a way. Like you say it is a little unwieldly, but certainly better than having someone see data that they should not.
  6. comcon

    Using an ODBC connection with Excel

    We are using MSQuery in Excel to connect to our SQL server via an ODBC link. It works very well, in fact, too well. Many in our organization are wanting to do this, but at this point there is no way to limit their access to tables. How can we let them use MSQuery, but only on the tables that...
  7. comcon

    ODBC Security for SQL Server

    We have been using MS Query from Excel to collect info from our SQL Server. However, there is no limit on what tables we can use. Before we distribute this product to managers around the company, we need to assign rights to them. What is the best way to do this? When setting up an ODBC...

Part and Inventory Search

Back
Top