ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

21 Q & A posts tagged with Word

Sat
Jan 14
2012

Showing Arabic numeric in Word app

I have a question man, how can I change the numbers in Microsoft word 2010 from English to Arabic or I should say from Arabic to Latin? Thanks


Answer

I guess you meant from Arabic to Hindi, right?
here is the link to that in Word 2010
http://folder8.com/View/?A55FYE54TM73QB22WP7

In Word 2007
http://folder8.com/View/?6750

And in Word 2003
http://folder8.com/View/?AFI1X17TVDJT

Saturday 1/14/2012
Mon
Nov 21
2011

Please help. Microsoft Office Pro. 2010?

My Mom installed MO2010 on my computrer. I was re-arranging my room and ALL I did was unplug the tower and monitor. I didn't even diconnect the two from each other. I plugged the tower and monitor back in and went to do a Research Paper and all my Office 2010 things (Excel, PowerPoint, Word, etc.) say this when you click on them to open:
The operating system is not presently configured to run this application.
Please help me. I need Word NOW for my RP. I am not computer-smart so i don't read Computer language. SO please put it into english. Please help. You will be my lifesaver. I know it can be fixed, because all we did was unplug it long enough to move it. and it was working before that.


Answer

I am afraid you need to reinstall office 2010
Use the same cd/source your mom used and run the setup. Again

It should ask you to repair or reinstall all

Try each and good luck

Monday 11/21/2011 3:28:21 AM
Fri
Nov 18
2011

WORD, POWERPOINT, EXCEL CLASSES WANTED IN BOSTON OR NEARBY!!?

Hi,

Do you know whom teaches computer classes in Boston or near by?

If you teach or if you know someone, please let me know how much you charge for your time and where you are located.

I do not have computer, only a net book, if this could be used, fine!

Please let me know if you provide computer and space or not.

Please write me back because I need to take classes ASAP.

Thank you so much!!


Answer

I actually do these classes here in my town, and also I do them online

If you can contact me here, or through Man@VBAXLMan.com

We can discuss the online option in this case

Friday 11/18/2011 12:24:38 AM
Wed
Nov 16
2011

How to protect MS Publisher 2003 file with password?

I want to protect my MS Publisher file with a password so that no one except me could open it. Pl answer to ques with steps.


Answer

You can always use any Zip app to compress it with password

or, create a protected drive using TrueCrypt that holds these files

Get a free zip app from http://www.7-zip.org/
and TrueCrypt from http://www.truecrypt.org/

Wednesday 11/16/2011 9:09:44 AM
Sun
Nov 13
2011

Can I make A Log-In Box For a website With Just One Password for everyone to use?

I Recently Saw that www.wixlab.net has a log in like the one im asking for. you enter the password ilovewixlab It Unlocks The Downloading Feature. BUT all I Want Is For It To Take you to another Assigned Page. But if you know how to do Anything with this or what it is or where can i get it. i welcome you to answer please. Thanks!


Answer

Yes you can
You need to use cookies, based on your technology that used to build the site (php, asp, .net, cms, etc)
You can set the password entered by user to save in a cookie, then match it against the password you like.

let me know if that makes sense, I will be happy to do it if you want and if the technology is something I know

Sunday 11/13/2011 6:45:12 AM
Sun
Nov 13
2011

How do I kick an Xbox 360 from my WiFi network remotely?

I'm trying to torrent and download here but my brothers are hogging all the bandwidth playing on Xbox Live! The Xbox 360 is connected wirelessly to the network so is there a way where I can quietly kick it off the network, secretly allocate all of the bandwidth to myself, or just control my home wireless network without them knowing?


Answer

Yes, sure
Most wireless routers enable you to control that using its IP (like 192.168.0.0)
You should have that IP in the router manual
Once there, you can control who gets what
You can create password, refresh IP addresses, restrict access to only certain devices, etc

Sunday 11/13/2011 2:28:12 AM
Sat
Nov 12
2011

Ofiice Word and Excel documents icons are blank in Windows 7?

I had MS Office Starter(with only Word and Excel in it), I uninstalled it, and installed MS Office 2010 Professional Plus. The documents are opening good, but icons are blank... how to fix this, its annoying... Please help... Deleting Icon Cache didn't help... And EVEN System Restore won't help...


Answer

I would suggest that you run Office installation setup again and select "Fix installation" or may be called "Repair"
This might generally fix it.

