data connection

Hi everyone, I'm in the process of building a huge forex database in excel for my own analysis purposes. I have collected the past 30 years forex data for top four currency pairs! I would also like to keep the database up-to-date with daily forex information such as, opening, closing, high, low...

Hello, Our organization has about fifty scorecards in Excel, with three data connections apiece. All of them refresh from the same password-protected database. Is there a way to write a script that will open and refresh all the workbooks at once, wihtout having to type the login and password...

Hi, What I need to do: I have two files, File A: A master spreadsheet that is updated regularly and File B: a consumer facing spreadsheet that needs to be connected to File A and updated whenever File A is changed. As far as I got: I created a data connection between File A and B so that File...

I created a SQL query that gathers information for users to determine which items in our system need to be inactivated. The user receives an Excel workbook that has a table with a data connection to the SQL Server database that pulls in the information they need (via stored proc). I want to...

I've read over these threads for quite a few years now and have almost always found any answers I needed, or at least got pointed in the right direction. Unfortunately, I need to ask for your expertise. I am using Excel 2007. I put together an Estimate sheet that pulls date from a Master sheet...

Hi, I'm getting a runtime 1004 error: application or object defined error on the code below Seems to be in relation to "ActiveWorkbook.Connections("Database2").Refresh," Any advice appreciated. Sub Send2Access2() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim...

Hello, I have 4 excel workbooks that are basically data entry forms that (through VBA) dump into a common data storage workbook. On each of the data entry workbooks, I have set up a data link to the sheets in the data storage workbook. This lets people with access only to one of the data...

Hello, This is a 2 part question. #1 In vba I can create a data connection and put the data on a worksheet. However, in vba can I create a data connection and just read the data? Without writing the data to a worksheet? #2 If in one workbook I have a named range, with a data value. When I...

I brought in external data from a web source and have a connection maintained with the data, butI cannot create a Pivot Table or even a regular Table from the imported data without having to remove the connection. Is there a way to create a Pivot Table that will stay linked to this external web...

I have a computer that is wireless I have a simple save macro below that I use. The problem I have is sometimes the network connection needs refreshed before the macro will work. Could some one help me modify the code below to do this. The network drive is "H:\Burney Table\Tester\Operators...

Hello, I regularly find myself manually changing the SQL in many different worksheets owing to a minor change in the criteria. For each sheet, the SQL is the same other than for the filtered field, Specialty. So: one sheet for Cardiology, one for Ophthalmology etc. I think this must be...

Greetings, I have to update a collection of a couple dozen Excel scorecards that pull their data from Access. Each scorecard has three Data Connections to the database; the database contains three different queries constructed to supply their piece of the data. One thing I discovered while...

I have a problem, I have a number of buttons which once clicked assign a certain value to cell C10. I have it so if i press another button or the same one twice it will recognise cell C10 is already occupied and therefor go to cell C11. Thats as far as my code goes I am struggling as I...

Hi I've written spreadsheet which reads and writes data from an access database. I think I've got some poor code though - when I click on the data Connections in the Data toolbar it takes an age to load and has thousands of entries - I think this is slowing down the whole workbook (opening and...

Hi Guys, I hope you can help me. I received some data in the following format: Mr|A| Jones| $500| 15 Sunset Road| Claremont||| 15/3/2010|Invoice|$2000| 20/3/2010|Payment|$1500| Mr|G| Moses| $2000| 20 Musket Road| Bellville||| 15/3/2010|Invoice|$4000| 30/3/2010|Payment|$2000| I need change...

I've come across several MS sites that say you can write formulas in Excel for external data (stored in Access in my case) without importing the data. Unfortunately, they don't say how you do this. Any advice?

So I am creating a "form" with excel that gets passed around to various project managers throughout my organization. One of the fields called "costs" I would like pre-filled for the project managers. I have this "costs" data in another workbook that is on a secure LAN folder, that gets updated...

Hello all, I'm having an issue with a data connection in Excel 2007. I've not been able to find a solution anywhere online so I'd be tres grateful if anyone could shed some light on this. SQL Server is involved but I believe the problem is with Excel so apologies if people think I'm posting...