1. Contracting
    1. General
      1. Brexit
    2. Business / Contracts
      1. Coronavirus Assistance
    3. Accounting / Legal
      1. Umbrella Companies
      2. HMRC Scheme Enquiries
      3. The Future of Contracting
      4. IR35 Reform
    4. Technical
    5. Welcome / FAQs
  2. Social
    1. Light Relief
    2. Social / Events
  • Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

VBA and Sharepoint

Collapse
X
1 to 2 of 2 Previous template Next
Collapse
Reply to Thread
  •  
  • Filter
  • Time
  • Show
Clear All
new posts
1 to 2 of 2 Previous template Next
    #1

    VBA and Sharepoint

    OK I have a question. I have been asked to produce a spreadsheet which summerises a load of data held in various Excel files in sharepoint. I have to use Excel to do this. I know it is possible to use the getvalue statement in VBA to pull a value from a spreadsheet held on a hard disk but can't get it to work when linking to a spreadsheet on the sharepoint.

    Any ideas?
    Rule Number 1 - Assuming that you have a valid contract in place always try to get your poo onto your timesheet, provided that the timesheet is valid for your current contract and covers the period of time that you are billing for.

    I preferred version 1!
    Tags: None
    #2
    I had a idea to do some thing like that for some new project but I've got bogged down on other things.

    I started to look at Excel Services for Sharepoint . However, sharepoint was killing the server I put it on so I've never been that motivated to look at it again.
    Drivel is my speciality

    Comment

    Reply to Thread
    1 to 2 of 2 Previous template Next

    Advertisers

    1. Contracting
      1. General
        1. Brexit
      2. Business / Contracts
        1. Coronavirus Assistance
      3. Accounting / Legal
        1. Umbrella Companies
        2. HMRC Scheme Enquiries
        3. The Future of Contracting
        4. IR35 Reform
      4. Technical
      5. Welcome / FAQs
    2. Social
      1. Light Relief
      2. Social / Events
    Working...
    X