Share008資訊科技公司

我是資深的電腦資訊從業員,曾於 Motorola 及 Philips 等跨國大型公司管理層工作十多年,具各類ERP資源管理系統及其它應用系統經驗,如QAD之MFG/PRO、SAP、Ufida(用友)、Kingdee(金蝶)、Microsoft's Dynamic、Wonderware's In-Track (SFC)、Webplan (SCM)、Hyperion (business intelligence)、Informatics (Data Warehouse)...等等。另外,我精於廠房車間之電腦資訊運作,擁有 CISSP 及 ITIL 認證,能提供日常資訊運作之檢測及審查,以提高操作效率。 本人誠意為各類大中小型廠房提供資訊審計、支援及意見,歡迎聯絡,電郵為 au8788@gmail.com

「ERP資源管理系統」已是現今廠房管理必不可少的工具,提高它的效能,絕對能改善公司之盈利,請多多留意。

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

提供香港股票價位歷史數據

我想很多人會對"香港股票價位的歷史數據"有興趣,我已下載成Microsoft Access database version 2000 的文檔,資料由2008/1/1至2009/12/2,zip壓縮後也有11M,若索取請留你的PM我 。

祝願各瀏覽者股壇威威!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2017年9月7日

How to fix Outlook "Not Implemented" error during Send/Receive

Today, when one of my customers pressed the “Send-Receive” button to check for new email messages using Microsoft Outlook (2010), suddenly he received the “Not implemented” error message on his screen. As a result of this error, the customer couldn't use Outlook to send or receive any messages. After some research on the installed programs, we discovered that two versions of MS Office were installed on the computer and the Outlook program settings probably were corrupted. So we applied the following solution to solve the “Not implemented” error:
not-implemented

How to solve the “Not implemented” error in MS Outlook

Step 1. Uninstall the Office version that you don’t want.

First of all decide which Outlook and Office version you want to use and then uninstall the other one.
1. To do that go to:
·         Windows 8/7/Vista: Start > Control Panel.
·         Windows XP: Start > Settings > Control Panel
start-control-panel 
2. Double click to open “Add or Remove Programs” if you have Windows XP or “Programs and Features” if you have Windows 8, 7 or Vista).
add-remove-programs_thumb1_thumb1_th[1]
3. In the list of installed programs, find and remove/Uninstall the Office version that you don’t want (e.g. MS Office 365).
uninstall-program_thumb2

Step 2. Repair Office Installation

Next, repair your Office installation, To do that:
1. In the program list, select the “Microsoft Office” version installed on your computer and click “Change” from the top. 
repair-office-2010-2013_thumb1
2. At the next screen, check the “Repair” option and click “Continue”.
image_thumb1
3. When the repair process is completed, restart your computer and work with Outlook again.
Additional Help: If the “Not implemented” error still occurs in Outlook, then try the following:
1. Create a new Outlook profile by going to: StartControl Panel > Mail > Show Profiles.
show-profiles
2. Now click the “Add” button to create your new profile and when finished, check the “Prompt for a profile to be used” option and click “OK”.
add-select-profile
3.Open Outlook, select your newly created profile from the list and setup your email account in this profile. Now you should be fine.

2017年9月3日

How to Crack the VBA Password Manually?

Source: https://poonamrblog.wordpress.com/2015/11/25/how-to-crack-the-vba-password-manually/ VBA stands for Visual Basic for Application, which is a component of MS Office and used by the MS application like Excel, Word, Access, etc. It is a file extension for a visual basic file and contains the visual basic source code. This file is used to add functionality to the MS office application and automates routine tasks especially in Microsoft Excel. Above, you have read about the description of a VBA file. Now focus here, if you lost your VBA password and you are looking for a manual solution to crack the password. Follow the below steps to recover your VBA password. Take a backup of VBA files first. XLSM files are same as XLSX files but you need to enable the macros to make XLSM files to XLSX. Method 1: Swap the password using any Hex Editor. Step 1: Create a new simple excel file (.xls) with the help of Hex editor. Step 2: Now, set a password in the VBA section (Alt + F11). Step 3: Save the file and Exit. Step 4: Now, open the file which you have recently created with a hex editor. Step 5: Copy the lines starting with the following keys: CMG=…. DPB=… GC=... Step 6: With the help of Hex Editor, open the file in which you want to crack the password and paste the above copied lines from the dummy file. Step 7: Now, save the excel file and exit. Step 8: Open an excel file where you need to see the VBA code and here, use the same password, which you’ve used for a dummy VBA file in step 2. Method 2: Step 1: Open a VBA file in any Hex Editor. Search for the text “DPB=”. vba password recovery 2_1 Step 2: After that replace the “DPB=” with “DPx=” and Save -> Close file. vba password recovery 2_2 Step 3: Now, open the file in Excel and then, press Yes, if the below warning message display: vba password recovery 1_3 Step 4: Press Alt + F11 to open the VBA editor and click on OK button, if you will see the following message: vba password recovery 1_4 Step 5: Right-click on the VBA project and here, select Properties -> Protection and then, delete the existing passwords. Also, uncheck the checkbox of Lock project for viewing. vba password recovery 1_5 Step 6: Now, access the VBA file easily. Method 3: Step 1: First, change the extension of the .xlsm file into .zip. Step 2: With the help of WinZip / WinRar, open the .zip file and then, go to the xl folder. vba password recovery 3_1 Step 3: Extract the vbaProject.bin file and open the file in a Hex Editor. vba password recovery 3_2 Step 4: Search and replace DPB with DPx and then, save the file. Step 5: Now, in the Zip file replace the old vbaProject.bin file with this new one. Step 6: Again, change the file extension from .zip to .xlsm. Step 7: Open the Visual Basic inside Excel an then. go to Tools -> VBAProject Properties -> Protection Tab. Now, add a new password and save the .xlsm file. Step 8: Close and re-open your VBA file with new password. Method 4: Step 1: First, open the workbook in which the protected sheet consists. Step 2: Press Alt+F11 to view or open the Visual Basic Editor. Now, enter the Insert-Module and paste the below code into the right-hand code window: vba password recovery manual method Step 3: Then, close the VB Editor window and navigate to the worksheet you want to unprotect. Step 4: Enter Tools-Macro-Macros and double-click on PasswordBreaker in the list. If you’ve followed the above manual steps and still you are not able to access your protected VBA file then try any third party VBA password recovery tool. With the help of such tool, you can easily recover your lost VBA password. This tool enables you to recover any type of VBA files perfectly. Watch the below video and know how this tool recover your lost VBA password. Follow the below steps to crack the VBA password: Step 1: Download VBA Password Recovery Tool and run it. Step 2: Click Open and select VBA file(s). Step 3: Now, click on File properties. Step 4: Click on Recover button to recover the password of selected file. Advertisements