Version Control

[britinva]

I have a Excel based form that may change from time to time.

What I would like to do is when someone with a copy of this form saved to their PC, on open check a internal sharepoint to see if there is a new version and if there is tell the user to download a new copy.

Any ideas how I can do this?

Thanks,
Mark

[Bishonen]

here's something that should guide you in the proper direction. If you won't be able to figure out the rest, let someone know and I'm sure they will help - I'm done for tonight

Please Login or Register  to view this content.

When you got the code ready and steady, you can put it in Workbook_Open in order to automatically launch it on every startup.

[britinva]

Thanks Bishonen

This code works great for a file on my PC but when I change the file path to point to the sharepoint file I get a run time error on this line

Please Login or Register  to view this content.

This is the filepath structure

Please Login or Register  to view this content.

Any pointers on overcomming this?

Cheers,
Mark

[britinva]

I'm still struggling with this - I've managed to cobble something together that seemed to work but seems that I'm getting todays date for the Check File rather than the date it was created.

Please Login or Register  to view this content.

I'm just using a simple text file as the check source as it will only be a small 1k file to get rather than a 400k+ file.

What about instead of checking the date the chk file was created it read in a date value from within the text file?

Really appreciate any help.

[britinva]

Managed to get working - might not be best coding

Please Login or Register  to view this content.

[britinva]

Just small update

Was having issues with

Please Login or Register  to view this content.

Sometimes after editing and saving to different filename got a new Created Date so went with creating a static Date using a Named Field called "Ver_Date" on a control tab.

Please Login or Register  to view this content.

Hope helps someone

[shg]

Why not just store the form as a template on the SharePoint server? Then users would always get a fresh copy.

[britinva]

Form is stored as a Template but I need to check is that anyone that has downloaded it previously and trying to use it again if they are online it auto-checks.