Lowyat.NET: Latest topics by NSR

Connecting HP Printer to Iphone Hotspot

NSR — Tue, 25 Feb 2025 14:09:35 +0800

Hi all,
Today I want to share the experience on troubleshoot HP Printer connection with iphone Hotspot since HP do not want to help.

If the HP printer unable connected to your iphone hotspot network, (new solution discovered on 20/3/2025)
- restart the HP printer
- install ookla speedtest on your iphone and run it
- you will notice the wifi blue light on HP printer from blinking, instantly become stagnant!
- once the blue light become stagnant means the HP printer is ONLINE and it is ready to print.
- you can use this solution if the printer can't print although it is ONLINE.

If still not helping, try this step by step: -
- Restart the iphone
If still not helping,
- Turn ON the Maximize Compatibility mode on iphone Hotspot
If still not helping,
- Turn Off the Maximize Compatibility
The Printer should be able seen online in your PC.

You can always make a shortcut for the printer status using this trick: -
- Create a shortcut on your desktop
- type the shortcut name in the properties: C:\Windows\System32\rundll32.exe printui.dll,PrintUIEntry /o /n "your printer name", example: C:\Windows\System32\rundll32.exe printui.dll,PrintUIEntry /o /n "HP415LEE (HP Ink Tank Wireless 410 Series)"
- You should be able to monitor the printer status buy opening the shortcut
Note: Please see the attachment of the program. If the status does not showing (Offline), means it is online.

Thank you.

Battery Health Check for Android Phone

NSR — Fri, 10 Jan 2025 14:59:10 +0800

Hi all,
Today I want to share the tips on how to use Battery Guru to check the Android Phone with accurate.
1. install battery guru from playstore.
2. discharge the battery level until 2% or below
3. run battery guru
4. charge the battery till 100%
5. now you should be able to see the battery health % more accurately as the app measuring the capacity that has been charge from 2% or less till it is full.

There are many technicians keep spreading fake info to end users saying only iphone can check the battery health which is bs. I guess maybe they lack knowledge of battery capacity. I wish the tips above help you all especially those who have replace the new battery for their Android phone. Fyi some repair shop using the used battery, expired battery or lower capacity battery for your phone. When you find out why the new battery not last comparing the phone is new, the shop owner may blame to your old phone which might consume more power than before.

Regards.
NSR

VBA codes that copy and pastes EXACT formula

NSR — Sat, 09 Nov 2024 17:13:26 +0800

[SOLUTION]VBA codes that copy and pastes EXACT formula
Hi guys,
Many users are almost giving up for this especially having multiple worksheets in a workbook but want to use the VBA to run the script to paste the exact formula.

Solution: -
Assuming you have 3 worksheets which is sheet1, sheet2 and sheet3 in a workbook. The source of the value is in the sheet3 =SUM(B41:M41), the source of the formula is in the sheet2 ='sheet3'!C7. Now you want to paste the formula from the sheet2 into multiple cells on the sheet1 using VBA, and soon to the rest of the cells in new sheets you will be creating in the future.

1. On the source of the formula in sheet2 h10, simply add dollar sign to the formula.
Example: ='sheet3'!C7 to ='sheet3'!$C$7

2. Then create a module in the VBA as below: -
Sub CopyPaste()
Range("'sheet'!h10").Copy
Selection.PasteSpecial (xlPasteFormulas)
End Sub

3. Test the module in multiple cells in sheet1. All the value should read similar without any error.

I hope those ppl facing the problem can reach here for the solution.

Excel unable to break workbook links - Solution

NSR — Wed, 06 Nov 2024 12:55:41 +0800

[SOLUTION]Excel Cannot Break Links to some Worksheets
Hi guys,
Recently I have encountered this error when trying to break the links to the server by going to Data-Workbook Links. The name manager is blank, though.
If you search all over the internet, it will end up wasting your time for no solution, but nonsense everywhere. Even Microsoft has no idea on it!

Then I found the solution. It sounds like not practical but at least it can be solved in less than 5 minutes. No need to start the work from the scratch!

Solution No.1:
1. Close the problematic excel file. Let say it is filename.xls
2. Rename it to filename1.xls
3. Open the filename1.xls
4. Create New Blank Workbook(new excel file)
5. Save the new workbook to the same file format, and name it to filename.xls.
6. From the filename1.xls, Select All Sheets, then copy it to filename.xls. Click YES for all the error prompts.
7. Close the filename1.xls and delete it.
8. On filename.xls, go to Data-Workbook Links, you are able to break the links now. Remember to click refresh all to ensure it works.

