-
Hi again This has been working well. However I have been asked to slightly change the columns that come into the spreadsheet. I thought this would be straight forward as I can just adjust this part -- here I have made changes to a couple This is the one i have changed -- all works EXCEPT the last column...
-
Hi Got a problem with Excel running on Vista and data sources, we have a set of excel spreadsheets which run fine on an XP system connected to our main SeaChange data base (UNIX) and Microsoft Query works fine as well so that we can change the data query. But when we try to run the same files on Vista...
-
I need an Excel parameter prompt where the user can get a list of ALL items or only the KVI items. I've tried WHERE Unit = [Enter Unit] OR [Enter Unit] IS NULL. It works great in Access, but I get a syntax error in MSQuery. I tried using a single prompt in MSQuery, but when I input % wild card only...
-
I have an Export Query set up in Access 2007 (linked to SQL Server 2005 tables), which exports to an Excel 2007 spreadsheet. On my PC, it displays correctly, but on another user's it shows the newline characters (or 'carriage returns', in 'memo' fields) as small boxes, which also...
-
This was my input: Data > Import External Data > New Database Query > OLAP Cubes > New Data Source Using Microsoft OLE DB Provider for OLAP Services 8.0 to connect to a HTTP server (Analysis server) This was the outcome: Unable to open connection. A connection with the server cannot be established...
-
Hi Sam, Yes, that sounds like a lot of effort. Lifting a finger and all... You could code something that retrieves data from the other workbook without using the query editor. Basically an Open-Copy-Paste-Close action would do the trick. A userform could be used to create some flexibility for parameter...
-
Hi Rembo, Thanks for your post. Let me give you a brief background about the probelm The file that I am sending to my client already has a sheet which is getting data from an external file. Now my client thinks its too much of an effort to right click on a cell containing the data and then click on Edit...
-
Hi Sam, You could store the query (.dqy file) and use the following: Sub StartQry() Call Shell("Drive:\PathTo\msqry32.exe Drive:\PathToQry\YourQuery.dqy", 1) End Sub Haven't tested it under Windows Vista though. Rembo
-
I have a query on a sheet (pulling Data from another Excel File). I want to display the Edit Query Dialog whenever the user Activates the sheet. 1) I dont want to use the Sendkeys method 2) I have tried the below code in the Worksheet_Activate event and It errors out for some reason.... Private Sub Worksheet_Activate...
-
I'm having some issues importing external data from an Oracle 9i database. Here is what is happening: I am initially able to import data from the table I want to into Excel. I do this through "Data -> Import External Data -> New Database Query" where I have my .ORA data source. I'm...