quinta-feira, 28 de março de 2013

Microsoft Excel 2007 does not run add-ins in earlier versions-VBA

Hi
Here's how to troubleshoot running add-ins created in versions earlier than Microsoft Excel 2007.
Installing the Excel 207 are not enabled add-ins to VBA projects. With this, when you run a spreadsheet that has VBA Tools, such as COMBO BOX-COMMAND BUTTON, you receive error messages due to lack of management component of Visual Basic Applications.

To resolve the problem, follow the step below:

1. click on Start Menu- Settings - Control Panel- Add and remove programs.
2. Select the Excel 2007 and click Modify.
3. in the installation options, select the option to add or remove features and select components of project management in VBA.
4. click Install then Next and wait for the end.
5. Log on the user account and access the Microsoft Excel 2007.
6. click on the Office Buttonin the upper-left corner of the screen and select "Excel Options" will open a screen of advanced settings.
7. Select the option "Add-ins" and then select the option to install VBA components.
8. click Add and restart Excel.

By following this step by step the problem will be solved. By às Nenhum comentário: Marcadores: , , , , ,

Error in installing Office 2007-RBUDLR.CAB

Problem to install Office 2007.
In the process of installing Office 2007 you are faced with an error message when you copy the file RBULDR.CAB. In then the installation is finalized.

See the step by step to solve this problem:
1. Insert the Office CD and open the folder
2. in the ROSEBUD.En copy the file "fp4autl.dll" to the installation folder that is in the path:%COMMONPROGRAMFILES%\microsoft shared\web server extensions\40\bin\
Note: If there is another file to replace the current file

3. Navigate again to the ROSEBUD.En Office 2007 CD and run the file ROSEBUDMUI.THE MSI.

Following this step your problem will be solved. By às Nenhum comentário: Marcadores: , , , ,

Open a Word 2010 document in an earlier version of Word

Hi
We recently had some problems with opening files created in previous versions of Word 2010; This was solved as follows:

 To open .docx or .docm files of Microsoft Word 2010 with Microsoft Office Word 2003, Word 2002, or Word 2000, you must install the Microsoft Office Compatibility Pack for Word file formats, Excel, and PowerPoint 2007 and all Office updates required. By using the Compatibility Pack to Open XML File formats for Word, Excel, and PowerPoint, you can open, change some items, and save Word 2010 documents in earlier versions of Word.

 Source: http://www.microsoft.com/pt-br/download/details.aspx?id=3 By às Nenhum comentário: Marcadores: , , , ,

Excel was unable to open the file by repairing or removing the unreadable content

Hi
See how to troubleshoot to open files.XLSM with VBA Macros.
When you go to open the file, you receive the following error message:



"Excel was unable to open the file by repairing or removing the unreadable content.
Part Removed: part of/xl/VbaProject.bin. (Visual Basic for Applications (VBA)) "

Follow the step by step to solve this problem:

1. open Excel 2007.
2. click on the Office Button in the upper-left corner of the screen.
3. Access the "Excel Options", where he opened an advanced settings screen.
4. Select the option "add-ins", then select the option "VBA-analysis tool" that was to disabled and click the button "Go" at the end of the screen.
5. in the "add-ins", enable the feature "VBA-" analysis tool, click on the "OK" button and confirm the information that the feature was not installed and would like it to be made the installation by clicking "YES".

6. supplement "analysis tool-VBA" installed and enabled in Excel.
By às Nenhum comentário: Marcadores: , , , ,

Office Excel/Word-does not allow changing the Macro security level



The problem:
You try to change the Office Macro Settings in Excel or Word 2003 and can't-even with a local administrator account.
Not permitgonechange the Macro security level in the menu Tools, Macro, security.


See how to solve this problem:

1. open the Windows registry (REGEDIT): click Start, Run and type: "regedit"
2. navigate to the keyMicrosoft\Office\11.0\Excel\ HKEY_LOCAL_MACHINE\Software\ "Security" (if the problem is in the Word change "Excel" for "Word")
3. delete the folder "Security"

4. close regedit
5. open Word or Excel and change the macro security option

Done that,the problem will be solved.

Clicking Window.thethese passthe,a new key will be created:"Microsoft\Office\11.0\Excel\HKEY_CURRENT_USER\Software\ Security" (or an equivalent Word)and the "Level" value can be set between 1 and hexadecimal 4:0 pm, where 1 is "low" and 4 is "very high". By às Nenhum comentário: Marcadores: , , , , ,

System error 8H80040111 ( -2147221231)

The problem:
You are getting the followingerror messagein Office (??): "System error 8H80040111 ( -2147221231). ClassFactory cannot supply requested class "



To work around this problem, simply delete the file pipc32.xll (the IP System) in the Office installation folder.
By às Nenhum comentário: Marcadores: , , ,

