Posts

Showing posts from November, 2017

VBA Code to Copy Files from one folder to another

FilesPath=inputbox("Enter Sourcepath for  files to be copied as C:\RootFilesPath") FileToCopyPath=inputbox("Enter destination  folderpath to copy files Sample as C:\ODC Data Compare\ODC File Compare\Prod Data") Set FileObj=createobject("Scripting.FileSystemObject") If  FileObj.FolderExists(FIlesPath) Then Set oFolder=FileObj.GetFolder(FIlesPath) Set oFiles=oFolder.Files For each oFile in oFiles FileName=oFile.name FLName=split(FileName,"-") FName=trim(FindRecid(FLName(0))) If FileObj.FolderExists(FileToCopyPath) Then Set DestRootFolder=FileObj.GetFolder(FileToCopyPath) Set SubFolder=DestRootFolder.SubFolders For each oFolder in SubFolder SubFolderName=trim(oFolder.Name) If  SubFolderName=FName  Then SourcePath=FIlesPath & "\" &  FileName DestinationPath=FileToCopyPath & "\" & SubFolderName & "\" FileObj.CopyFile SourcePat...

Performance Testing prep

TCP vs HTTP TCP and UDP are the "trucks" on the highway, and the "load" they are carrying are protocols such as HTTP , File Transfer Protocol (FTP) and more. As you can understand, TCP and UDP are transport protocols used by protocols such as FTP, HTTP, and SMTP. While both TCP and UDP are used to transport other protocols, they have one significant difference; TCP offers guaranteed data transportation, whereas UDP doesn't. What this means is that TCP has a special mechanism that ensures data is safely transferred without errors from one point to another, whereas UDP doesn't provide any such insurance. HTTP (HyperText Transfer Protocol) is a protocol that utilizes TCP to transfer its information between computers (usually Web servers and clients). The client makes an HTTP request to the Web server using a Web browser, and the Web server sends the requested information (website) to the client. -------------------------------------------------...

Install Mac OS on Windows Virtual Machine

PreRequiste: Latest preview: 10.13 Final (17A365). September 25, 2017. Google Drive (One Full):  https://goo.gl/ZEB4vB Google Drive (6 of 6):  https://goo.gl/dJe4CV Fix Download Limit:  https://techsviewer.com/fix-download-limit Code for VirtualBox (New):  https://goo.gl/GvhfVS VirtualBox:  https://goo.gl/MztVe5 Steps to Install macOS 10.13 High Sierra on VirtualBox on Windows Step 1: Extract Virtual Machine Image File Step 2: Install VirtualBox Step 3: Create New Virtual Machine Name: macOS 10.13 High Sierra Type: Mac OS X Version: macOS 10.13 or 10.12 Memory size: 3GB to 6GB ( 65% of your Ram) Virtual disk file: macOS high Sierra 10.13.vmdk Select Expert mode Choose OS file location  Choose RAM and all. Step 5: Add Code to VirtualBox with Command Prompt (cmd) Code for Virtualbox 5.x: cd "C:\Program Files\Oracle\VirtualBox\" VBoxManage.exe modifyvm " Your VM Name " --cpuidset 00000001 000106e5 00100800 0098e3fd bfebfbff...

Enable LAN Setting via registery

under HKEY_LOCAL_MACHINE>SOFTWARE>POLICIES>INTERNET EXPLORER>CONTROL PANEL there were AutoConfig Reg_DWord 1, and Proxy REG_DWord 1.  If these are set to 1 they grey out both options and the user whether an administrator or not cannot change them.  This prevent a novice user from messing up the selections.  I deleted both of these reg_dwords and the options were then selectable/changeable.