VBA: ដំណើរការកូដពេលបើកឯកសារ Excel

Private Sub Workbook_Open()

Run "GetData"

End Sub

• GetData ជាឈ្មោះ Macro ដែលដំណើរការពេលបើកឯកសារ

ចុចទីនេះអានបន្ត>>>

VBA: ចម្លងទិន្នន័យពីឯកសារ Excel ដែលមិនដំណើរការដាក់ក្នុងឯកសារថ្មីមួយទៀត

Sub GetDataFromClosedFille()
Dim mydata As String
'data location & range to copy
mydata = "='D:\Inventory\[Jan.xlsm]Monthly'!$A$1:$R$144" '<< change as required

'link to worksheet
With ThisWorkbook.Worksheets("Jan").Range("A1:R144") '<< change as required
.Formula = mydata

'convert formula to text
.Value = .Value
End With
End Sub

• D:\Inventory\ ទីតាំងទុកឯកសារ
• [Jan.xlsm] ឈ្មោះឯកសារត្រូវដាក់ក្នុង [...]
• Monthly ឈ្មោះ Sheet 
• $A$1:$R$144 ទីតាំង Cell ក្នុង sheet ខាងលើ
• Jan ជាឈ្មោះ sheet ក្នុង Workbook ថ្មី ដែលត្រូវ Copy ពី sheet Monthly នៃ Workbook Jan
• A1:R144 ទីតាំង Cell ក្នុង sheet Jan ដែលត្រូវ Copy ពី $A$1:$R$144 នៃ sheet Monthly

ចុចទីនេះអានបន្ត>>>

របៀបបង្កើតឈ្មោះ និងលេខសម្ងាត់ ដើម្បីប្រើប្រាស ឯកសារ Excel

បើកឯកសារ Excel របស់យើង រួចបង្កើត Sheet ចំនួន ៣ ដូចខាងក្រោម

1- worksheet មានឈ្មោះថា Users សម្រាប់កំណត់ ឈ្មោះ និងលេខសម្ងាត់របស់អ្នកប្រើប្រាស់

2- worksheet មានឈ្មោះថា login សម្រាប់បើកផ្ទាំងចូលប្រើប្រាស់

3- worksheet មានឈ្មោះថា Macros Disabled សម្រាប់ណែនាំពេលកម្មវិធីមិនដំណើរការ Macro

បន្ទាប់មកចុច Alt + F11 ដើម្បីបើក Visual Basic Editor

ចុចលើ ThisWorkbook រួច Copy កូដ ខាងក្រោមដូចចូល

Code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Dim i   As Integer

Sheets("Macros Disabled").Visible = xlSheetVisible

For i = 1 To Worksheets.Count

    If Sheets(i).Name <> "Macros Disabled" Then

        On Error Resume Next

        Sheets(i).Visible = xlVeryHidden

    End If

Next

On Error GoTo 0

ThisWorkbook.Save

End Sub

Private Sub Workbook_Open()

Sheets("Login").Visible = xlSheetVisible

Sheets("Macros Disabled").Visible = xlSheetVeryHidden

Sheets("Users").Visible = xlSheetVeryHidden

UserForm1.Show

End Sub

និងចុច Insert ហើយយក Module ហើយ Copy កូដ (ដូចរូបខាងក្រោម) ដើម្បីដំណើរការលើប៊ូតុង Click me to Log In

Code:

Sub CmdOpenFrom_Click()

    UserForm1.Show

End Sub

បន្ទាប់ទាញយកទំរង់ Form ពីរ UserForm1.frm និង UserForm1.frx

រូចយកទៅ Import នៅក្នុង Visual Basic Editor

ដោយចុច File > Import File > រួចស្វែរកឯកសារ UserForm1.frm ដែលទាញយកខាងលើរួច ចុច Open ជាការស្រេច

ចំណាំៈ ចំពោះ Worksheet ដែលមានឈ្មោះ Users

UserID : វាយឈ្មោះអ្នកប្រើ

Password : វាយលេខសម្ងាត់

