Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Sep 16, 2025
Topics: 61 / Replies: 1581
Reply
RE: Cancel password for excel file

Hi Lea, So you mean encrypted as in you encrypted it in Windows using BitLocker or EFS? Or is it just that the file is password protected? Rega...

7 years ago
Reply
RE: How to start a Music Song without the Windows request

Try unchecking the box beside this avvisa sempre prima di aprire questo tipo di file

7 years ago
Forum
Reply
RE: INVOICE MACRO - DISPLAY MULTIPLE ITEMS PER INVOICE

So I think what you want is to show all the items with the same Inv number on the Master Sheet, on the same Invoice template?

7 years ago
Forum
Reply
RE: VBA to sum up total value of loop cycle time

Hi Shila, The data in the Date(x) and Time(x) columns are text. Your date format in the regional settings doesn't mean you can use text as dates. ...

7 years ago
Forum
Reply
RE: Forecasting

Hi Dinesh, Welcome to the forum. Just a few rules to follow so that it makes it easier for us to help you. Please don't post the same question ...

7 years ago
Reply
RE: how to return each duplicate value when applying vlookup

hi Nalaka, there's no image attached to your post. Regards Phil

7 years ago
Reply
RE: compare macro

Hi Amy, I've replied to you by email. Regards Phil

7 years ago
Forum
Reply
RE: VBA to sum up total value of loop cycle time

Your dates and times are still text. If you actually make them dates/times you'll be able to do your calculations. Regards Phil

7 years ago
Forum
Reply
RE: VBA to sum up total value of loop cycle time

Hi Shila, I'm not really clear on what your objective is. The values you have in the columns headed Date and Time aren't dates or times, they ar...

7 years ago
Forum
Reply
RE: Create and Name PDF

Good job Bob. The joy of coding. A single character in the wrong place can break the whole thing.

7 years ago
Forum
Reply
RE: Web report - open the report page by using explorer.

Hi Tina, I'm not really clear on what exactly you are asking - how to create a report you can open in a browser, or how to open that already create...

7 years ago
Reply
RE: Copy and Paste a sheet from One Workbook to Another

Hi Ken, If you were stepping through using F8, but you had error checking turned off, you wouldn't see any of the generated errors. Cheers Ph...

7 years ago
Forum
Reply
RE: If Formula question

Hi Brittany, In I2 you just need =H2 Regards Phil

7 years ago
Reply
RE: Problems with Print Area while converting to PDF

Hi Blanka, The PrintArea property requires a string data type, not a range I've modified the code so it works in both of the workbooks you suppli...

7 years ago
Forum
Page 99 / 110