AutoOpen the file

[vmjan02]

I am wondering if the VBA can open a file by itself and ran a call process.
SO the callall will run very 1 hr as this callall run the required process and saved and close the file.
so the vab will reopen the file by itself after 1 hr and then it will run the callall

any way to fix work on it.

Private Sub Workbook_Open()
  Call callall
End Sub

 

[vmjan02]

any way to fix it

 

[Sergius]

Add the required file to the XLSTART folder. When you open Excel, it will open automatically.
Is this what you want?

 

[vmjan02]

Add the required file to the XLSTART folder. When you open Excel, it will open automatically.
Is this what you want?

ok let me try this, but do we have vab code it will be great