Friday, January 28, 2011

Broken Blood Vessels Lips

VBA - Excel" Navigating between spreadsheets "

 Ecco quali comandi usare per navigare fra i fogli di calcolo in excel usando VBA 

A) Muoversi in uno sheet specifico:

Sheets("nome del foglio di calcolo").Select

'selects the spreadsheet under the name you assigned

B) Moving in a sheet using specific variables (or Index Value Index Value)

The rule is this: for the first excel spreadsheet (the one all on the left) takes the value 1, the second 2 third 3 and so on. No matter how you call them, if you moved, changed or deleted: the spreadsheet will always have more left to excel value of 1, 2,3,4 etc. others to follow.

said:

Sheets (1). Select 'Select the spreadsheet more left
Sheets (2). Select' Select the second
Sheets (3). Select ' Select the third and so on
  C) Move to the next or previous sheet  

ActiveSheet.Next.Select ' Select the spreadsheet next
ActiveSheet.Previous.Select 'Select the spreadsheet precedentre

Hello to the prox.
Meats: v





Tuesday, January 25, 2011

Legal To Drink In An Rv? Wa State

Download all your facebook profile on your PC



you afraid that one day explode the interweb? that Facebook is demolished by Hacker Indians fan of Orkut? Or that will be acquired by the Vatican and in all your photos will appear horns and pitchfork?

All these fears are pushing you to want to save on your PC throughout your profile, chat, Scaboro photos, videos and links?

Here's how ....

1) Account and go to "Account Settings"
2) level of the 'download your information, "click on" more information "
Questra window will appear:


3) Click on download

At this point, expect a few questions to verify that you are just you and an email where you will be given a link to download the profile. The format is minimalist chic, but that's okay, crazy!

Meats: v

Monday, January 24, 2011

Horse Hair Bracelets Uk

VBA - Excel-Working with strings

I'm working on a routine that I automatically reprocessing in pdf (posterity if I'll make it) all files in a directory. I used to write in different operations with strings. I decided to summarize them here.

function
Description
Example
Result
Len () Determines how long a string of characters
MyVariable = Len ("ASD") 3 (characters)
LCase () Converts the string to uppercase characters to lowercase MyVariable = LCase ("ASD") asd
UCase () Converts characters to lowercase in uppercase VarName = UCase ("ASD") ASD
StrReverse () Reverses the string MyVariable StrReverse = ("ASD") dsa
Left () Extracts the first (n) characters in a string MyVariable = Left ("ASD" 2) As
Right() Estrae gli ultimi (n) caratteri di una stringa variabilepippo = Right("Asd", 2) sd
Mid() Estrae i caratteri (n) di una stringa, partendo da un punto specifico
variabilepippo = Mid("asdlol" 3,4)

NB 3 = parti dal terzo carattere compreso
NB 4= ed estrai 4 caratteri
dlol
InStr() Trova una parte di stringa su un’altra variabilepippo = InStr("asd", "d") 3
LTrim() Elimina tutti gli spazi iniziali variabilepippo = LTrim(" asd ") "asd "
RTrim() Elimina tutti gli spazi finali variabilepippo = RTrim(" asd ") " asd "
Trim() Elimina tutti gli spazi iniziali e finali variabilepippo = Trim(" asd ") "asd"
CStr() Converte in una stringa un numero intero
variabilepippo = CStr(10) "10"
*CInt() Converte in numero intero stringa
variabilepippo = CInt("10") 10

alla prox :v

Wednesday, January 19, 2011

Is Wowogolf Legitimate?

WD Live TV adapters and wireless / wifi compatible


Per chi non lo conoscesse questo è un WD TV Live, WD sta per Western Digital, l'azienda che lo produce . Il WD TV live attaccato alla televisione vi permette di vedere dei contenuti multimediali direttamente sulla TV:

1) -o leggendoli da una memoria di massa (chiavetta USB, Hard Disk esterni, ecc.) che dovete attaccargli, USB port;

2)-or by reading through your home network from a device in the network (eg I multimedia content in the folder C: / Torrent / XXX from my PC, which I share on my local network, the WD reads them and makes them see me on TV).

3) - or directly from the Web, but it only works for youtube (good shit, and magavideo?)

For cases two and three or unable to attack a network cable to your TV or need a wireless adapter (known as a key wi-fi).

WARNING! Not all are compatible

so ... look at the list below before buying one.

compatible adapters il WD TV Live

