Forum

Hi Nathan, Can you please supply your workbook. It'll be easier for me to understand what you are trying to do if I can see the sheet(s). Regar...

Hi David, If you type xcopy /? in the Command Prompt you get all the help info for xcopy that tells you what the switches do. /s Copy directorie...

It depends on what files you want to delete. If it is ALL files of a certain type or name you can use del *.XLS* /s but that will delete ALL files th...

Hi Bruno, See attached file for solution. Query result is loaded onto Sheet1. Regards Phil

Hi David, Use xcopy from the Command Prompt - much easier as it already exists. I assume you are using Windows. Click on the Start/Windows butt...

Hi Amien, You need to use Power Query to get the data into Excel from Sharepoint. That will fix your problem with dates in text format. To illus...

Hi Al, No file attached. You have to click on Start Upload to upload the file. Phil

You're welcome.

Hi Amien, No file(s) attached. You need to click on the Start Upload button. Without seeing your data I can't be certain but you my benefit for...

Hi Walid, What is it you are actually trying to do? Why are you copying data to a new sheet or workbook? Can you please supply your workbook(s)...

Hi Walid, I wrote a post on this Plot real time data in Excel and recently answered a question on the same topic How to plot live data in ...

Hi Marsil, Insert this snippet into your code after you've created objOutlookMsg Dim Account As Outlook.Account For Each Account In objOutloo...

Hi Dave, No files are attached. You need to click on the Start Upload button after selecting the files. Regards Phil

No worries 🙂

Hi Faha, PQ won't be able to get that data because the data is generated by JavaScript and isn't stored in a <table> element on the page. ...