0.value

Hi All, I am trying to find a way to have a userform appear while the code is running and to set a condition if the code will continue to run, based on selection made in the userform. Below is the part of the code. What I am trying to achieve is to have a step that will check is the user...

Hello guys, can someone help me to get this code work, it just freezes whenever I run macro.. and in detail: I have the code below which I got from internet and it is used to get data like subject, received time, sender name etc from specific date which I give as input later I tweaked it to...

Hi there, I have a macro file that extracts emails out of excel, strips each one of its important data points and then copy pastes the data into a central file. The macro works fine from my pc, but when I try and set it up on the server, the file starts to extract emails but then hangs without...

Hi there, I have a macro that extracts all outlook emails into an excel file. Is there a line of code or a setting that I can adjust to bypass Outlooks security popup that prompts me to "Allow" access for 1 minutes? Code as follows: Sub GetFromOutlook() Application.DisplayAlerts = False...

Hello, in the second macro - forecast_day_2, it does not pull the values. the forecast_day_1 it returns them all - is there any obvious errors with this pulling of values into my spreadsheet? Many thanks Dim myvalue3 As Variant Dim destcell As Range, r As Long Dim fileSpec As String...

Please help, I need to condense the below and also to ignore if the file cannot be found: Many thanks! Sub Forecast_AllDays() Dim destcell As Range, r As Long Dim fileSpec As String, folderPath As String, fileName As String FD =...

Hello, I have the following code which successfully pulls data from closed workbooks. Is it possible to edit it so if it does not find a file stored in the folder then it ignores it? Many thanks. Sub Forecast_Weekends() Dim destcell As Range, r As Long Dim fileSpec As String...

Hi there, The following code works on Excel 2013 but wont work on Excel 2010: Sub GetFromOutlook() Dim OutlookApp As Outlook.Application Dim OutlookNamespace As Namespace Dim Folder As MAPIFolder Dim OutlookRecipient As Outlook.Recipient Dim OutlookMail As Variant Dim I As Integer Set...

Hi, I have a macro that pulls emails from Outlook Express into Excel. It can only pull emails from my personal inbox though. How can I adapt it to pull emails from a shared inbox? Dim OutlookApp As Outlook.Application Dim OutlookNamespace As Namespace Dim Folder As MAPIFolder Dim OutlookMail...

Hi, I have the following code to extract emails from Outlook into Excel. I can extract emails from my personal inbox, but would like to be able to point the file at a shared inbox instead. What would I need to add to the code to make it extract from a shared inbox? Dim OutlookApp As...

So I have a very large worksheets(400000 + in length 8 variables) that have the price for a stock and i want to organize it into a worksheet where all cells are side by side. I trouble shooted through until I got it to work for about half of the data set until it said overflow error. I check to...

Hello, Just starting off by saying thanks to Joe4. In a prior thread I asked a question on how to fill the first empty cell in a range with the word "done". Joe4 gave the following answer which works great: <code> Sub CommandButton4_Click() Dim dfR As Range Set dfR =...

Hello, Hope you are well. I have an userform multipage which has nine textboxes. When I click a button the code should check whether range A11:I11 is empty and place the values of the textboxes in the cells. If it is not empty the code is offset by one row and checks again. If the button is...

Hello, How would I alter the following code so that I could get the sum of F12:H12, rather than just the exact cell H12? destcell1.Offset(r, 0).Value = GetCellValue(folderPath & fileName, "Forecast", "H12") Many thanks.

Hi!!:) Please I need your help I have the next code which generates .ics file. I need in advance to sort by date in column B. Can you put that in the code? Also I need to to save the file ics in the current directory Can you help me modify this code? Thanks in advance Sub Calendario()...

I have written the following code that extracts several pieces of data from all the worksheets in that file. How can I modify the code (which I can move to a separate workbook, that would cycle through all the workbooks in a specific directory, creating one table of data for all the workbooks...