Adapter Model Version/Revision
Airlink Golden 150 AWLL5077 Rev 0200
ASUS Wireless USB adapter USB-N10 Rev 0200
ASUS 802.11 Nework adapter USB-N13 Ver 1.10
New! AZIO Wireless USB Adapter AWU101N Not Listed *
Belkin N1 Wireless USB adapter F5D8051 V3100
New! Belkin N1 Wireless USB adapter F5D8053 V3001
Belkin N1 Wireless USB adapter F5D8055 v2
Belkin N 150 Wireless N F6D4050 Ver 1000
Buffalo Wireless N compact USB 2.0 Adapter WLI-UC-G300HP Not Listed *
Buffalo Mini WLI-UC-GN US
Buffalo Wireless N compact USB 2.0 Adapter WLI-UC-G300N Not Listed *
Corega Mini USB Adapter CG-WLUSBNM Not Listed *
D-Link Wireless 150 USB Adapter DWA-125 Version A1, FW 1.00
D-Link Wireless N Nano USB DWA-131 Not Listed *
D-Link Rangebooster N USB Adapter DWA-140 V1.30
D-Link Xtreme N dual band USB adapter DWA-160 Not Listed *
EnGenius Wireless N adapter EUB-9701 Not Listed *
EnGenius Wireless N USB adapter EUB9706 Not Listed *
Hawking Wireless N USB adapter HWNU3 Not Listed *
Hi Power Wireless USB Adapter GW-USMicroN Not Listed *
Hi Power Wireless Mini-USB Adapter GW-USMini2N Not Listed *
Hornettek JANUS GW-USMini2N Rev 0200
Level 1 Wireless USB adapter WNC-0600USB Ver 2.00
Linksys Rangeplus wireless network USB adapter WUSB100 Must have no revision number
New! Linksys Rangeplus wireless network USB adapter WUSB100 V2
Linksys Wireless-N USB network adapter with dual-band WUSB600N Not Listed *
Linksys Wireless-N USB network adapter with dual-band WUSB600N Ver 2
Netgear Netgear wireless USB adapter EVAW111-100WWS Not Listed *
Netgear RangeMax Wireless-N USB Adapter wn111 Not Listed *
Rosewill Wireless N adapter RNX-Easy-N1 Rev1.00
Sitecom Wireless Dualband USB Adapter WL-329 V1 001
SMC EZ connect N SMCWUSB-N2 Not Listed *
TP-Link Wireless N USB adapter TL-WN821N Ver 2.2
Trendnet Wireless N USB adapter TEW-644UB V1.0R
Trendnet Wireless N USB adapter TEW-645UB Not Listed *
Trendnet 300Mbps Dual Band WirelessN USB Adapter TEW-664UB V1.0R
ZyXel USB Client Adapter NWD-210N Not Listed *

Io ho questa, 20 euro al mediaworld:

D-Link Rangebooster N USB Adapter DWA-140 V1.30

ciao :v

Is Digital Foto Club Legit

VBA - Find and Replace

"A simple routine in VBA to find text within a cell and replace it with another"

Today I found myself having to delete from an excel file with 25,000 records speficica a word. In a column, in addition to a date to me is useful for later analysis, there is the word ASD.

For example:

11/05/1979 04/11/1979 ASD ASD ASD
06/11/1979

...



The alternative is to use the classic VBA Find and Replace, Find in place where "ASD" and replace left blank.

Since I decided to automate things complete a routine for this little banalità.Eccola:


Sub togliasd ()
Sheets (1).
Activate Cells.Replace What: = "ASD", Replacement :="", LookAt: = xlPart, SearchOrder _
: = xlByRows, MatchCase: = False, SearchFormat: = False, ReplaceFormat: = False End Sub


Let us see in detail step by step:

  • Sub togliasd () -> initialize the routine and the call "togliasd.
  • Sheets (1). Activate -> On the spreadsheet I'm interested in, the first in order of appearance, alternatively, you can put the name you gave the sheet instead of # 1.
  • Cell.Replace -> refers to the replacement function
  • What: = -> The parameter that indicates what you want to replace. The thing must be entered after the equal sign and quotation marks "ASD".
  • Replacement: = -> The parameter that indicates what you want to replace. The thing with that, always after the same and always in quotes, in this case is void, then between the "do not write anything.
  • SearchOrder: = xlByRows -> Search order indicates how research should proceed, if you line by line (xlByRows) column by column ( xlByColumns) . In this case line by line. NB (the underscore _ is used to wrap)
  • MatchCase: = False -> Indicates whether the search should be case sensitive or not. That is, if it considers that uppercase and lowercase are the same thing or not.
  • SearchFormat: = False -> attribute is a further research. In particular, we can select the format of the cell ...
  • ReplaceFormat: = False ->... and replace it with one made here.
  • End Sub -> conlude routine.
Hello: v


NB: For the perfectionists
conscious clock cycles ... and for those who want to replace a specific word in a single column or a specific selection, add after Sheets (1). Activate:

Range ("A1: R99"). Select -> select the cells rettangolone from A1 to R99

or, in case you want to select one or more columns ...

Columns ("x: y"). Select -> x and y replaced with the range of columns you want to select eg: B: Z "and a single column B: B

ari hello: v

Tuesday, January 18, 2011

Instruction On How To Makea Tech Deck Ramp

Dlink DWL 700 AP to use as a bridge / repeater

Abstract:
this procedure also applies to the dlink following models: DL524, DL524UP, DL624 Rev.C, and clearly DSLG604T DWL700AP.

