Prev: Excel inputfile
Next: VBScript and Script Host
From: Kenneth A. Larsen on 27 Jul 2010 19:45

"cleech" <cleech(a)discussions.microsoft.com> wrote in message
news:8128718C-0732-4B19-8E44-2E722F2E30A9(a)microsoft.com...
> Hello All:
>
> I have .vbs script that I use to loop through a series of xml files and
> import specific data into .csv file. Later I import the .csv into an
> access
> db. Ultimately, I would like to automate the entire process. So I'm
> looking
> for some advice/recommendations.
>
> The vbScript currently has the file locations and output file hardcoded
> and
> I change it each time I run the script. Is there a way to pass
> parameters/variables for the file location and output file to the
> vbScript?
> And could the script then be called from vba with the parameters?
>
> Could the data I'm taking from the xml files be loaded directly into an
> access table?
>
> Is there a good way of converting the .vbs into VBA(Access 2007)?
>
> Sorry for the slew of questions. I'm just wondering if anyone has done
> something similar and might have some advice.
>
> Please let me know if you would like addtional info or if I can clear
> anything up.
> Thanks in advance for any help.

You are welcome for any help.
>
>


 | 
Pages: 1
Prev: Excel inputfile
Next: VBScript and Script Host