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
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...
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...
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!!
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)?
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...
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...
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
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?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.