Automatically open, close & saved documents

[namialus]

Hi all,

I need your assistance to help me to open, close & saved a database file.
Below is the VB Script ,
Thank you in advance

Please Login or Register  to view this content.

[LJMetzger]

Hi,

The following will probably do what you want, but has no error checking.

Please Login or Register  to view this content.

For an example of some of the same code with extensive error checking see post #3 or post #5 from http://www.excelforum.com/excel-gene...ta-weekly.html

Lewis

[namialus]

Dear Lewis,

Thank you for your reply, but
can this script combined with my "updatelogworksheet"? because I want the
file open & after update it'll closed & saved by itself... thanks again

[LJMetzger]

namialus,

Try this. It opens the file, runs your macro code, then saves and closes the file.

Lewis

Please Login or Register  to view this content.

[namialus]

Dear Lewis,

I received error "run-time error 9 ; subscript out of range"
& yellow mark at script line :

Set inputWks = Worksheets("source")

Note : The database file opened but no input ...

Thank you again

[LJMetzger]

I didn't test the macro the first time because I didn't think anything could go wrong, go wrong, go wrong. I was misinformed. I apologize.

I had to move the item in blue to the beginning of the macro. The macro was looking for Sheet 'source' in the wrong workbook.

Try again with:

Please Login or Register  to view this content.

Lewis

[namialus]

Dear Lewis,

The macro working , thank you very much