Forum

Hi Christine, This post has code that creates PDF's VBA to Create PDF from Worksheet and this one has code to automate Pivot Tables VBA to...

Hi, The 3rd word in your list is cats and ~c?t matches the cat part, so replacing cat with cass you get casss cats casss Regards Phil

Hi, All posts from non-course members are moderated. We don't sit in front of our PC's all day, so sometimes approving posts takes a few hours. ...

Hi Robert, This might sound odd, but why would you want to do that? It breaks the ideal tabular data format. You should have dates in a single co...

No worries Stan, glad you figured it out. Regards Phil

Hi Mohamed, I'll need to see the text file(s) and an example of what you want the resulting table to look like. Without these I can't write a quer...

Hi, Try this Workbooks.Open Range("A1").Value & ".xlsx" Regards Phil

Hi Stan, Please supply your workbook and query, and some source data. Phil

Hi Bob, Please attach your file for me to check. Thanks Phil

Hi Bob, I don't think you are using RemoveDuplicates correctly- did you read the link i posted? RemoveDuplicates removes duplicates from a range...

Hi Bax, You can rename the column by referencing its position rather than its name #"Renamed Columns" = Table.RenameColumns(#"Promoted Headers"...

Hi Francis, Please see attached. This query is fragile in that slight changes to the structure of the PDF will break it, but for the example you p...

That said, the Columns array you supply to RemoveDuplicates is a list of the column numbers that contain duplicates so if email is 200 then Exc...

Hi Bob, Debug.Print prints information to the Immediate Window in the VBA Editor/Debugger. So Debug.Print Range("A1").DisplayFormat.Interior.Color...