Search results for query: *

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

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

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 /...

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...

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.

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...

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...