Recent Questions

The entire BlueGriffon Tutorial has been updated for the version 3 series of BlueGriffon. Those thinking of using it to create a website can find the complete series online....

This article deals with how you can reset the default positions and sizes of the various panels/sections in Expression Web so that the web editor appeared as it did when you first ran it....

I want to get with my ID the matching string, I am trying to accomplish that with a VLOOKUP =VLOOKUP(L2;Tree_Matchingnode!A:B;1;0) The Table that I am doing the Vlookup looks like this: +----------------+------------------+ | Parent_TREE_ID | Parent_TREE_NAME | +----------------+------------------+ | 1 | | | 2 | | | 3 | | +----------------+------------------+ The Matching tabel looks like this: +----...

Used this AMI ami-b7418dd7 followed this guide: https://docs.openvpn.net/how-to-tutorialsguides/virtual-platforms/amazon-ec2-appliance-ami-quick-start-guide/ Now, when a user connects to the VPN I want all of their normal inteet traffic to go through the public inteet, but when they are trying to access one of our inteal systems I want that traffic to go through the VPN. How? I've seen a lot of other answers, and I've found very few of them helpful. On this official AMI from openvpn, I can't fin...

I am using Windows 10 (well, the version is irrelevant I believe) and I would like to execute my programs through 'Run' just for convenience. My problem is, where do I look for each software's Run keyword ? For example, to open paint, you can run 'mspaint', to open Notepad++ I luckily figured out you can run notepad++ but what about other processes ? For example, I have no clue how to open Sublime text 3 with Run or paint.net and many other software. If you are willing to help, please also provi...

On some Windows environments (Windows 7 and Windows Vista), I have some scripts running and one of the things those scripts are doing, is trying to copy files. The results of those commands are logged in a logfile. While looking into that logfile, I've just seen the following result: The system cannot find the path specified. This obviously is not very helpful (which file does he try to copy, to which directory, ...), so I would like to replace the existing copy commands by xcopy or other com...

I hope this is the right place to ask this. My University lets students download a preconfigured executable of OpenVPN, where the settings are already branded in. Once you installed it, you just enter your credentials and you are connected. However, I noticed that it doesn't work anymore after the system is has been installed on is rebooted. If I install it, I get a successful connection with the VPN and can use it. If I restart my Laptop, it does not work anymore, but the Icons in the Tray stil...

So I have been trying to add refrenced cells but each time I input the sum formula is get 0 as an answer. I did a search online and realised that I'm to use the indirect formula but I just cannot make head or tail of it. At best I am able to retrieve one number but my intention is not retrieval alone but adding the numbers in the refrenced cells. Any help will be greatly appreciated Oops I cannot post pictures at the moment but I hope the description of my headache will be understood from the th...

I spend two days trying to compile my code with header as cross compiler for OpenWrt I am using LinksysWRT54GL, and mipsel architecture. I download the libpcap from OpenWrt and tried to generate the MakeFile using ./configure --prefix=$TOOLCHAIN --build=mipsel-openwrt-linux-gnu --host=mipsel-openwrt-linux-uclibc --with-pcap=null and I got this error when I ran make pcap-usb-linux.o: could not read symbols: File in wrong format collect2: ld retued 1 exit status make: *** [libpcap.so] Error 1 ...

In OneNote 2013, let's say you're currently editing some text in a regular text box/field: Now I want to exit this text box and move the cursor somewhere else on the page. Pressing Escape doesn't work, neither do the usual suspects (Ctrl+Enter, Alt+Enter, etc.). Can I exit the box with a keyboard shortcut of some kind? I have looked at the official page for OneNote 2013 keyboard shortcuts to no avail. Let's block ads! بخوانید...

I am using a spreadsheet that contains constant data; I would like to be able to populate the cells on another spreadsheet with this data when a condition is true. I.e. The target spreadsheet is used to prepare estimates. When the user selects a predefined price quote from the spreadsheet containing the constant data, I would like to move this data to the Estimate Spreadsheet. Any assistance would be greatly appreciated. Jamie Let's block ads! بخوانید...

I have a list of data that I need to rearrange in a specific way in the next sheet. I want to make the data to automatically be inputted to the next sheet as below as the total data is actually a lot and it takes time to do this by transposing and copy pasting to the correct order. Is it possible to make the data be arranged as such automatically by functions/macros? Let's block ads! بخوانید...

Can someone please help me generate a list of people that hit their targets for different days, when they hit both of their targets a '2' will show in either the Y column or Z respective if they are early or late shift. i would like everyone that gets a 2 on their shift to be listed. Here is the Data Here is the outcome I am attempting Let's block ads! بخوانید...

I recently opened ~70+ Excel files all at one time (it was a massive data dump from a database which I was going to be locked out of in about 30 minutes, so I wanted to grab everything I could conceivably need). Unsurprisingly, my Excel crashed from the load. Upon restarting Excel, the Document Recovery pane opened and showed me all of the files. Is there a way to automatically have all the files in the Document Recovery Pane open up? I don't want to have to manually go through and open up 70+ d...

I have a Dell Inspiron 15 laptop with factory-installed Windows 8, upgraded to Windows 8.1, and later to Windows 10. Since I have purchased a new computer, I decided to perform a factory reset on the laptop (using the Remove files and clean the drive option) in order to repurpose it. It reset flawlessly on the first try in about 5-6 hours, and runs perfectly now, but with only one issue introduced after the reset that wasn't present before: the laptop now powers itself on from a shut-down state ...

Why is my mac (Snow Leopard) asking me for installer changes (system.install.root.user) by itself? I do not recall doing anything to enable this. I feel like someone is trying to hack into my computer. I hope it is a false feeling. ...

I have a table which contains multiple references per cell separated by a blank space. In an other table that contains one line per reference, I want to use VLOOKUP to retrieve the name of the component which is linked to each reference. Here is an example of my first table: And here is the result I'm trying to achieve: Use VLOOKUP of the reference to get the component name in the first table. I cannot get it to work as the number of references associated to a component is not constant. Let's ...

I am seeking help in working out a couple of excel formulas. I have included a snip of the data that I am working with and the outcome that I am seeking to streamline with the use of formulas. Ignoring column A. I want to copy the values from B & C but there are duplicate values in column B which I want to ignore, unless the value in column C is different for the value in column B. So I want to get the values across from B & C as per columns F & G). Then I want to sum the values fro...

I'm working on a VBA that pulls objects itemized in a spreadsheet in hopes of creating a mail merge that sends each attachment separately to the same email. The email group receives the emails but without the attachment. Can this be done? ...

today i tried to install openSUSE Leap 42.1 on a SD-card. I used a USB stick as installation medium. So far everything has gone well. The installation finished without any problems. Then I went to the Bios to select the SD-card as Boot Option #1. But I couldn't find the SD-card there! What do I have to change in order to make the SD-card appear in the BIOS? Thanks for your help! Let's block ads! بخوانید...