Search results for query: *

Hi, Using the following code I can get the logo to appear in Excel. This same logo is stored in a SQL Server database as a general type column for each company and I would like to issue from within foxpro, a SQL select statement to retrieve the value and insert it into Excel. The application...

Hi, I have a question related to Geoff's example for refreshing of an excel sheet which worked great. Similar question re: Pivot Table usage with the same concept. Following code for refreshing an excel list shown below: With Sheets("Sheetname").Querytables(1) .commandtext = mSQL...

Skip, Awesome! Thanks Doug

Hi, I've added a button to allow refresh using the criteria and it works well, except it prints on the report. What I'd prefer to do is insert the code currently behind that button into the Refresh Data button click, but I don't know where that is? Any would be great! TIA, Doug

I'm on my way now with the vba tips and your assitance is greatly appreciated! Thanks to all who responded, Doug

I could certainly modify the sql code; but the person using the spreadsheet would be challenged, frustrated and very well may goof it up. I'm in the early stages of learning some vba code; so I wanted to determine what could be done with the cell values in the sql code. I suspected that it...

Hi, Is it possible within MS Query select statement to use a cell value as part of the sql select statement where clause without using Add Criteria/parameters (which becomes disabled in commplex sql select statements) and without using VBA coding? TIA, Doug