Automate the "Save-As" to xls with Map

[Kurt]

Hi,

From all our project on the server we want to automate the Save-As procedure
to an Excel file via a predefined Map.
Now, we have to open weekly each project from the server, run Save-As to
Excel and select the Map to be used.
Can this be automated with a script ?
Or is the only alternative to access the SQL Server database directly and
query on the tables ?

Thanks
Kurt.

 

[Gérard Ducouret]

Kurt,

Yes, you can automate the Save As... with a map with a VBA script. As far As
I remember, it's very easy to write because you can record the macro while
you are doing the operation:
Tools / Macro / Record New Macro...

Gérard Ducouret

 

[Kurt]

Hi,

Thanks for the hint, I will try that.
The macro would more or less like:
- Open project 1
- Save As project1.xls
- Close project 1
- Open project 2
- Save as project2.xls
- Close project 1
-......
- repeat until last project is saved

Ofcourse, I would have to update the macro each time a new project is
created on the server.

I was thinking more of a command line script somehow or something running in
the background where it is not really a requirement to actually open all
files.
Don't know if that is possible.

Kurt

 

[Gérard Ducouret]

Kurt,

Yes, it's possible to write a VBA procedure which will look at all projects
stored in the data base, but it's not so simple... ;-(

Gérard Ducouret

 

[Kurt]

Gérard,

That's what I thought but we really need that. Where to get started ?
Has anyone here on the forum done this before ?

Kurt.