Share tech news, updates, or what's on your mind.

Sign up to Post

How do I search old questions I have asked?
[Webinar] Cloud Security
LVL 11
[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

My OS is win 10 prof 64 bit and I have the Office 365 suite.  From time to time there are some very informative articles or solutions on EE, and I would like to ask the Experts what is the best way to save them to read them offline.  For instance how do I save the article on Risks of Bitcoins - Don't Get Virtually Mugged by Terry.  And of course there are links in the articles to other articles which I would want to follow thru.  What is the best practices for this.  Thank u for your inputs.
I have two tables.

Table1 looks like this:


Table2 looks like this:


I need a query that will take each line of Table1 and insert into new table (Table3) by taking each line from Table1 and use the sequence from Table2.

Table3 should look like this:

PartNumber            Country
123456-001             AA
123456-001             BB
123456-001             CC
123456-001             DD
123456-001             EE
122334-002             AA
122334-002             BB
122334-002             CC
122334-002             DD
122334-002             EE

Can someone please provide a query that will provide the resulting table?

I am new to Experts Exchange, I came across it when searching the internet for help with VBA UserForm coding.  I landed on  which not only answered my search but helped me to complete my UserForm.  Basically, the form on that thread was exactly what I was doing.  So I downloaded the solution and set about completing my form, copying and editing the code.

All was going well considering I haven’t used VBA for years (10+) and my coding skills are a bit rusty.  My problem is when I test my form I get “runtime error 9: subscript out of range” for the SEARCH, ADD and UPDATE buttons.  Set ws = Sheets("Sheet4") seems to be causing the problem.

I’ve also noticed that if I start the form from any other sheet than the sheet with the data in it the form is basically empty.  Since I have set the Workbook to open on the USER GUIDE sheet, as this has a button to open the form, this causes a problem.

Well as I say I’m a bit rusty and I’ve been at this for days, reading and re-reading the code, search after search online as well as VBA Help, and now I think I have gone code blind (can’t see the wood for the trees) and my rusty skills are making it hard to find what’s wrong.  If someone could take a look at the attached file and point me in the right direction I would be most grateful.

The above thread was solved by …
New Here. Will I receive email notifications of replies to my posts?
when i view the EE questions list, everywhere i move the mouse  - it causes popups to appear, usually in front of the questions i try to read - very frustating
can this popup be disabled?
I am new in this Crystal Reports thing and I have problem, since my coworker usually doing this stuff is sick at home I need to figure it out my self. I have 2 tables.

First is like this:

Article.ID Article.buyingprice
1              aa           2.00
2              bb           1.00
3              cc           3.50
4              dd           4.20
5              ee           2.00

And second is like this:

Income.ID Income.article  Income.number Income.quantity
1          2               79100        P1            2.00
2          1               79100        P1            3.00
3          4               79101        P2            2.00
4          3               79101        P2            1.00
5          1               79101        P2            4.00
6          5               79101        P2            1.00
7          2               79103        P3            15.00

What I need is formula for selecting Income.quantity from the latest Income document. For example for article aa it will be 4.00 and for article bb it will be 15. Please save my job folks :)

Report is grouped by
I sometimes log into Experts Exchange (EE) from my phone using my phone's browser, typically if I see an interesting question in an email and click the link.

My default browser is Ghostery although Chrome is also on the phone. For a long time there was no problem logging into the EE site. A couple days ago I noticed that I cannot log into the site through Ghostery. I get either an unknown user or an incorrect username/password error message. But I can log into the EE site through Chrome with no difficulty.

The phone is a Samsung Galaxy Note 3 running Android 5.0. A couple changes on the phone recently: I installed the LastPass Premium password manager app (but I am entering the EE username/email and password manually.) I recently uninstalled and reinstalled Ghostery.

Ghostery is set to accept cookies. I don't see other Ghostery settings that seem likely to affect the login but perhaps I am overlooking something.

Any suggestions what to try so that I can once again log into EE with Ghostery?