Solution No.2:
1. Open the problematic excel file
2. Right click the worksheet and select move or copy..., a box will appear.
3. On to book, select (newbook). Click create a copy.
4. Click yes to all errors that pop out. Click yes to all if name errors pop out.
5. Go to Data-Workbook Links, you are able to break the links now. Remember to click refresh all to ensure it works.
6. Now replace it to the problematic excel worksheet file. Remember to click refresh all in workbook links to ensure it works.
Note: No need to save the newbook. Just close it without saving will do. You just save the problematic file will do. All should be good now.

Solution No.3:
This need some basic codding knowledge but don't worry, I will show you step by step so that you know how to do it.
Before deleting the external links, you may want to see what it is.
1. Open the problematic excel file
2. Press the ALT-F11 on the keyboard. The VBA will pop out.
3. Click Insert
4. Select Module. A white box will pop out on the right pane
5. Copy and paste this code in the white box: -

CODE

Sub GetLinks()
Dim links As Variant
links = ActiveWorkbook.LinkSources(xlExcelLinks)

If Not IsEmpty(links) Then
Sheets.Add
For i = 1 To UBound(links)
Cells(i, 1).Value = links(i)
Next i
Else
MsgBox "No external links are found.", vbInformation, "Find Links"
End If
End Sub

6. Press F5 on the keyboard. You will be able to see the external links in the new worksheet(sheet 1), then delete it.
7. Now you can delete the external links by run this code: -

CODE

Sub DeleteExternalLinks()
Dim objDefinedName As Object
Dim iCount As Long

For Each objDefinedName In ActiveWorkbook.Names
If InStr(objDefinedName.RefersTo, "[") > 0 Then
objDefinedName.Delete
iCount = iCount + 1
End If
Next objDefinedName

End Sub

8. Click End if '1004' error pop out
9. Refresh all in workbook links to ensure it works. If it is still appear, you should be able to break the links easily.

I hope those ppl facing the problem can reach here for the solution.

Excel Cannot Open the File Because the File Format

NSR — Fri, 11 Oct 2024 01:12:58 +0800

[SOLUTION] Excel Cannot Open the File Because the File Format or File Extension Is Not Valid
Hi guys,
Recently I have encountered this error when uploading the xlxs file to the server and downloading it to another pc.
No matter how you try, the file still cannot be open/repair. Weird.
Then I compare the file size with the source, server and the new pc.
Source = 56kb
Server = 56kb
New pc = 4kb
If you search all over the internet, it will end up wasting your time for no solution.

The culprit is the server. When downloading the xlxs file from the server, it became corrupted. I try many times to upload it again and again, same thing happens. Then I search on the internet, nobody found the solution. Even Microsoft has no idea on it!

I send the file to my own email and using the new pc to download it. It works!
Source = 56kb
Email = 56kb
New pc = 56kb

Another solution is ZIP it before uploading to server.

I hope those ppl facing the problem can reach here for the solution.

Epson L3250 Printer Not Able to Print Colour

NSR — Tue, 23 Jul 2024 16:22:09 +0800

Epson L3250 Printer Not Able to Print Colour

Hi guys,
If your epson l3250 printer can't be able to print properly, usually you will do the print head cleaning using the software. You will be more frustrated if the power cleaning not helping and wasted too much inks for the attempt. It may help but for sure will come back again as soon as few days. The print quality isn't as good as before because just partially of the dusts in the tube can be flushed by power cleaning.

Solution
If you have done the print head cleaning but no improvement, never go for power cleaning. It is usually cause by blockage in the tube by dusts. In this case you will have to send it to the service centre for free servicing(can done in the same day if you send it on morning) if it is under warrantee. Tell the service centre not to use power cleaning since they have the tools to do a better job(almost perfect as they vacuumed/flush the tube by proper tools) without losing much of your inks.

If you ignored the error, the dust may permanent stay in the tube and it will be very hard to flush away, the print head will get scratched by the dusts.

I hope the solution may help most of the owners.

Thank you.

wts Hotlink Edisi Sabah - new number or mnp

NSR — Wed, 07 Feb 2024 21:22:00 +0800

Item(s): Hotlink Edisi Sabah - new number, mnp from other telco or mnp from hotlink/maxis

Package includes: SIMCARD

Price: Start from RM15
Warranty:

Dealing method: Meet in Ipoh or Juru, or courier by Citi-Link

Location: Ipoh and Juru

Contact method/details: 0186968688 https://wa.link/cz4d3d
---

Item(s) conditions: New

Picture: as attached

Reason for sale: Every1 need it

Moving Files from Samsung to Windows 10 Issue

NSR — Tue, 16 Jan 2024 14:52:08 +0800

Hi guys,
I believe many of you are having difficulty to back up your files from Samsung to your windows 10.
When moving the files, the process might be interrupted by FTP Folder Error if you are using ES File Explorer for the job.
Actually, the issue is not cause by the windows, but your Samsung phone.

Here is the solution on your Samsung phone:
1. End task the ES File Explorer.
2. Turn the flight mode ON
3. Turn the flight mode OFF
4. Turn ON the wifi
5. Open the ES File Explorer and start the Remote Manager. Should be good for now.

Thank you!

Wts bmw E90 320i special edition zero technical is

NSR — Sun, 25 Jun 2023 19:56:30 +0800

BMW the ultimate driving machine.
I am a businessman.
I am the owner of this car. I am still driving this car for daily. Genuine Mileage 180000km and is proven in ista.
No leakage of oil or coolant or refrigerant
Zero air cond issue, air cond is blowing cold air during cold start till you shut off engine
Zero mechanical issue
Nice condition but need to repaint the car especially the engine hood as the white spot can be seen. Without repaint also can drive. But then I will pay u cash rm2000 for you to repaint the car body if paid by cash. If you don't want to repaint it, you can keep the cash.
All rubbers are at excellent condition, included the wiper panel.
Car well maintained in M Motorsport and the cost bare by company. You can call mr Puven to know the condition of my car by showing him my car pictures. All 4 tires like new. Bottom engine cover is still there. It is safe to drive(low to maximum speed), buy and just drive like that.
I am not a smoker
I am not a reckless driver
I never fetch any pets in it
I never eat inside the car
I don't owe ppl money and never borrow money from loan shark
Reason for sale: buy new honda hrv and i have already paid the booking. New hrv will get in month December soon.
Rm19999 price is fix and it is the cheapest in market. Rm2000 cash back for you either you spend it for repaint or keep in your saving account.
Thanks for reading.

wts - Big Sweep Ticket for sale

NSR — Sun, 11 Jun 2023 22:36:42 +0800

Item(s): Big Sweep Ticket

Package includes: Big Sweep Ticket

Price: RM2.80. Free shipping by DHL if purchase 100pcs and above.

Warranty: 4 months

Dealing method: Prefer ewallet. But still accepting bank transfer or cash.

Location: Penang and Ipoh

Contact method/details: Whatsapp 0124904888
---

Item(s) conditions: New 100%

Picture: 16072023

Reason for sale: Offer for LYN

wts Umobile Unlimited Funz GX30 GX38 Simpack

NSR — Wed, 08 Jun 2022 23:09:38 +0800

No joke. I am the only dealer that still hold a lot of these old stock. Be reminded that only these simpack can subscribed GX30 and GX38 that really don't have FUP at all. 6MBPS with 6GB hotspot. But if u have Modded Router then u can ahem ahem.

Item(s): Umobile Unlimited Funz GX30 GX38 Simpack

Package includes: Umobile Unlimited Funz Simpack

Price: RM10 buy 10 pcs free DHL shipping.

Warranty: 30days

Dealing method: COD or by DHL(RM8). Payment by TNG and duitnow accepted too, straight to my company account.

Location: Malaysia

Contact method/details: Whatsapp 0124904888
---

Item(s) conditions: New

Picture: tba
Reason for sale: Ahem ahem for LYN members

All these sims never register before. I will reg for you once u received.

wts Digi Unlimited Quota Prepaid New Sim

NSR — Wed, 08 Jun 2022 19:18:48 +0800

Item(s): Digi Unlimited Quota Prepaid New Sim

Package includes: Digi Unlimited Quota Prepaid New Sim 30days

Price: RM25 (Normal Price RM43, Renew RM35)

Warranty: 30days

Dealing method: COD or by DHL

Location: Malaysia

Contact method/details: Whatsapp 0124904888
---

Item(s) conditions: New

Picture:

Reason for sale: Offer for LYN members

wts YES RM30 Topup selling for RM27 only

NSR — Wed, 21 Aug 2019 13:40:21 +0800

