Workbooks.open method - vbs code

Hi Guys

I have a bit of a problem. i have created an excel file that calculates leave for every calender week. i have installed the analysis toolpak add in and used the = weeknum() function. . it all works great when i open the file by clicking the .xls file.

The problem i have is when i open the vbs file that i have created to open this .xls daily and update it. it opens the file but does not display the weeknumbers and saves the .xls file without weeknumbers.The file size varies when i open the file directly as opposed to opening it via vbs. i am definately missing something.

thanks in advance

the vbs code i use is

Please Login or Register  to view this content.

Try changing the first bit to:

Please Login or Register  to view this content.

Glad to help - please don't forget to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save