Search results

I'm trying to write VBA code that will update the queries in an Excel spreadsheet when the database they reference is moved. Clients want to be able to share the database and linked spreadsheet across a number of computers as well as a network. I've tried examples on the web that are meant to...

jdraw, that worked brilliantly!!! thank you! i really appreciate all the effort - you've saved us countless hours now. :D

jdraw, thank you very, very much. it's midnight here in West Oz right now so I'll get onto it first thing in the morning and let you know how it goes. Again, thank you - fantastic effort! :D

Yes, from what I'm reading now it seems to be only a problem post-2007. Strange - I wouldn't have thought that would be the case. I took the offending "DTD" sections out of one of the files just now and that seems to do the trick. But what would be preferable, without having to change each of...

thanks for that - I've attached the link as I can't see how to attach a file - just click on the "Download XML file" to get the file. http://www.imowa.com.au/n117,45.html?link=%2f20121107%2fallmp_EM_STEMSummaryInfo.xml&h=f074bfee94abc5e0de6f288d2e87346f much appreciated!

Thanks jdraw, That was the first option I had, unfortunately it doesn't seem to work. Cheers for the thought though! :banghead:

Thanks folks for your ideas. It does appear to be the file's settings, in the "DTD" as I understand they're called, and it is common to all the files.

I'm using the below code in an Access form to import XML files. I get an error 31593, "DTD is prohibited". How can I fix this? Thanks in advance, Paul Private Sub Command0_Click() Dim StrFileName As String Dim fd As FileDialog Dim vrtSelectedItem As Variant Dim strprop As...

To clarify: (1) when I cut the file down to 26 and then 52 columns, I tried it on my client's computers and it worked fine, but then it fell over at 71 columns on their computers. (2) The reason for using Excel 97-2003 format is that Access 2003 didn't seem happy importing an Excel 2007...

I'm having problems importing a spreadsheet from Excel for a client. They are using Access 2003 and Excel 2007, 3.5GB RAM It works perfectly on my machine - Excel 2010 and Access 2007-2010, 4 GB RAM. The file is imported in Excel 97-2003 format via a macro using the transferspreadsheet...

any help would be greatly appreciated!

Thanks Marlan! much appreciated.

I'm facing a few difficulties with a macro to import spreadsheets into Access database tables. Each spreadsheet file represents a different month (e.g. for August-October 2012, there will be different files named 201208.xlsx, 201209.xlsx and 201210.xlsx) and each file contains only one tab with...

Hi all, I'm trying to populate an Excel spreadsheet with information captured by Access queries. I figured the easiest way to do this (as there will be many queries) would be to build a macro for each query and then run a macro that runs all those macros, populating the relevant parts of the...

Thanks for that Galaxiom! Very much appreciated :)

Hi everyone, I'm trying to run a query that sums information across tables. I have a whole load of half hourly data and want to aggregate it at a monthly level, then report it across months. I have a different table for each month of the year. Each table includes the amount of electricity...

Hi all, I'm a new member, fairly expert in Excel but only a beginner in Access. I'm a consultant in the energy industry and often have to deal with big datasets of half-hourly data. A lot of people in the industry here prefer Excel but it just gets too unwieldy with large amounts of data, so I...

Thanks Trevor, I posted a reply yesterday but it seems to not be showing - so again, thank you very much for your prompt and helpful assistance!

Hi everyone, I'm hoping someone could give me some direction as it's been a few years since I've fired up Access. I'm building a 5-year financial model for an energy company. The kind of information includes the amount of energy produced, and the price it is sold for, for each individual power...