Rumus VBA Macro Excel Import Data

Mengcopy-paste nilai di Excel dengan teknik import file

Isikan pada module:

----

Sub Upload()

Dim sImportFile As String, sFile As String

Dim sThisBk As Workbook

Dim vfilename As Variant

Application.ScreenUpdating = False

Application.DisplayAlerts = False

Set sThisBk = ActiveWorkbook

sImportFile = Application.GetOpenFilename( _

FileFilter:="Microsoft Excel Workbooks, *.xls; *.xlsx", Title:="Open Workbook")

If sImportFile = "False" Then

MsgBox "Belum ada File yang anda pilih!"

Exit Sub

End If

Application.Workbooks.Open Filename:=sImportFile

Set sThisBk = Workbooks.Open(sImportFile)

sThisBk.Sheets("NILAI").Range("E13:N52").Copy

sThisBk.Close (False)

Range("e13:n52").Select

ActiveSheet.Paste

MsgBox "ANDA YAKIN MENGISI DATA NILAI DISINI KLIK OK, MAKA ALHAMDULILLAH DATA NILAI SUDAH DISALIN PADA HALAMAN INI"

End Sub

----

Berikut SourceCode di GitHub: https://github.com/ryanbekabe/ExcelVBAMacroImportData/blob/master/module.bas

Malware Analyst Tool

Malware Sandboxes & Malware Source

Archive berikut adalah share Link Analisa Malware menggunakan metode Sandboxing dan juga share link beberapa situs yang share source code malware

Archive

• AMalware Analysis - Sandboxing
• ( Online ) Malware Analysis - Sandbox
• Malware Sources

Malware Analysis - Sandboxing

URL	INFO
Cuckoo Sandbox	Open source, self hosted sandbox and automated analysis system.
Mastiff	Static analysis of malware.
Fastir	This tool collects different artefacts on live Windows and records the results in csv files.
SysAnalyser	Application that was designed to give malcode analysts an automated tool
Viper	Binary analysis and management framework
Zeltser analysis	Automated Malware Analysis
Manalyze	Manalyze started when antivirus tried to quarantine malware sample collection for the thirtieth time
Quarkslab IRMA	Asynchronous and customizable analysis platform for suspicious files!
Dorothy2	A malware/botnet analysis framework written in Ruby.
F-Secure see	Sandboxed Execution Environment
Noriben	hPython-based script that works in conjunction with Sysinternals Procmon
Malheur	Automatic Analysis of Malware Behavior
Drakvuf	Virtualization based agentless black-box binary analysis system.
Zero Wine Tryouts	Zero Wine Tryouts is an open source malware analysis tool.
CWSandbox	A “sandbox”, as it relates to computer security, is a designated, separate and restricted environment
Malwasm	Offline debugger for malware's reverse engineering

( Online ) Malware Analysis - Sandbox

URL	INFO
Malwr	Free analysis with an online Cuckoo Sandbox instance.
Hybrid analysis	Online malware analysis tool, powered by VxSandbox.
Virscan	FREE on-line scan service, which checks uploaded files for malware, using antivirus engines, indicated in the VirSCAN list.
Virusade	Hosted virus scanning for developers
VirusTotal	Free online analysis of malware samples and URLs
Malwareconfig	Online malware analysis samples
Detux GNU/Linux sandbox	sandbox developed to do traffic analysis of the Linux malwares and capture the IOCs by doing so. QEMU hypervisor is used to emulate Linux (Debian) for various CPU architectures.
AndroTotal	Free online analysis of APKs against multiple mobile antivirus apps.
Comodo	malware detection techniques Valkyrie conducts several analysis using run-time behavior and hundreds
Manalyzer	Free service which performs static analysis on PE executables to detect undesirable behavior.
ID Ransomware	Upload a ransom note and/or sample encrypted file to identify the ransomware that has encrypted your data.
Document Analyzer	Free dynamic analysis of DOC and PDF files.
Cryptam	Analyze suspicious office documents.
Metascan	Scan a file, hash or IP address for malware (free)
Jotti	Free online multi-AV scanner.
PDF Examiner	Suspected malware to be fed into our analysis network.
PDF examiner	Analyse suspicious PDF files.
Malware tracker	Provides malware analysis, forensics, and security solutions for enterprise.

Malware Sources

URL	INFO
http://cybercrime-tracker.net/	Cybercrime tracker
http://malc0de.com/database/	Malc0de
http://malwaredb.malekal.com/	Malekal
http://malshare.com	Malshare
http://tracker.h3x.eu/	Tracker
http://www.kernelmode.info	Kernel mode
https://www.botnets.fr/wiki/Main_Page	Botnet.fr
http://www.exposedbotnets.com/	Exposed Botnets
http://malware.dontneedcoffee.com/	Dont need coffee
http://vxvault.net/	VX Vault
https://github.com/ytisf/theZoo/tree/master/malwares/Binaries	Malware binaries
https://totalhash.cymru.com/	Total hash
https://zeustracker.abuse.ch	ZeuS Tracker
https://cse.google.com/cse/home?cx=011750002002865445766%3Apc60zx1rliu (from Corey Harrell)	Custom Google search engine
https://archive.org/details/malwaremuseum	Malware museum
https://ransomwaretracker.abuse.ch/tracker/	Ransomware tracker
https://docs.google.com/spreadsheets/d/1TWS238xacAto-fLKh1n5uTsdijWdCEsGIM0Y0Hvmc5g/pubhtml#	Ransomware overview
https://shinolocker.com/	Ransomware simulator
http://contagiodump.blogspot.se/	Contagio
http://virusshare.com/	VirusShare
http://www.virusign.com/	Virusign
http://www.malwaredomainlist.com	Malware domain list
https://malware.lu/	Malware.lu
https://github.com/MISP/MISP	MISP
http://www.malware.pl/ - https://www.scumware.org/	SafeGroup
http://minotauranalysis.com	NovCon Minotaur
http://support.clean-mx.de/clean-mx/viruses.php	Clean MX
http://panda.gtisc.gatech.edu/malrec/	Edu malrec
https://www.abuse.ch/	Abuse CH
http://www.offensivecomputing.net/	Offensive computing
http://www.malwaredomains.com	Malware domain blocklist
https://github.com/technoskald/maltrieve	Maltrieve
https://stixproject.github.io/	Structured Threat Information eXpression
https://ytisf.github.io/theZoo/	The Zoo aka Malware DB
https://github.com/0day1day/mwcrawler	Tool Mwcrawler

Thanks!

• Sign out