Otherwise, you can go a head and clear the temporary files and internet cache, these sometimes do some interesting errors like yours

good luck

Saturday 11/12/2011 4:11:18 PM
Wed
May 5
2010

I can not type arabic in MS word 2003?

I can't type arabic in word 2003, I can type in excel and other programs but in word I have to press each space bar to type the arabic.


Answer

Word has two sets of keyboard keys to type (vs one set in all other applications)
I guess you already know that
Right CTRL+Shift will make it Arabic on most applications, in Word will make it write Right-to-Left
Instead, use
Right ALT+Shift to type in Arabic, even in the same direction.

If this is not the case, then I didn't understand the question well

VBAXLMan

Wednesday 5/5/2010 4:00:49 AM
Tue
May 4
2010

How to import into MS Word ,data from two worksheets from Workbook of MS Excel file ?

I have MS-excel Data with a customer sheet with address details on one sheet & Items bought by a customer on other sheet,by using mail merge I am able to generate a letter for each customer by using customer sheet,I want to include details of items bought(from that items sheet).


Answer

I suggest you having a third worksheet that list the customers and their buying details
Then mail merge it

You might need to use formulas to do so, like VLOOKUP, MATCH, INDEX, IF, COUNTA, etc
use the customerID to grap these info

VBAXLMan

Tuesday 5/4/2010 3:40:57 AM
Sun
Apr 11
2010

Import address.dat file?

Hi, is there a way to import an old "address.dat" file into Outlook 2007 without installing Palm Desktop? I have an old backup contacts list but I no longer use a Palm. I have tried to read the .dat file with Notepad, Word and Excel but it is illegible. Thanks in advance.


Answer

Try these links
http://www.ehow.com/how_6077867_convert-…

http://www.convertzone.com/all/go-epab%2…

Sunday 4/11/2010 7:47:41 AM
Fri
Apr 2
2010

Microsoft word disks?

So my sister has these installation disks for microsoft word, power point, and excel, and she installed them on her laptop. Would I be able to use them on my computer with out her losing hers?


Answer

If you got your own serial number that you bought from Microsoft, yes

Otherwise, it is consider stealing, and no one will tell you to do so

VBAXLMan

Friday 4/2/2010 5:53:54 PM
Tue
Apr 21
2009

How to disable save as option in excel & Word?

How to disable save as option in excel & Word, to protect the file from copying. But the Respective person should have the option available.


Answer

In Excel 2003, put this VBA code in "Workbook" object after you press ALT+F11
Private Sub Workbook_Open()
disablesaveas
End Sub

Then Add "Module" and paste this in
Sub disblesaveas()
CommandBars("File").Controls("Save As...").Enabled = False
End Sub

Then close the file and open it again

If you have Excel 2007, (You can also do this in Excel2003) do this
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then Cancel = True
End Sub


Good luck


VBAXLMan

Tuesday 4/21/2009 8:50:19 AM
Tue
Mar 31
2009

I want typing in hindi on ms word and Excel?


Answer

To use any language other than English in Windows
You will need to install it first

Go to
Control Panel > Regional and Language options
And make sure you see your language in that list
and also make sure that you have the checkbox checked for middle east and far east countries

or something like that

VBAXLMan

Tuesday 3/31/2009 7:10:14 PM
Wed
Jan 21
2009

How do you make a password field in excel so when you type in one of the cells, it comes up as asterisks *****?


Answer

Excel cell does not allow you to do this, you need to do an alternative ways, you got two:
1- You can use the TextBox from Forms toolbar (If you have Excel2003) or from Developer tab (If you have Excel2007)
2- Add a VBA form and add the text box to it.

Wether you do 1 or 2 you need to change the password property of it to make it show you * when you type in it

Again Excel cells can not allow you to do that, forget it

If you need help in doing this, or you don't know how to add a VBA form or Textbox to your Excel sheet, mail me here

VBAXLMan

Wednesday 1/21/2009 2:21:07 PM
Wed
Jan 21
2009

Microsoft Paint - custom sizing printing?

i have created some pictures on paint that i want to print at custom sizes (they are cd covers: back and front) i desperately need to know if this is possible. many thanks,
callum


Answer

Try these in sequence:
1- Use Word, to insert that picture and print using sizes by right click on the picture > Properties
2- Print it using "Picture Viewer", if you are using XP
3- If you don't have word, use WordPad

VBAXLMan

Wednesday 1/21/2009 9:32:08 AM
Wed
Jan 21
2009