________________________________________________________________

I have this access point for years, for a time 'was in the cellar replaced by the classic HAG Fastweb.
I recently had the need to repeat the signal wi-fi in a "dark" of the house. This
valid, albeit dated, unit has played the role perfectly.
configuration mode bridge (or repeater) is fast and intuitive.


Finite presentations, let's see how:

A) Introduction (reset the Access Point D-link DWL700 AP)

If the access point has old settings that do not want to preserve or if not
remember the password to access them you need to reset it. On the official site are unclear information. With me it worked like this:

1) the unit is turned on, insert the tip of a pen on the back of the access point, in the little hole that says "reset". Hold for a period not less than 10 seconds (and no more than 20-25).

2) Disconnect power to the access point.

3) Put the tip of the pen in the little hole and hold switch. Wait for more than 10 seconds, still holding and the game is done.

B) Enter the access point
To configure the AP in repeater mode access is necessary. To make this

normally enough:
1) connect via network cable with the appliance or by accessing the wi-fi network.

NB "In the latter case, if you just bought or the resattato apperecchio or if you still have the standard configuration, the network name will "default" , the network will also be without a password, and then open and easily accessible. "

2) had access to network (cable or wi-fi) have to go into the address bar of your browser (Internet Explorer, Firefox, etc.) and type:

192.168.0.50


ie, the address of your Access Point's factory .

NB (for other models could be 192.168.0.1, 192.168.1.1 , 192.168.2.1)

If all va bene*, vi comparirà una schermata di richiesta di user-id (nome utente) e password.

La user-id è:

admin

la password è nulla, quindi lasciate bianco e premete invio.

*NB Se non doveste riuscire ad accedere al router, e quindi vi comparisse la pagina di errore invece di quella di richiesta della user-id e passowrd, leggete l'ultimo paragrafo ("problemi ad accedere all'AP").

C)Configurare l'Access Point in modalità Bridge / Repeater

Avuto accesso al router sarà necessario configurarlo in modalità "repeater", ossia che ripeta il segnale di un altro Access Point Wi-fi, the HAG Fastweb, for example.

Press Enter at the request of the Username and Password properly you should be in front of a screen like this.



A) Go in the "Home" (top)

B) and then in the "wireless" (left) as shown below.




C) In the drop-down menu "Mode" choose "Repeater"

D) Then click "Site Survey" and you'll be shown the network that are visible, looking for your (the one that you want to replicate the signal), select it and click OK!

E) In this punnto as shown in the image Next, the box should see your SSID network name of choice (in case you did not appear put a hand on your network is the monetary seen in the previous screen after you have clicked the "site survey").

F) Then lay the cornerstone of network security that you want to repeat the signal, making sure to select the correct type for Fastweb is now a WPA / PSK.


Click OK and you are done. :) __________________________________________________________



Other resources:
Here you will find manual and driver updates in English. Here
manual in Italian

_______________________________________________________________

problems accessing the Access Point (me error when I type 192.168.0.50)

It could happen that although you have reset the AP and you're connected to the network "default" when inserted into your browser address 192,168 .0.50 give you an error page.
In this case, try this:

1) Go to Control Panel
2) Click on Network Connections and Sharing center
3) Click on Manage network connections
4) Look for the network "default", right click and look for "properties", then click. You should see a screen like this.


5) Seek written Internet Protocol Version 4 (TCP/IPv4) and double-click.
6) In these ores point there appears a new browser window that you have set as described in the picture below that is:

-a) click the Use the following IP address
-b) IP Address: 192.168.0.100
-c) Subnet Mask should be alone in the house he did not put: 255.255.255.0
-d) Default Gateway 192.168.0.50 (do not remember anything?: v)


7) Click "OK" you should now have access.


Pe questions, comments below also under: /

Monday, January 17, 2011

How Soon Before Period Do Cramps Start

modern living less than 400 €!

I'm home decor and furniture for the living room on a budget of less than 700 €.

turning a bit 'to showrooms and stores, I realized that for a modern furniture design with a little' eye-catching, you spend more than € 1300 (among other things worse than having contracted in Marrakech, where prices starting € 2000). On that figure I can only choose the world convenient or ikea.

Well, I chose the second option after playing a bit 'with the planner Besta.

The Best Planner can be found here .

It is nothing but an interior design software, easy to use, mostly in Best, one of the most popular suite of furniture in the house of Sweden.

ikea found on the website already pre-designed compositions, ma vi accorgerete subito che non hanno un grande stile e mal si adattano a rendere il vostro soggiorno "unico".

Vi consiglio quindi di giocare un po' col planner e il vostro gusto per creare qualcosa di diverso.

Io vi proponggo il mobile disegnato da me che oggi adoro e mi è costato solo 374 euro!





Qui trovate le specifiche coi pezzi e i costi in un file scaricabile formato PDF, creato sempre col planner BESTA.

File PDF