Users : ជា Worksheet ដែលឲ្យបង្ហាញដែលចំពោះ Admin ដែលអាចធ្វើការផ្លាស់ប្តូរឈ្មោះ និងលេខសម្ងាត់

ចំពោះ Sheet1 ដល់ Sheet4 ជាឈ្មោះ Worksheet របស់់យើង ដែលក្នុងឧទាហរណ៍នេះគឺមានតែ ៤ Sheet ទេ បើសិនជាយើងមានច្រើនយើងអាចវាយបន្ត ឬប្តូរឈ្មោះវាចេញ ករណ៍ មិនមានឈ្មោះដូចគ្នា 

ចំពោះអ្នកប្រើប្រាស់អាចប្រើ Sheet ណាមួយមានលុះត្រាតែ ដោយ វាយអក្សរ A ឬ a 

ឬក៏មិនចង់ឲ្យប្រើដោយ វាយអក្សរ NA ឬ n/a

គំរូ

ចុចទីនេះអានបន្ត>>>

ប្រើប្រាស់កុំព្យូទ័រពីចម្ងាយជាមួយ Team Viewer

This software allows you to remotely control any PC anywhere on the Internet
Share your screen has never been easier: With TeamViewer you can connect to the computer of a partner anywhere on the Internet. TeamViewer also works in the other direction: Show your own computer to a partner over the Internet and illustrate your own developed software, presentations or solutions.
Remote Control without Installation
With TeamViewer you can remotely control any PC anywhere on the Internet. No installation required, just run the application on both sides and connect ? even through tight firewalls.
Remote presentation of products, solutions and services

The second TeamViewer mode allows you to present your desktop to a partner. Show your demos, products and presentations over the Internet within seconds ? live from your screen.

Note For Windows 8 :-

TeamViewer Touch

Discover a new kind of remote control in Windows 8. The new TeamViewer Touch application is now available for download Windows 8 Store.
Latest generation multi-touch gestures and enhanced support for Windows 8
Run Windows 8 special commands (eg., Charms Bar Windows 8) on a remote computer directly through the toolbar of the remote control window. From a touch screen to another, you will discover how simple it is to use TeamViewer on Windows 8 with the help of latest generation multi-touch gestures.

ទាញយក

ចុចទីនេះអានបន្ត>>>

ការពារឯកសារជាមួយ Folder Guard

Folder Guard is a powerful computer security program that you can use to control access to files, folders, and other Windows resources. You can use Folder Guard to lock your personal files and folders with passwords, to stop other users from peeking into your records. You can even completely hide your private folders from virtually all applications, and such folders would remain invisible until you enter a valid password. You can also protect sensitive system files from modification or destruction, disable access to the removable drives, restrict access to Control Panel, and more.

You can protect with password virtually any folder, allowing only authorized users to open the protected files or folders. You can password-protect an unlimited number of folders, each with its own password, or you can use the Master Password of Folder Guard to unprotect them all at once.

Why choose Folder Guard?

Folder Guard can hide your personal folders from other users
You can set up Folder Guard to hide your private folders (or make them appear empty). The folder would be hidden from virtually any program, including Windows Explorer, Office, MS-DOS programs, etc.

Folder Guard can password-protect and restrict access to file folders
You can password-protect any document folder to prevent access to your personal files without knowing the password. You can set up Folder Guard to allow only certain users to change the computer settings with Control Panel, while denying that to other users.

Folder Guard can control access to programs and files
You can prevent other users (even the administrators) from using the system tools that can mess up your Windows installation, while allow such use for yourself or someone who knows the Master password. You can also designate the backup programs as the trusted ones, allowing them to backup your protected files in the background without asking you for the password every time.

Folder Guard can lock access to the USB, CD-ROM and other removable drives
You can configure Folder Guard to allow or deny access to the removable drives, restricting the user's ability to run or install unauthorized programs on your computer.

Home Page - http://www.winability.com/

ទាញយក

ចុចទីនេះអានបន្ត>>>