While stock last

Item(s): YES RM30 Topup
Package includes: PIN Code

Price: RM27.00

Also available for RM10 selling at RM9.

Warranty: by YES

Dealing method: Bank in or COD at my shop.

Location of seller: Taman Seri Delima Juru Penang

Contact method/details: post here, pm, sms, WhatsApp or WeChat 0124904888 MAXIS, email ron@stromberg.com.my

Age of item: New

---

Item(s) conditions: New

Picture:

Reason for sale: Get Famous in LYN

Thanks for support

wtg MNP to YES 4GLTE

NSR — Fri, 02 Aug 2019 12:09:36 +0800

This is a free service means I will give you the free Blue YES 4GLTE Sim for free once MNPed

You pay Zero RM0 for this service

Item(s): YES 4GLTE MNP SIM

Package includes: Free MNP service

Price: FREE RM0.00

Warranty: by YES

Dealing method: I can ship the SIM to you by Poslaju RM6. Penang member please collect at my shop in Taman Seri Delima Juru Penang.
Kindly please inform me your. You can also WhatsApp 0124904888 me for dealing.

Location of seller: Taman Seri Delima Juru Penang

Contact method/details: post here, pm, sms, WhatsApp or WeChat 0124904888 MAXIS, email ron@stromberg.com.my

Age of item: New

---

Item(s) conditions: New

Picture:

Reason for sale: Get Famous in LYN

FAQ:
1. What is the validity after MNPed?
A. 5 days.
2. How long is the process usually take?
A. 2 days if things going smoothly.
3. Can I reload from you?
A. Yes, please. I will be very appreciate.
4. Can you help remotely subscribe the internet plan for me?
A. Yes, please. That's my pleasure to serve you.
5. Can I do this in YES Centre?
A. They will charge you and might give some hassles. Also, they will not serve you b4 or after office hours.
6. How about other dealers/sellers?
A. They might give you even more hassles.
7. Why you?
A. I want to get famous. LoL

Thanks for support

Wifi Direct Print for Epson L3150 - Android Phone

NSR — Fri, 26 Jul 2019 12:44:05 +0800

Hi Guys,
I would like to share my experience for using Wifi Direct print from your Android Phone to Epson Printer L3150. I am sure many of you have bought this printer since it is so hot in the market recently.

1. Download Epson print from Playstore.
2. Turn on your printer. Make sure the Wifi icons blinking on the panel.
3. Print the network sheet by long pressing about 7 secs button right hand side of the wifi icon. Just page 1 will do. You will get the wifi direct password from this sheet.
4. On your android phone, turn on the wifi. You will see the epson printer on the wifi list. connect it and enter the password that you got it on that sheet that u just printed. link it.
5. Now, open a PDF file on your phone. go to print. then select the printer accordingly. Once done all then your printer should be printing now.

Good luck!

Epson Printer L3150 wifi direct password only can get it from the network status sheet. You can print it from your Epson L3150 by long press for about 7 secs on the button just right hand side of the wifi button on your printer.

Questions can please ask here and I will try to answer ASAP.

wts Hotlink RM100 Credit Selling at RM80 only

NSR — Tue, 16 Jul 2019 14:51:24 +0800

Hotlink RM100 Credit Selling at RM80 only. Kindly pls msg me your number once paid.
Kindly pls be reminded that this is just credit only. It will not affect your validity. If you would like to have normal topup which may increase your validity up to 100days kindly pls inform me, I will give you another link with offer price rm95.

Item(s): Hotlink RM100 Credit Selling at RM80 only

Package includes: Hotlink RM100 Credit Selling at RM80 only

Price: RM80

Warranty:

Dealing method: After you bank in to my Maybank 557063326431 Stromberg Sales and Services ron@stromberg.com.my kindly please inform me your HOTLINK Prepaid number for me to transfer. Accept credit card payment too but got 2% extra charge.

Location: Taman Seri Delima Juru Penang

Contact method/details: post here, pm, sms, WhatsApp or call 0124904888 (MAXIS), email ron@stromberg.com.my
---

Item(s) conditions: NEW

Picture:

Reason for sale: Getting popular in LYN

