×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Write to Excell Workbook on Skydrive .

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

RE: Write to Excell Workbook on Skydrive .

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

RE: Write to Excell Workbook on Skydrive .

(OP)
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


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources