re: "-Under control panel printers make sure your label printer is set as default printer."Another option is to capture the "normal" default printer, print the labels to the Dymo device and then reset the default printer, all within the macro. No need for a manual change each time you want to printRead more
re: “-Under control panel printers make sure your label printer is set as default printer.”
Another option is to capture the “normal” default printer, print the labels to the Dymo device and then reset the default printer, all within the macro. No need for a manual change each time you want to print a label.
Try replacing this section of AWTL’s fine code…
' Print sheet 2 to the default printer
Sheets("Sheet2").PrintOut
…with this:
'Print to Dymo Label Printer and go back to the original printer when done.
originalPrinter = Application.ActivePrinter
Application.ActivePrinter = "*** Insert Dymo Printer Name Here ***"
Sheets("Sheet2").PrintOut
Application.ActivePrinter = originalPrinter
To grab the system’s name for the Dymo printer, you can follow these steps once:
1 – Set the default printer to the Dymo device 2 – Open a new workbook 3 – Run this code
Sub GetDymoName()
Range("A1") = Application.ActivePrinter
End Sub
4 – Copy the string from A1 and paste it in place of *** Insert Dymo Printer Name Here *** in the code above, making sure that it is between the quotes 5 – Reset the default printer to the original default
re: "The amount in questions gets taken out of cell K21 I assume that means the K21 will either be 0 or not be zero. That's what your IF statement implies, so that's what the code checks for.re: "The results gets shown on cell R27" I changed the references to my example of A1 to be R27.BTW I also chRead more
re: “The amount in questions gets taken out of cell K21
I assume that means the K21 will either be 0 or not be zero. That’s what your IF statement implies, so that’s what the code checks for.
re: “The results gets shown on cell R27”
I changed the references to my example of A1 to be R27.
BTW I also changed the comment lines from K1 to K21, but that was just a typo that won’t matter since comment lines don’t get executed.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
'Was change made to K21?
If Target.Address = "$K$21" Then
'Place string if K21 = 0
If Target = 0 Then
Range("R27") = _
"7. Offset with 0875 2071020059 012167 DIFF"
Else
'Place string if K21 <> 0
Range("R27") = _
"7. Offset with 0875 1879902642 012167 DIFF"
End If
'Format R27
With Range("R27")
.Font.Bold = False
.Characters(1, 1).Font.Bold = True
.Characters(Len(Range("R27")) - 3, 4).Font.Bold = True
End With
End If
Application.EnableEvents = True
End Sub
HP Pavilion DV6 Entertainment PChttp://h10032.www1.hp.com/ctg/Manua...Apparently the DV6 laptop series has several possible mboards (system boards).Some DV6 models have a discrete video adapter (a removable video card that plugs into the mboard that has it's own memory) - some have a video adapter bRead more
Apparently the DV6 laptop series has several possible mboards (system boards). Some DV6 models have a discrete video adapter (a removable video card that plugs into the mboard that has it’s own memory) – some have a video adapter built into the mboard.
We need to know which specific model you have.
Go here: http://partsurfer.hp.com/search.aspx Scroll down a bit. Look for the similar label on the outside of your computer. Quote the specific model number – that’s at the end of the first line. Quote the Product number – that’s on the third line. …..
If it has a video adapter built into the mboard, you may be able to increase the amount of memory the onboard video uses by changing a setting in the bios.
If it has a discrete video adapter, it has it’s own memory, you can’t change the amount, but it’s probably at least 512 mb. In some cases, the system has both a video adapter built into the mboard and a discrete video adapter. The onboard video is used unless the computer detects that a program would benefit from using the discrete video adapter instead. In some cases that requires that a brand name program has the info it needs about the program , e.g. a game , you want to use, and in some cases you must update the info for that program, or manually set up that program for the program you want to use, in order for the discrete video adapter to be used.
If all your specific model has is a video adapter built into the mboard, the only way you can significantly improve the video performance is to use an external monitor with an external display adapter box that you plug into the laptop.
Thanks for the heads up but your solution is not really new. It is all documented in the WD Smartware Software User Manual as 1 of 3 options under Using the Drive Unlock Utility shown on page 44.i_Xp/Vista/W7/W10 User
Thanks for the heads up but your solution is not really new. It is all documented in the WD Smartware Software User Manual as 1 of 3 options under Using the Drive Unlock Utility shown on page 44.
Are you trying to network it? I'm not sure if you want a MAC address of the device or a Wireless WEP key.More details needed A thank you would be nice, if I have helped.
Are you trying to network it?
I’m not sure if you want a MAC address of the device or a Wireless WEP key.
helloJust for information: 32 bit software should work on 64bit Windows due to the fact that 64 bit windows supports WoW (Windows on windows) which is a compatibility layer that allows it to run 32 bit apps. The 32 bit versions of windows have the same thing to allow it to run 16 bit apps ... AnywayRead more
hello
Just for information: 32 bit software should work on 64bit Windows due to the fact that 64 bit windows supports WoW (Windows on windows) which is a compatibility layer that allows it to run 32 bit apps. The 32 bit versions of windows have the same thing to allow it to run 16 bit apps …
Anyway, to be on the safer side; If you husbands laptop is a 64bit, then it;s prefered to get 64bit Application as it uses its effeciency etc etc.
http://forums.techguy.org/software-..."...the truth is most Batch to EXE converters don't actually convert your code, but instead wrap them in an exe file..."So long as the code was originally a .BAT, you should be able to convert it back to it's original form...User Info Page Biography for full speRead more
you could try thishttp://www.winhelponline.com/blog/f...whats the hyperlink directing to a website, or an image?you could also try to right click on the link and select open with?:: mike
This is what worked for me...=SUMIF(D2:D20;"Petrol";C2:C20)I will break it down in to parts:=SUMIF function command(D2:D20) is the cell range that you select for your catergory (petrol, food, etc) "Petrol" is the catergory you are adding up (if you are adding food, type in food instead of petrol)C2:Read more
This is what worked for me…
=SUMIF(D2:D20;”Petrol”;C2:C20)
I will break it down in to parts: =SUMIF function command (D2:D20) is the cell range that you select for your catergory (petrol, food, etc) “Petrol” is the catergory you are adding up (if you are adding food, type in food instead of petrol) C2:C20 is the range of you price/amount
Solved How To Use Dymo Label In My VBA
re: "-Under control panel printers make sure your label printer is set as default printer."Another option is to capture the "normal" default printer, print the labels to the Dymo device and then reset the default printer, all within the macro. No need for a manual change each time you want to printRead more
Another option is to capture the “normal” default printer, print the labels to the Dymo device and then reset the default printer, all within the macro. No need for a manual change each time you want to print a label.
Try replacing this section of AWTL’s fine code…
' Print sheet 2 to the default printer Sheets("Sheet2").PrintOut…with this:
'Print to Dymo Label Printer and go back to the original printer when done. originalPrinter = Application.ActivePrinter Application.ActivePrinter = "*** Insert Dymo Printer Name Here ***" Sheets("Sheet2").PrintOut Application.ActivePrinter = originalPrinterTo grab the system’s name for the Dymo printer, you can follow these steps once:
1 – Set the default printer to the Dymo device
2 – Open a new workbook
3 – Run this code
Sub GetDymoName() Range("A1") = Application.ActivePrinter End Sub4 – Copy the string from A1 and paste it in place of *** Insert Dymo Printer Name Here *** in the code above, making sure that it is between the quotes
5 – Reset the default printer to the original default
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03
Solved Excel Bold Text In Formula
re: "The amount in questions gets taken out of cell K21 I assume that means the K21 will either be 0 or not be zero. That's what your IF statement implies, so that's what the code checks for.re: "The results gets shown on cell R27" I changed the references to my example of A1 to be R27.BTW I also chRead more
I assume that means the K21 will either be 0 or not be zero. That’s what your IF statement implies, so that’s what the code checks for.
re: “The results gets shown on cell R27”
I changed the references to my example of A1 to be R27.
BTW I also changed the comment lines from K1 to K21, but that was just a typo that won’t matter since comment lines don’t get executed.
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False 'Was change made to K21? If Target.Address = "$K$21" Then 'Place string if K21 = 0 If Target = 0 Then Range("R27") = _ "7. Offset with 0875 2071020059 012167 DIFF" Else 'Place string if K21 <> 0 Range("R27") = _ "7. Offset with 0875 1879902642 012167 DIFF" End If 'Format R27 With Range("R27") .Font.Bold = False .Characters(1, 1).Font.Bold = True .Characters(Len(Range("R27")) - 3, 4).Font.Bold = True End With End If Application.EnableEvents = True End SubClick Here Before Posting Data or VBA Code —> How To Post Data or Code.
Solved I Want To Increase HP Laptop Dedicated Video Memory
HP Pavilion DV6 Entertainment PChttp://h10032.www1.hp.com/ctg/Manua...Apparently the DV6 laptop series has several possible mboards (system boards).Some DV6 models have a discrete video adapter (a removable video card that plugs into the mboard that has it's own memory) - some have a video adapter bRead more
http://h10032.www1.hp.com/ctg/Manua…
Apparently the DV6 laptop series has several possible mboards (system boards).
Some DV6 models have a discrete video adapter (a removable video card that plugs into the mboard that has it’s own memory) – some have a video adapter built into the mboard.
We need to know which specific model you have.
Go here:
http://partsurfer.hp.com/search.aspx
Scroll down a bit.
Look for the similar label on the outside of your computer.
Quote the specific model number – that’s at the end of the first line.
Quote the Product number – that’s on the third line.
…..
If it has a video adapter built into the mboard, you may be able to increase the amount of memory the onboard video uses by changing a setting in the bios.
If it has a discrete video adapter, it has it’s own memory, you can’t change the amount, but it’s probably at least 512 mb.
In some cases, the system has both a video adapter built into the mboard and a discrete video adapter. The onboard video is used unless the computer detects that a program would benefit from using the discrete video adapter instead. In some cases that requires that a brand name program has the info it needs about the program , e.g. a game , you want to use, and in some cases you must update the info for that program, or manually set up that program for the program you want to use, in order for the discrete video adapter to be used.
If all your specific model has is a video adapter built into the mboard, the only way you can significantly improve the video performance is to use an external monitor with an external display adapter box that you plug into the laptop.
E.g.
http://www.tigerdirect.com/applicat…
Solved How To Unlock Forgotten WD HDD Smartware Password Solution
Thanks for the heads up but your solution is not really new. It is all documented in the WD Smartware Software User Manual as 1 of 3 options under Using the Drive Unlock Utility shown on page 44.i_Xp/Vista/W7/W10 User
i_Xp/Vista/W7/W10 User
How Do I Find The 8 Digit Code On My TV
Are you trying to network it? I'm not sure if you want a MAC address of the device or a Wireless WEP key.More details needed A thank you would be nice, if I have helped.
Are you trying to network it?
I’m not sure if you want a MAC address of the device or a Wireless WEP key.
More details needed
A thank you would be nice, if I have helped.
Solved Running Autocad 32-Bit In Windows 7 64-Bit
helloJust for information: 32 bit software should work on 64bit Windows due to the fact that 64 bit windows supports WoW (Windows on windows) which is a compatibility layer that allows it to run 32 bit apps. The 32 bit versions of windows have the same thing to allow it to run 16 bit apps ... AnywayRead more
Just for information: 32 bit software should work on 64bit Windows due to the fact that 64 bit windows supports WoW (Windows on windows) which is a compatibility layer that allows it to run 32 bit apps. The 32 bit versions of windows have the same thing to allow it to run 16 bit apps …
Anyway, to be on the safer side; If you husbands laptop is a 64bit, then it;s prefered to get 64bit Application as it uses its effeciency etc etc.
Solved What Does Attrib +h C:\ System.sav /s /d Do In Win10?
system.sav is a folder usually found on HP computers and the DOS command you saw is not suspicious.http://www.sevenforums.com/general-...
http://www.sevenforums.com/general-…
Solved How To Convert EXE To Bat File?
http://forums.techguy.org/software-..."...the truth is most Batch to EXE converters don't actually convert your code, but instead wrap them in an exe file..."So long as the code was originally a .BAT, you should be able to convert it back to it's original form...User Info Page Biography for full speRead more
“…the truth is most Batch to EXE converters don’t actually convert your code, but instead wrap them in an exe file…”
So long as the code was originally a .BAT, you should be able to convert it back to it’s original form…
User Info Page Biography for full specs.
Hyperlinks Won’t Open In Word.
you could try thishttp://www.winhelponline.com/blog/f...whats the hyperlink directing to a website, or an image?you could also try to right click on the link and select open with?:: mike
http://www.winhelponline.com/blog/f…
whats the hyperlink directing to a website, or an image?
you could also try to right click on the link and select open with?
:: mike
Excel Drop Down List Sum Up
This is what worked for me...=SUMIF(D2:D20;"Petrol";C2:C20)I will break it down in to parts:=SUMIF function command(D2:D20) is the cell range that you select for your catergory (petrol, food, etc) "Petrol" is the catergory you are adding up (if you are adding food, type in food instead of petrol)C2:Read more
=SUMIF(D2:D20;”Petrol”;C2:C20)
I will break it down in to parts:
=SUMIF function command
(D2:D20) is the cell range that you select for your catergory (petrol, food, etc)
“Petrol” is the catergory you are adding up (if you are adding food, type in food instead of petrol)
C2:C20 is the range of you price/amount
Hope this helps!