Coder Social home page Coder Social logo

excel-projects / excel-timesheet Goto Github PK

View Code? Open in Web Editor NEW
30.0 30.0 7.0 16.82 MB

:alarm_clock: This Add-In is used to produce a timesheet file with functionality to import your Google Timeline. The standard timesheet has options for start and end dates, day of week and default start, end and break times. The Google timeline options are start and end dates, UTC selection, daylight savings time parameters and title filter for timeline entries. There is also a right click shortcut to open your Google timeline to the date of the row that is currently selected. The only version is currently in VBA/XML ribbon.

License: MIT License

Visual Basic .NET 100.00%
addin bulk-data bulk-loader calendar excel excel-2016 google-timeline kml ribbon timeline-entries timesheet vba windows-7 xml

excel-timesheet's People

Contributors

aduguid avatar

Stargazers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Watchers

avatar avatar

Forkers

liuhu666888 igoreksiz vb6hobbyst7 enjeruke mschuri22 vinayhthakur owain-s

excel-timesheet's Issues

Windows 10, Excel 2016 Google Timeline download fail 

Set xmlHttp= New MSXML2.XMLHTTP60 ' works on Windows 7, Excel 2016
'Set xmlHttp= CreateObject("Microsoft.XMLHTTP") ' works on Windows 7, Excel 2016
'Set xmlHttp= CreateObject("MSXML2.XMLHTTP")
'Set xmlHttp= CreateObject("MSXML2.XMLHTTP.6.0")
'Set xmlHttp= CreateObject("MSXML2.serverXMLHTTP")

Error

Hi,
This addon will be nearly perfect for my use (export timeline for know kilometers I will make,I think I need to change fews things ) but I can use nominal version on 3 computers (2 w10 and 1 mac)

-For mac : there are a compilation error on asssembly file in Load script line "thisWorkbook.customDocumentProperties("google_timelineToday).Value = mid(...), it seem to be not reconize Mid librairy

-W10 : at startup, a popop don't want to charge object (I don't have more information, each button on ribbon I use make a error)
-W10 + rubboncustom installed : popup don't appears but same thing error when I click in a button

Do you have a idea, on what's happen? this is in french version of office 365version 11 (build 13426)
Thanks in advance
Regard

filter and choose?

Hi team,

I have a question if you possibly could help with?
I want to choose only from Column B that is equal to Column A even if it is not in the same row (both A and B) I mean and then column C also gives it its output accordingly. The example below is where I don't have all rows in column A and I only want these to be selected from column B and thus give outputs from column C. I want to apply this to a timesheet later but for the sake of simplicity.

image

example.xlsx

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.