Done:
1. 100 = 011*2091
2. 100 = 011*2091 Repeat order
3. 100 = 011*3671
4. 100 = 011*3671 Repeat order
5. 100 = 011*2091 Repeat order
6. 100 = 011*2091 Repeat order
7. 100 = 011*2091 Repeat order
8. 100 = 012*7609
9. 100 = 012*2885
10. 100 = 016*1030
11. 100 = 016*1030 Repeat order
12. 100 = 011*2091 Repeat order
13. 100 = 011*2091 Repeat order
14. 500 = 017*7266
15. 500 = 017*7266 Repeat order
16. 300 = 011*2091 Repeat order
17. 200 = 017*0109

wtg Remove CRT for Hotlink and Maxis

NSR — Wed, 02 Jan 2019 15:59:10 +0800

This is a free service means I will help u remove CRT caller ringtone for both Hotlink and Maxis Postpaid

You pay Zero RM0 for this service

Item(s): Maxis and Hotlink CR Removal Service
Package includes: Free Maxis and Hotlink CR Removal Service service

Price: Zero

Warranty: by Maxis

Dealing method: You can post here or pm me. You can also WhatsApp 0124904888 me for dealing.

Location of seller: Taman Seri Delima Juru Penang

Contact method/details: post here, pm, sms, WhatsApp or WeChat 0124904888 Celcom, email ron@stromberg.com.my

Age of item: New

---

Item(s) conditions: New

Picture:

Reason for sale: Getting Famous in LYN

FAQ:
1. What is the procedure for CRT removal?
A. Give me your number. Then wait for PIN and msg to me. Once done then I will sms u.

Thanks for support
1. phyxious87 - 018xxx2369

Use 2 SIMs and Micro SD Card

NSR — Thu, 28 Dec 2017 20:31:39 +0800

Very useful for those who are so desperate to use dual sim + micro sd card in hybrid slot.

[YOUTUBE]pF8rhGvejDw[/YOUTUBE]

Samsung Mega 6.3 Can't detect/read SIM?

NSR — Sat, 09 Dec 2017 23:26:06 +0800

Hi all,
I would like to share my experience on troubleshooting the SIM error on Samsung Mega 6.3 Phone:-

Pls take note:
- Make sure the SIM is workable. You can test it in call phone eg. Nokia 8250.
- Make sure the SIM is not the self cut 1.
- Usually only happen on adapter type (micro SIM adapter + nano SIM)

Solution:
Just replaced the micro SIM adapter with a little thinner than the nano SIM.

Remarks:
- Only happen on SIM with micro SIM adapter.
- All other Samsung Phones with micro SIM size and with adapter type may try using this solution for troubleshooting.
- These issue happen after you have damaged the SIM card slot especially by inserting a self cut SIM.

Regards.

Hotlink is giving Unlimited Facebook for new pack

NSR — Wed, 01 Nov 2017 14:57:45 +0800

Latest Updates:-
1. Existing Hotlink Super customers can enjoy the unlimited Facebook quota by subscribing the 1GB RM3 daily plan.
2. Opening FREE 999GB Fast Facebook to existing Weekly and Monthly Pass customers from 7 Dec onward!
3. Unlimited FB for new sim registration extended till end of January 2018!
4. Please be informed that Unlimited Facebook offer will be end at 17/1/2018.
i) New registered sims during the promo period can still continue to enjoy the offer until 31/12/2018.
ii) Existing customers will end at 17/1/2018.
iii) All new sims that register after 17/1/2018 will not enjoy the Unlimited Facebook.

Hi all,
I would like to share the news of Hotlink is giving Unlimited Facebook for new customers included mnp starts from 2nd of November 2017.

Of course you will need to subscribe 1 of these internet plans in order to enjoy it.
- RM3 1GB daily plan
- RM10 1GB Weekly plan
- RM35 5GB Monthly Plan
- RM60 8GB with Unlimited Calls to all networks Monthly plan

FAQ:-
1. Can existing hotlink customer enjoy it?
A: Yes if with reverse MNP. Existing Hotlink Super customers can enjoy the unlimited Facebook quota by subscribing the 1GB RM3 daily plan.

2. Besides reverse MNP, what else can be done?
A: No other way except reverse MNP.

3. Can I pay it let say RM1000 in order to enjoy it?
A: No you still can't. Reverse MNP is the only way.

4. Who can do the reverse MNP?
A: Any Maxis dealers which have the time and mood to do for u.

5. How much to pay for reverse MNP?
A: Market price RM50.

4. Can Maxis Centre do the reverse MNP?
A: Yes, but you won't see the staff in the office starting from the next day, or maybe in less than 5 mins. He/she is sacked.

Regards all,
Ron