Excel 2007 document protection & locked cells?

Hi,

I've created an excel document that numerous users will be editing, however I need for only certain users to be able to edit certain cells.

I currently am using the track changes method, however it appears that there are ways around this.

Does anybody know if there is a formula or a function I can use to only allow a user to edit a certain cell if the username = joe.bloggs for example? Excel can clearly look up the username as it does so in the "track changes" but its how do i use this information to protect my cells?

Many Thanks,
Mark


Answer

The Standard way is to give the password to modify the file (Save As > Tools > General Options) to those people only allowing them to edit these cells, while others can not

The other way is to lock these cells with password (Review > Protect Sheet) and give those the password

In addition to that you will always have the macro way, but that requires more info from you

Enjoy my profile, I am the VBAXLMan here

Wednesday 1/21/2009 6:55:16 AM
Thu
Jan 15
2009

Why won't Excel open when opening a Word merge document?

I have Microsoft Word file linked with Microsoft Excel to merge. Used to be prior versions would automatically open up both files in it's respective windows (Word & Excel), but using Microsoft 2003, it just opens the Word document and when I try to manually open the Excel file (double click the icon) it says I'm already in it. Is there a way to automatically open both files by opening the Word file?


Answer

Excel have the feature of opening more than one workbook by double click on one Icon (It is called Workspace)
Not long ago, Office used to have Microsoft Binder, that enables you to put bunch of Office files (like Excel, Access, PowerPoint, etc) in one file called Binder.
But not anymore

The way you are trying to do, I don't think they care much about it now

I would suggest that you do one of the solutions below:
1- Create a hyperlink in one doc to open another (like hyperlink in Word to open Excel file)
2- Or, Do bunch of shortcuts in one folder to open all you files, select them all, and press enter, to open all those files
3- Or, may do some old fashion bat file.

I can not see any other way

VBAXLMan

Thursday 1/15/2009 2:02:12 PM
Thu
Jan 15
2009

Ms Excel macros problem ??? ?

it give the error

Macros in this workbook are disabled bcase the security leavel is high, and the macros have not been digitally signed or verified as safe. to run the macros , you can either have them signed or change your security level.

i reduce security level high to low , i also crate one password for that file also than after it give this error ?????

what can i do ???

give full information about this problem and how to solves ??


Answer

Excel does that even if your security level is low, you will need to enable macros

I can smell that you have Excel2003 or XP, then do enable when you open the file

IF you not enable the macros, you can not run them, whatever is your level of security

It should show you a window asking you if you want to enable macros

Click "Enable macros"

VBAXLMan

Thursday 1/15/2009 7:13:43 AM
Wed
Dec 20
2006

What is the best mobile phone to buy supporting word docs, excel and email?

I've been told that Qtek 9000 is the best but after 2 or 3 months it starts failling. Can anyone give me advise/suggestions?
Cheers


Answer

If you want a cell phone wiht big screen, qwerty keyboard, wireless network, bluetooth.
Then The best one I found until now is Siemens SX66
I hav'nt seen such a big screen like this ever

VBAXLMan

Wednesday 12/20/2006 1:17:03 PM
Tue
Dec 19
2006

Excel Spreadsheet opens up blank?

Coworker wanted me to double check her work and when I open the spreadsheet it comes up blank (just gray) not even showing the columns and rows. But looking at full screen I can see it. All other excel spreadsheets are fine.


Answer

There are alot of tricks in Excel to do this, I just need you to check these one after another
1- Go to (Window > Unhide) and see if there are items shown in the dialog that appears
2- Go to (Tools > Options > Window options) and make sure you select (Row and column headers, gridlines, horizontal scroll bar, vertical scroll bar)
3- got to (Format > Sheet > Unhide) and check the hidden sheets

PS: If excel asked for password, then the file is protected, you will need it

Enjoy my profile, I am the VBAXLMan

Tuesday 12/19/2006 2:56:20 PM
Sun
Dec 3
2006

I have an excel file and I have forgotten the password. Is there a way to recover the password.?

I have checked the crack softwares on the internet. I am not ready to pay $40 for just 1 file. But this file contains some important tax info and I need to make some changes urgently. Is there any way I get recover the password.


Answer

I have one and ready to share it
I just want to ask, which password you are talking about
Excel do have at least three password levels

mail me here for it

Enjoy my profile, I am the VBAXLMan

Sunday 12/3/2006 11:05:59 PM

Tags

History