I have a newly created Experts Exchange profile and would like to import my LinkedIn profile.  When I click on Import, next to LinkedIn Profile under Profile Validation, I get the window to enter my LinkedIn sign on information, I click Allow Access, another window pops up and that is where it stays.  Nothing more happens.  Is there a setting I need to update in my Experts Exchange profile to get this to work?ImportAllow AccessEmpty Window
Thanks in advance.
I just noticed this seems to have changed with EE, as I Googled a question and noticed one of my EE posts showed up. I don't want that to happen. Previously EE gave a setting that caused the questions to not be searchable on Google.  How do I get back to that?
Keep up with what's happening at Experts Exchange!
LVL 11
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

How do you attach files to programming questions

I might buy a subscription to Experts Exchange again but wonder what advantages it offers and, especially, if there is expert support for Powershell Studio.
I have a tool made in it which I would like to customize a lot and would need specialists in PS Studio.

Pls advise.
I can search the whole site, but only seem to be able to browse my past qs, how can i search by keyword?

It is really frustrating for someone to come into live and try to get an answer out of you in the 5 minutes, only to not want to pay for an answer... I usually suggest that people just put it in as a question....  Am I the only one aggravated with this?  It seems like EE get's their $$ and I get nothing but headaches...

Is there a way to download all my questions from 1998 ?  in a pdf format ?

Best Regards,
I would like to apply for the scholarship in which we can submit original technological works?
I have submitted Selenium and Eclipse questions and they were never answered.  
There are many topics that are "Proposed."
My assumption is that EE does not have Experts for these topics.  Is my assumption correct?
Hello  ee and users

i'm aware EE needs income, and uses advertisements for that.
however, since i'm considered an "expert" - whatever that means, i think i have a right to an EXPERT vieuw also.
imo this means that i get info on my display - NOT adverts
you also see lost space between questions, and each embedded in a nice comment box
can i not have the old style "foldingpaper" as used around 2000-2005 ?   that was expert vieuw for me !
as an example i post a screenshot of an EE page on my 19" monitor

Is there is a way to link to a specific post in an EE thread?

I can see that URLs for EE threads have five parts:

1. The Experts Exchange web address (
2. The word "questions" (questions/)
3. An 8-digit thread ID (12345678/)
4. The thread title separated by hyphens (This-is-the-title)
5. And the extension (.html)

However, it seems like in the past I've seen an additional part (like a sub-extension) added to the end of the URL which directs you to a specific post in the thread. Is that correct? And if so, what convention is used or how do you determine the sub-extension?

And I guess I should add a "sub-question" which is: What are the correct terms for the parts mentioned above?

Free Tool: IP Lookup
LVL 11
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have submitted articles. How can I ensure that they get reviewed?
on ee how can i upload image on ee android 7 app

Is there some kind of method or trick to prevent images inserted into a thread on EE from taking up so much space?

Some images contain small details or were snipped from a large area of the screen and therefore having them displayed as large as possible in a post is probably helpful — although any image can be enlarged by double-clicking. However, many (and imo, most) images appear much larger than is needed. This seems to be the case no matter what size the image is originally. The result is often a distraction and breakup of the flow/continuity of the post.

Case in point:

A screenshot from Excel was used at the beginning of a recent post located here:

The following image shows the original spreadsheet superimposed over the image from the underlying thread (ie the row headings on the right belong to the original spreadsheet while those on the left are from the image in the thread). As can be seen, 21 rows in the original correspond to only about 14 rows in the thread — representing an increase in image size of ~50%.

Fig. 1
The absolute image size is huge but that is especially the case relative to the spacing and font size used in the thread.

Hi Team

Please help understand what is Premium Account all about.
How much it costs?
What is the validity period?
Can I get the list of courses available for Premium Account?
Can I download these courses/videos for future use?

I have been away from EE for several years.  I am trying to find out how to determine, in a fair and equitable manner, how many points to award someone who answers the question.
I want to search through only my past questions. How can this be done on Experts Exchange?

Experts Exchange






We connect you with people and information to solve problems, inspire learning and influence the future of technology.