Write to Excell Workbook on Skydrive .

[lklo]

Hi -

I have created a portion of VB.script's (NX journal) ,where I read and write from and to NX into an Excell sheet.

I have a reasonable control of this.

But now I have a special need. Will it be possible to place (manually) an Excell workbook on my Skydrive Pro (office 365),
and then open and write some data from NX to the workbook and then save and close.?

1.Can the web adress and the workbook be reached from a VB script. ?
2.Alternative is to have a temporary workbook on local machine to write in from NX ,and then upload and overwrite on Skydrive.
3.Can upload and overwrite be done from af VB script ?
4.My documents folder on Skydrive Pro is Unique - but can I force the login and password from a VB script?



lklo

 

[cowski]

I currently use Dropbox; it has a small app that you can install on any computer you work with. It will download your files to the local drive and when they are changed it automatically uploads the new version to keep everything in sync. Perhaps Skydrive (aka Onedrive) has a similar option?

www.nxjournaling.com

 

[lklo]

hi Cowski -

thank's for your reply.

You are right, your idea can be used as a workaround , onedrive is similar skydrive.( has also a folder on local computer)

In my case I have to install the onedrive app ,one theese computers ,that I have to reach onedrive from .

I use office 365 at my workplace ,(a NX consulant house)., and I need to update my mileage Log (driver-book) every day.

I will create a blockstyler menu + VB script with some predefined parameters and aut. date's and so on ,so I can populate this excel sheet ,every day , from inside NX.

A little bit of fun, but it also becomes useful and reliable.

lklo