Forum

Hi Nz, Power Query does not have suport for OneDrive (yet), but there is a solution to get data from onedrive cloud. Here is how: You need the HTM...

Can you share a link to your online workbook?

You mean that the Slicers itself are protected and you cannot make any selections? If so, right click the slicers, click on Size and Properties , and ...

Hi Maurizio, This is a forum with members from all corners of the world, we have to use a common language to understand eachother. We expect a c...

Yes, you got it right, Power Query is the best for importing and transforming data, loading the queries to data model for Power Pivot is the next natu...

Hi Maryland, Sorry for the late answer. Can you please upload a sample file with your setup? @David: how did you came to that conclusion? J...

Frans Visser said Only thing is you have to be careful about what you search for. In the case Meyanui brought in, he rightly said that the 10, 200,...

Try changing these 2 lines: Dim NewFile As Variant NewFile = WindowsMediaPlayer1.newMedia(Text1) Or, you can try this version: Pri...

Can you upload a sample file?

Hi Cheryl, Try to do that from sheet, not from Query window. Show Queries Panel, then right click the query and choose Load To to open the Load settin...

Dim NewFile as Object, instead of variant, this should be the problem.

Hi Julian, I think you have to build the playlist first, then you start play. Try: Sub test() Dim NewFile as Variant Range("A2").Select Do...

Hi Meyanui, Another option is to go to Excel Options>Advanced, and clear the box that says: Show a zero in cells that have zero values. If th...

Hi Tony, I think there is something else you can try: You already have a tool for creating Self Signed certificates. (search your computer for "...

It's possible, see this link: other/installation-of-office-2007-2010-and-2013-on-same-pc