Forum

Hi Kevin, If you use Catalin's code but modify this line to open the text file as UniCode rather than ASCII you might find it keeps your accented c...

I think the issue is more to do with the DB being in the USA than you using VBA. If you are doing database operations remotely like that you must exp...

So attaching a workbook with VBA (SQL) in it to your forum comment gives you an error? Have you clicked on the Attachments button below and tried add...

No worries Steve

Good job Alan, well done 🙂 For anyone else reading this, this article might help Excel IF AND OR Functions

Hi Hooi Thin, I'm not sure why you can't add the SQL (it's just VBA in a workbook). In your loop you are doing a SELECT, so you are doing that 5...

Hi Steve, You're doing a string comparison with Add1.Text > Available1.Text rather than comparing numeric values. Try using the Val() functio...

I am not familiar with your dat files structure which is why I need to see examples. Even with the data you supplied above it's not clear what the...

Hi Blue, I'd be looking to use Power Query for this. I'd need to see some examples of your files before I could offer any more. Regards Phil

Hi Ivica, We'll need to see some of these DAT files to understand how the data inside them is structured. Can you please supply some. Do you wa...

Hi Jatin, The code here loops recursively through all Outlook folders Regards Phil

Hi, If your data starts in A1 on both sheets then you can make use of implicit intersection and the formula =INDEX(Source[[Column2]:[Column4]...

Hi Larry, This code will do what you want. It uses FillDown to fill an empty cell with the value above it Sub FillDown() Dim i As L...

Hi Stefano, Try the attached file. regards Phil

Hi Larry, You can use something like this Sub copystuff() Dim i As Long i = 0 While Range("A1").Offset(i, 0).Value &l...