Forum

Hi Bill, you need to modify the declarations and data types as described in this article Private Declare PtrSafe Function SHBrowseForFolder ...

Hi Riste, Times and dates are stored as 'serial' numbers in excel so if your time is in A1 you can use =IF(AND(A1>0,A1<0.25),1,0) This ...

Hi Stefan, If you leave the week number column in the source data table you can use a pivot table to summarise the data as you wish. There are som...

Hi Maurizio, Thanks for letting us know. Regards Phil

Hi Luna, If you provided your workbooks it'd be easier to see what is going on. We also don't know how the source file and table are generated/mod...

Hi Mido, I've created a new sheet and a table on that sheet to keep track of what emails have been sent. The records will show the person's name...

Hi Wansley, Please see attached. Do you want to be able to turn off highlighting on a per sheet basis or for the whole workbook at certain times...

Hi Deepak, I can't really test this without Foxit. But why not just convert the whole PDF then delete the first page in Word? See attached. ...

Hi David, You can use FileSystemObject to create folders. This post has some code you can adapt Regards Phil

Hi, The total for Plant where Material is 1001 should be 36004, and where Material is 1002 it should be 27000? You haven't said where you get th...

Hi Scott, Welcome, please refer to forum rules Please start your own topic rather than tag onto the end of an existing thread. Please suppl...

Hi Deepak, Please review the forum rules and guidelines When you have a new question please start a new topic, don't post onto the end of an e...

Hi Zaki, You can't conditionally format a chart. You'd need to create another series for data points that go beyond a certain value and plot those...