Write to Excell Workbook on Skydrive .
Write to Excell Workbook on Skydrive .
(OP)
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
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





RE: Write to Excell Workbook on Skydrive .
www.nxjournaling.com
RE: Write to Excell Workbook on Skydrive .
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