Browse by Tags

Daily Dose of Excel

Home

Syndication

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

XML and Excel

Hi everyone, I have had a Dutch article on XML and Excel on my site for quite some time now, but never got round to translating the thing into English. Well, yesterday I found a bit of time during a long train-ride, so here it is: XML And Excel From the intro: Microsoft Office 2003 Professional was the first Office [...] Read More...

Published Thu, Nov 11 2008 9:47 AM by Daily Dose of Excel

Filed under: General, MVP, External Data, Miscellany
Creating Classes from Access Tables

As I mentioned earlier, I want to develop a framework generating app to create some of the code necessary to read and write to and from an Access database. This is iteration 1 of about 100. Start with this table in Access Set a reference (Tools - References) to Microsoft ActiveX Data Objects 2.8 Library. Then run [...] Read More...

Published Sat, Nov 11 2008 10:46 PM by Daily Dose of Excel

Filed under: Classes, External Data
Lessons in SQL

Here's some code I have to generate a SQL statement Public Function BuildRepSQL(ByRef clsRepLine As CRepLine, eType As aiDBStatus) As String Dim sReturn As String With clsRepLine Select Case eType Case aidbstatusdelete sReturn = "DELETE * FROM tblRepLine WHERE [...] Read More...

Published Fri, Nov 11 2008 5:07 PM by Daily Dose of Excel

Filed under: VBA, External Data
Create a QueryTable from an Excel Source in VBA

Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...] Read More...

Published Tue, Jun 06 2008 9:03 PM by Daily Dose of Excel

Filed under: VBA, External Data
Updating Stock Quotes

I answer about four questions a month on the newsgroups. I'm off to a roaring start in April, but I don't like my answer much. I never know just how "correct" an answer to give. So I gave an answer that I felt was appropriate for the original poster and I'll give [...] Read More...

Published Tue, Apr 04 2008 10:49 PM by Daily Dose of Excel

Filed under: Classes, External Data
Multiple Parameters in External Data Queries

Laura asks: I am trying to use one query but with multiple paremeters depending on the cell. For example I have a list of dates in Column A and I want to run the query for each dates shown in column B, so the paramter for B1 is A1, B2 is A2 etc.. How do I [...] Read More...

Published Thu, Jan 01 2008 10:11 AM by Daily Dose of Excel

Filed under: External Data

Browse by Tags

Syndication

Recent Posts

Tags

News

Archives

XML and Excel

Creating Classes from Access Tables

Lessons in SQL

Create a QueryTable from an Excel Source in VBA

Updating Stock Quotes

Multiple Parameters in External Data Queries