Threads Replies Last Post 5 Pages: 1  2  3  4  5   No Macro showing up Hi folks, I have a 30 worksheet file, where each time I open it up, it asks to either enable or disable a macro. There is no macro on this file when going to Tools-Macros. I've check the file through VB and can't find any macro. I checked personal.xls and there is no macro in that as well. Any other suggestions you might provide to get rid of this warning message would be appreciate... 4 30.09.2006 13:38:27 change cell dinamicly in excel hello. i have excell worksheet that i want that some of the cells will be update automaticly from a sql database by a query. i use office2003. i dont know how to start. thanks please give me an example if it posible thanks again... 1 28.09.2006 20:14:02 Difference ADODB and OLEDB Hi, When programming in vb.net i always used the OLEDB class to connect to my SQL database. eg. with something like: Dim objConnection as New OleDbConnection( ConnectionString ) I noticed this does not work in Excel/VBA, here i used: Set connection = New ADODB.Connection connection.Open ConnectionString My questions: #1 Whats the difference between OleDB and ADODB ? #2 why do i... 1 24.09.2006 17:31:11 How to edit SQL connection? We have an Excel spreadsheet that was created by someone who left the company and who did not document what they had done. This spreadsheet is supposed to be connect to a SQL Server to extract data for a report, however the server on which the data resides was changed, by the same person who created the spreadshseet and who subsequently forgot to update the spreadsheet, and this is proba... 3 21.09.2006 13:48:04 Outer Joins option grayed out Hi I have a query reading a visual foxpro database to return data to a pivot table. I want to do an outer join but the options for outer joins are grayed out. How can I get round this? Many thanks ... 1 16.09.2006 10:42:09 Problems Using Project OLEDB as a Data Source in Excel I have created a data source (an ODC File) using the wizards in Excel with Project OLEDB. The Test connection button works and when I open the file in Internet Explorer, Office Web Components allows me to create a PivotTable of the data. This implies that the ODC file is correct. But when I open it through Excel, Excel says the query did not run or the database table could not be opened: ... 1 15.09.2006 07:50:39 Query an Excel sheet through HTTP Hi there, Would anyone be able to point me to any resources where I can do some research. Using DAO/ADO, I'd like to be able query an excel sheet provided by my clients web site. Ive used vba for DAO excel sheet querys before but am needing a point in the right direction to do it via the web rather than via a file path. Is it as simple as giving the file path a http address?? an... 1 13.09.2006 07:48:08 Parameter query with date I have a worksheet that I need to update on a daily basis with data from an external Oracle database. I am using the following query which gets yesterday's data (the Oracle data is always for the previous day). SELECT Sum(recno) FROM mailboxes WHERE (trunc(logdate)=trunc(sysdate-1)) This sums the values in the rec_no column for all rows that were logged yesterday. The thing is that on... 1 04.09.2006 09:51:22 Connection Object basics I need to enter data from Excel VBA into SQL. I am trying to use the query mentioned below: My challenge is that I am in a wonderland when it comes to SQL and connection objects. I dont know what I should have in "Data Source=Server\SQLServer;" and "Initial Catalog=MyDatabase" I think 'data source' should be as it is and 'Initial Catalog' should be the database name. I dont know where t... 2 02.09.2006 22:37:12 How to populate data in a excel sheet using VB I want to populate data into excel sheet from sql db which I have already done. But I want to populate the data in different colors depending on one columen value...for eg..in col3 the values are ERROR,INFO etc....if the value is ERROR the records should come in red. If it is INFO the records should be in white..otherwise in Green color... Please let me know how to do this... ... 2 02.09.2006 20:53:01 A Bug or a planned feature?? Hello, When I use Microsoft Excel --> Import External Data --> New Database Query --> Excel Files*, I find out Excel doesn't work or doesn't work correctly if the file name (Path+Name) exceeds 69 characters long. I'm using Microsoft Office 2003. Has anyone experienced the same issue? Has there a patch to fix this if this is a bug? Currently, I have to tell my users to move/ren... 2 01.09.2006 23:42:52 Importing Data to Excel In Excel there is an option Data-->Import Data-->New Database query In this using filter it is possible to display the record satisfying condition. (eg) Id equals value But I want to specify a value for the condition from the Excel sheet. (i.e) I need to pass a parameter from Excel sheet and retrieve the corresponding data from SQL Server. How do I do this? I have searched for som... 3 24.08.2006 06:40:08 Connecting SQL and Excel This is my task. (eg) : My SQL Server 2005 resides in a seperate system and Excel 2003 application in another system. My SQL DB contains a table called "Employee" with fields Id, Name, Salary... When I enter an Id in the Excel Sheet, I should get the remaining data filled in the other columns. How do I establish the connection and write the query for this? Ca anyone guide me to this task... 2 22.08.2006 20:35:51 Integrating SQL And Excel This is my task. (eg) : My SQL Server 2005 resides in a seperate system and Excel 2003 application in another system. My SQL DB contains a table called "Employee" with fields Id, Name, Salary... When I enter an Id in the Excel Sheet, I should get the remaining data filled in the other columns. How do I establish the connection and write the query for this? Ca anyone guide me to this ta... 1 18.08.2006 05:51:36 sql problem Hi I have a problem in excel when i try to import data from MSSql with Import external data: I must use the same condition in two places in the same query..something like that: select col2 from d where col1=? union select col3 from d where id not in (select col2 from d where col1=?) this query works perfectly in MSSql, but when I try to do this in my ".dqy" file the excel tell me ... 4 14.08.2006 09:48:35 PivotCache.Commandtext Our company had 200 + excel reports that we automatically refresh the pivot tables each day and email them out. When we do a server migration or copy for a new program we go into each pivot table and add the new view from the new database. I have successfully changed the command text to the new view on the new database, but to save file size we usually try to link pivot tables to one pivot t... 1 04.08.2006 22:09:19 Help with code for Macro! Hello, I'm trying to create a Macro that does the following: 1. Copies the values of 12 cells from Sheet1 to Sheet2. 2. Perform an import of data from a database that will over-write the values in the 12 copied cells. 3. Paste the copied values back to their original cells on Sheet1 in 11 columns. The only column that cannot be copied back is the column for the current month. I've go... 4 04.08.2006 18:44:49 Problem with DAO (Import from Excel to Access)! :( Hi, I am novice and I have problem. I need import some data with Excel file to Access. Problem introduces as follows: In Excel(first sheet) i have data: "TYTUL" - column "A" "NAZWISKO" - column "B" "IMIE" - column "C" "PRZEDMIOT" - column "D". Excel file name is AND.xls In Access i have table - AS_PRZEDMIOT. Table "AS_PRZEDMIOT" contains fields: ID_PRZEDMIOT (Auto), P_AKTYWNY (Numb... 1 02.08.2006 17:21:47 web query quits working with Yahoo historical quotes I posted this problem a week ago on the public.excel.misc group but didn't get any takers. So, another try. I have a Web Query that's been working flawlessly for over a year to download Yahoo historical quotes, and then one day it decided to work for only the first query of the day (sometimes not even then), and on any subsequent queries it gives either a 1004 error or it says: "Unable to... 4 27.07.2006 22:08:54 Excel Query I have a sheet in Excel that i'd like to use MS Query to report all row that have a date in a certain column that is equal to or less than todays date. It's easy to select the relevant rows from a fixed date - but can anyone help with selecting using a changing date? ... 2 25.07.2006 19:17:33 problem Hi I have a problem in excel when i try to import data from MSSql with Import external data: I must use the same condition in two places in the same query..something like that: select col2 from d where col1=? union select col3 from d where id not in (select col2 from d where col1=?) this query works perfectly in MSSql, but when I try to do this in my ".dqy" file the excel tell ... 1 24.07.2006 13:13:34 "Web Query" refresh failure on different machines Hi there, I'm really hoping somebody can help me..... ......I've been using Excel(2003)'s "Web Query" for a while now but I've encountered a situation where the spreadsheets I've created only work on "some" machines and not others. All the machines in question are running XP os and Excel 2003sp2. Basically, the web queries are used to extract share prices.....I know, I know.....aren't... 2 12.07.2006 12:26:10 Edit Query Tool Hi, When I use the Edit Query tool in Excel, it doesn't respond for some queries. I have 6 different Queries in one sheet and for some reason two queries don't seem to respond at all when I select the Edit Query tool. Please help. ... 1 11.07.2006 18:10:54 How to get MonthName in Microsoft Query Dear Sir, I am using a date field in Microsoft Query in Excel 2003. I want the query to return MonthName instead of date. the Query is: Select MonthName(Order_Date) as Date from ORDERS. I have also tried CMonth Function but I am not able to return only the MonthName from date value. Function Month() works but it gives month in numbers like 1,2 3 but I want in Jan, Feb, Mar etc. Can you p... 4 11.07.2006 05:47:02 Keep text columns in Database Query from truncating to 255 charact I have an excel sheet which pulls in data from another excel sheet using a database query (so that I could do some SQL select logic). I have two text columns in this query which behave differently, one imports results truncated to 255 characters while the other allows more (900+) characters. I can not discern any difference in these two columns in either the source workbook or the dest... 1 05.07.2006 17:19:01 5 Pages: 1  2  3  4  5