Search results

After I have run all my access queries is it possible to send a conditionally formatted excel worksheet all in access using vba?

Okay, thank you for your help. Cheers

The problem seems to be with the Application.ImportXML, any idea? Sub x() Dim Variable As String Variable = Dir("C:\directory\*.xml") Do While Variable <> "" Application.ImportXML DataSource = "C:\directory\*.xml", ImportOptions = acStructureAndData CurrentDb.Execute "ALTWALL1"...

I know this doesn't work, but is it on the right track? Sub x() Dim Variable As String Variable = Dir("C:\Users\homckeowne1\Desktop\VBA MACRO TEST\*.xml") Do While Variable <> "" Application.ImportXML Variable, acStructureAndData DoCmd.RunMacro "Macro1" Variable = Dir Loop...

Very little. I've read up on it and understand it as allowing me to search a direcorty based on file type? Dim Variable As String Variable = Dir("C:\directory\directory\*.xml") This will pick out all the xml files within the directory?

I am sorry, I should have pointed out I am complete novice with visual basic.

I have built an access database which just now I use to; 1. Load in XML file. (External Data > XML File) 2. Run a macro containing multiple queries (these queries add records to a table which build up an interface, which can loaded in to another program). 3. Repeat, until all files have been run...