1. T

    UTC to PST one cell to one cell

    I am having difficulty with converting a cell with UTC time <tbody> 2017-08-11T06:15:19.711Z to PST time </tbody> Using Office Pro Plus 2016 Excel 2016 MSO (16.0.4849.1000) 32 Bit
  2. J

    Excel VBA to get Outlook email attachment from alternative pst file

    I have been struggling to find code that will operate from within Excel VBA to; 1) Initiate Outlook (found) 2) Look at the inbox not of the default inbox but of a secondary one from another pst 3) Save all attachments from that inbox into a desktop folder...
  3. A

    Outlook and VBA: create folders in pst file

    Hello guys, firstly I wish to all of you a happy and prosperous 2019. Well, I have to create a new pst for the personal emails of 2019. It's not difficult. However, I have to make a number of folder with a specific tree structure. Any idea? I have a little VBA experience with excel but I am...
  4. D

    To convert PST time to CET time

    Hi All, I have in cell G4 this time (PST): 7/5/2011 0:38 and i want to have in cell R4 the time of G4 but in CET also taking in consideration the summer and winter time difference. Is there a formula to achieve this? I would be very grateful is someone can assist me with this! Thanks!!
  5. A

    Date string

    Hi, I'm trying to import a csv file with dates formatted like: Jan 1, 2017 6:01:12 AM PST How do I transform those dates when importing in PowerBI (and powerpivot)?
  6. A

    Open EML file and extract attachments with separate pst

    I have some code that opens eml files and extracts the attachments. This works fine, but when I run the code from more than 1 desktop/server, I get an error msg. This is because they all try to use the same pst file that gets created on my network by outlook. I am working in a citrix...
  7. S

    Import Most Recent Emails from Outlook Into Excel

    Hi all, I have spent a lot of time looking into this, and I am yet to find the complete answer. What I am looking to do is grab the 100 most recent emails from Outlook and have them pasted into an Excel workbook. I have built a code (which borrows from a few different websites) that has...
  8. H

    Converting GMT to PST

    Hello! I'm interpreting data collected from an underwater sensor, and have to convert time (hr:mn:sc) taken every minute, from GMT to PST(GMT-8:00). Please help! Thank you, hunter5
  9. R

    Outlook/PST Pivot Table Analysis

    Is it possible to do a pivot table analysis of a pst. I want to see how many emails were sent week by week by individuals and groups of individuals. My question really is can i get access to the outlook data to work on it with excel?

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...