Buffer Overrun detected! in Word 2003

The problem:
The files *. c q EU are open with MS Word 2003 andare displaying the following message errthe:
"Error:" Buffer Overrun detected!in MS Word 2003 ""(has this exclamation even there?)

To resolve this problem,follow the stepsbelow:

1. log into associate mámachine with an account that has privileges of administrator;
2. navigate to the folder%programfiles%\Arquivos comuns\Microsoft Shared\PROOF\ and renomSIS file "" to "Mssp3es.OLD.dll" Mssp3es.dll

 Source: http://support.microsoft.com/kb/950009/en-us By às Nenhum comentário: Marcadores: , , , ,

The value entered is not valid


To insert a text in a given cell in the Excel error appears: "the value entered is not valid. Another user has restricted values that can be entered into this cell. "

 Solution:
1. Select the cell in which the user wants to perform change;
2. Click on the Tools menu, data
3. Ns SETTINGS tabSelect the VALIDATION option, and select the option ANY VALUE in the menu to ENABLE
4. click OK and test.
By às Nenhum comentário: Marcadores: , , , ,

Office file validation has detected a problem while trying to open the file

When you try to open a file from Word, Excel, PowerPoint, or Publisher 97 to 2003, and this file fails Office file validation, the following warning is displayed:
"The office file validation has detected a problem while trying to open the file. It may be dangerous to open it. "

 This error occurs because the Add Validation In is installed on your machine and for some mutivo he did not validate the file that you are trying to open.

 Add Validation In,
Office file validation (OFV) is a security feature that was introduced in Microsoft Office 2010 and that checks whether a specific binary file meets the expectations of the application. Office file validation can help prevent attacks by unknown binary file formats file formats from Microsoft Office 97-2003.

A quick way to solve this problem and removing the Add Validation In

1. Click Start
2. click Control Panel
3. on the Control Panel Add/Remove Programs cliqcar
4. Select Add Validation In and then click on Uninstall
Other problem that you may experience when you use the Add Validation In:
  • Files created in Microsoft Excel 2.0, 3.0 or Microsoft Excel Microsoft Excel 4.0 fail validation when you use Office file validation in Office 2003.
  • The Solver.xla file failed validation when you use Office file validation in Office 2003.
  • When you paste a lot of graphics or data points in an Office 2003 document, the paste function can take a long time to be completed while the Office file validation attempts to validate the new data.
  • Open files on a network that has many graphics or data points takes longer in Office 2003.

Another way to solve without having to uninstall Validation Add In:

Solution for Office 2010

You can manually set the registry entries by using the following values:
Value: DisableEditFromPV
Type: REG_DWORD
Default value: 0
Description: When the Office file validation failed
0 = enable editing in protected view.
1 = Disable editing in protected view.
Add the DisableEditFromPV REG_DWORD for any or all of the following registry subkeys to disable editing in protected view in Office 2010:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\FileValidation
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\PowerPoint\Security\FileValidation
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Security\FileValidation

Solution for Office 2007 and Office 2003

You can manually set the registry entries by using the following values:
Value: InvalidFileUIOptions
Type: REG_DWORD
Default value: 0
Description: When the Office file validation failed
0 = notify user about file failed. Offer the user the option to download the file or not
1 = notify user about file failed. No option to download the file.
For the 2007 Microsoft Office system
Add InvalidFileUIOptions REG_DWORD for any or all of the following registry subkeys for Office file validation in Microsoft Office 2007 system:
HKEY_CURRENT_USER\Software \Microsoft\Office\12.0\Excel\Security\FileValidation
HKEY_CURRENT_USER\Software \Microsoft\Office\12.0\Word\Security\FileValidation
HKEY_CURRENT_USER\Software \Microsoft\Office\12.0\PowerPoint\Security\FileValidation
For Office 2003
Add InvalidFileUIOptions REG_DWORD to any or all of the registry subkeys for Office file validation in Office 2003:
HKEY_CURRENT_USER\Software \Microsoft\Office\11.0\Excel\Security\FileValidation
HKEY_CURRENT_USER\Software \Microsoft\Office\11.0\Word\Security\FileValidation
HKEY_CURRENT_USER\Software \Microsoft\Office\11.0\PowerPoint\Security\FileValidation



Source: http://support.microsoft.com/kb/2501584/pt-br
By às Nenhum comentário: Marcadores: , , , , , , ,

Unable to Load Hlink.dll

Hi
If you are having problem to view a PowerPoint file, preview is displayed the following error message: "unable to Load Hlink.dll"
"Hlink.dll Can't Be Loaded" or "PowerPoint Failed to Load Hlink.dll"
This solution can also be applied to the following errors:

"PowerPoint couldn't create a hyperlink with ^ 0."

"PowerPoint failed to Load Hlink.dll"
This error occurs when there is a problem in the file "C:\windows\system32\hlink.dll" and it is necessary to replace this file.

Solutionfast:

1. Open session with administrator privileges.
2. Copy the hlink.dl_ file from the Windows XP CD that is in the directory "i386\pt\" to "c:\windows\system32".
3. Open CMD and type the following commands:
3.1. "del hlink.dll"
3.2. "expand hlink.dl_ hlink.dll"
3.3. "regsvr32/s hlink.dll"
Comprehensive solution:
1. close all open files and all running programs.
2. click Start, point to Find and then click files or folders.
3. in the box With the name, type hlink.dll.
4. in the Search, make sure that drive C is selected, and then click find now.
5. If you find the Hlink.dll file, right-click the file, and then click Rename.
6. Change file name "Hlink.dll" to "Hlink.old".
7. Insert the Microsoft Office XP CD in the CD-ROM drive or DVD-ROM drive.
8. click Start and then click Run.
9. in the Rundialog box, type the following command line where drive is the drive letter of your CD-ROM or DVD-ROM drive:
extract drive: IENT_1.cab/L \IE5\PT\IENT_S1.cab c:\windows\desktop andClick OK.
10. click Start and then click Run.
11. To extract the Hlink.dll file, in the Rundialog box, type the following command line:
extract c:\ \desktop\IENT_1.cab hlink.dll/Lwindowswindows\system32 c:\ Click OK.
12. click Start and then click Run.
13. to register the Hlink.dll file manually on the 32-bit operating system, in the Rundialog box, type the following command line:
c:\windows/s \system32\regsvr32windows\system32\hlink.dll c:\
Click on OK.

Source: http://support.microsoft.com/kb/813726
By às Nenhum comentário: Marcadores: , , ,

Windows 7 folders

Do you know where the main folders used by users in Windows 7 are?

Users' temporary files, Internet files, Start menu shortcuts, Taskbar shortcuts and others...

Know some of the important directories in Windows 7

  • Folder of shortcuts pinned to taskbar - Quick Launch

%UserProfile%\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBar

 It is in the folder above that are all the icons that you add to your Taskbar

  • Shortcuts folder pinned to the Start menu

%UserProfile%\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch\User Pinned\StartMenu

  • DESKTOP folder path of ALL USERS (All Users) in Windows 7

This folder is hidden by default. You must enable the "Show hidden files, folders and drives" option to view this folder:

1. Open Windows Explorer (Windows flag key + E) click on the Tools menu, Folder Options and check the option "Show hidden files, folders and drives";
2- Access the path: C:\Users\Public\Desktop.

  • Folder Path "Start Menu" User Profile

%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Start Menu

  • All Users Start Menu Path in Windows 7

C:\ProgramData\Microsoft\Windows\Start Menu\Programs

  • Internet Explorer Temporary Files Folder "Temporary Internet Files" User Profile


This is the path of the current user (user logged into the machine)
%UserProfile%\AppData\Local\Microsoft\Windows\Temporary Internet Files

  • Temporary Files in User Profile

%UserProfile%\AppData\Local\Temp
By às Nenhum comentário: Marcadores: , , ,

Connected with a temporary profile


Solution for Error: incident "connected with a temporary profile"

The solution is to recreate the user profile

ATTENTION!
Before you recreate the user profile, back up the existing profile; then restore the profile again.

Recreating the user profile:

1. go to the Control Panel, click System, then click Advanced System Settings
2. in user profiles click settings
3. in the user profiles, find the user you want to recreate the profile and delete the Profiles stored on this computer list by clicking the delete button
4. click Ok, and then log off
5. Request the user that log to create the new profile
6. Restore the user data and proceed with care.

Following this procedure, the existing user SIDs in the machine will be removed. The SIDs are created at the time that the user logs on the machine. SIDs of the user: the user's primary SID-Global and Universal group SIDs for the user account, domain or forest-local SIDs workstation domain (if they are different from the user's domain)-assigned Privileges explicitly to the user or derived from group memberships.

If you follow these step and does not resolve the problem, please follow the procedure below:
1. log on with an account that is not the problem.
2. copy the folder with the user profile to another location, can be another partition.
3. then delete the folder that the user profile that is the problem.
4. go to Regedit and navigate to the registry key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList",
5. under ProfileList, you will see several folders as an example: S-1-5-21-1214440339-2139871995-725345543-2750, when you click on one of them, see the right-hand side which belong to the damaged profile, and then delete it.
6. Restart the computer and ask the user what to log on again
7. now that the profile has been repaired, restore the user data and ok
By às Nenhum comentário: Marcadores: , , ,