ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

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

18 Q & A posts tagged with Office

Tue
Nov 22
2011

Im trying to repair my excel and word starter 2010?

When i go to programs they aren't on the list although the icon is right there on the desktop, how can i get them on the list?


Answer

You need to use the installation CD, to re install Office Starter, or use another option called "Repair"

Otherwise, you may need to re install the whole system (Windows and everything) if Office starter came with Laptop itself

Tuesday 11/22/2011 9:30:21 PM
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
Wed
Nov 16
2011

Microsoft Excel Certification Question?

Is it possible to just take a certification exam for excel (offered by microsoft) and nothing else?


Answer

Yes
There is a certificate called MOS on Excel
Microsoft Office Specialist on Excel
http://www.certification-crazy.net/mous_…

Wednesday 11/16/2011 4:47:59 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
Fri
May 14
2010

Why do i see the lock icons on my ms office files (excel)? How do i get rid of them?

I've a Windows 7 machine.


Answer

It is not Office issue, it is a Windows issue

You have that drive encrypted and that is why your files have lock on them

Means you cannot access them if you are not the owner
or something like that

VBAXLMan

Friday 5/14/2010 6:29:30 PM
Fri
May 14
2010

In Microsoft Office Excel, how do I get the sheet tabs to show at the bottom?


Answer

That was for Excel2003 and earlier
For Excel2007, do this
- Click on the Office Logo at the top left corner
- click on Options
- Go to "Advanced"
- Scroll down until you reach "Display options for this workbook"
- Make sure that you have the "Show sheet tabs" is checked

VBAXLMan

Friday 5/14/2010 12:01:04 AM
Wed
May 12
2010

My excel is not working on my 2003 professional edition of microsoft. How do I get it to work again?

I just got rid of a virus and tried to upload microsoft updates. Now excel doesn't work. Every time I try to open it, it tells me that it is installing the new version. Then it says the network is unavailable and something about PRO11.MSI.


Answer

It is obvious, you will need to reinstall Office2003 again
You need to have the CD for it, the same original CD you installed it the first time, to do Installation repair.

When you insert the CD, you will have several options one of them is Reinstall Office to fix some errors.

VBAXLMan

Wednesday 5/12/2010 3:49:22 PM
Wed
May 5
2010

Google spreadsheet format: how to make it look like a questionnaire and not like an excel file?

i wrote a spreadsheet on google which looked like a questionnaire (with options, multiple choice etc.) but when i saved it the original format disappeared and instead i got what looks like an excel file. How can i switch to the original format without re-writing it?


Answer

When you say "saved it" you meant export it to your desktop, right?

If so, then try to save it as another format, may be OpenOffice Calc, or any other format
Google was meant to be online and accessed from other locations

If not, then you need to report this as a bug to Google

VBAXLMan

Wednesday 5/5/2010 5:22:15 AM
Mon
Apr 26
2010

I want the output of my PHP to be opened in EXCEL or OpenOfficeSpreadsheet. How can I do it?

I have one PHP program which use mysql database. I want t the output to be opened in EXCEL/OpenOfficeSpreadsheet(in a separate window) when I click on a link provided. Any option to do it other than to save it as a CSV?The problem with CSV is that it opens as a single column and I have to use text to columns option to convert into columns. Thanks in advance.


Answer

CSV is Comma Separated Values

Means if you use values with comma as separator, Excel will open in in multiple columns

like this
"Value 1" , "Value2 " , "The long value of 3rd column"

VBAXLMan http://www.dougboude.com/blog/1/2009/06/PHP-Export-to-Excel-Snippet.cfm

Monday 4/26/2010 11:56:54 PM
Sat
Apr 25
2009

MS Office 07 Excel/Access question 10 pts best (right!~)answer?

how do you LINK (not import) an excel worksheet to an Access Database that is already in existence (this database was created by importing data from a separate excel worksheet). I'm stumped! Will award 10 pts best answer! :-)


Answer

When you open Access, and create your database
Go to External Data > Excel
And in the wizard, select the third option (Link to the data ...)

This will create a table that is linked to the Excel spreadsheet.


VBAXLMan

Saturday 4/25/2009 9:00:15 PM
Tue
Jan 20
2009

When I want to print ,it shows the messege"WINSPOOL.DLL" not found.What should I do?I am using XP5.8?

I have installed urdu software name 'inpage'.the excel and word files are easily printed but the files from inpage urdu are not printed.


Answer

It looks like your program can not recognize the XP printer style and still using the old fashion way

The best way to do it is to print the file you have into a program printer (Office has one called "Office Document Image Writer" or "Office XPS Writer")
Or you can install a free PDF printer here (Http://www.prismpdf.com) and print to that printer
This will generate a file that you can easily print using its application

So you are using a third application to print yours since you can not print using your own application

good luck

VBAXLMan

Tuesday 1/20/2009 7:48:03 AM
Sun
Jan 18
2009

Why can i not open some files?

why is it i keep getting message insert the microsoft office xp proffesional with front page disc, telling me this is on a removable disc.i am trying to open a microsoft excel file which i have done before with no problem why is it now not letting me open it?


Answer

That depends on
1- Your version of Excel
2- Did you installed the Office in full?
3- What are the file types you are opening? I mean extensions?

The best solution could be re-installing Office again, but in full this time

good luck

VBAXLMan

Sunday 1/18/2009 12:04:58 PM
Fri
Jan 16
2009

Does Excel 2007 return answers with more than 15 significant figures?

Can you do me a favour? If you are running Office 2007, can you go to Excel and type in any digit about twenty times?
My Excel 2002 loses interest after 15 significant figures and returns 0 after that. Thanks.


Answer

I did
1234567890 1234567890
And Excel converts it into
1234567890 1234500000

And when I did
1234567890 .1234567899
It converted into
1234567890 .12345

(I had to put spaces here to prevent Yahoo! from cut the number


So, it is the same as Excel2002, if you need a better one regarding this, use SPSS

VBAXLMan is back

Friday 1/16/2009 9:28:25 AM
Fri
Jan 16
2009

How can retrieve the InstallDate for Windows and MS Office with an Excel Macro ?


Answer

The date of Windows installation is the date that Administrator account was created (or your User account)
And the date of Office istalled is the date of Microsoft Office folder was created
So
Depend on your Windows version (VISTA or XP) use this code to get the installation date/time of Windows

Sub WinDate()
Dim fs, fo
Set fs = Server.CreateObject("Scripting.FileSyste…
Set fo = fs.GetFolder("c:\Users\Administrator")
MsgBox fo.DateCreated
End Sub

Change the c:\Users\Administrator to c:\Documents and Settings\Administrator if you have WinXP
(Although the second one will run in VISTA as well)

Do the same for c:\Program Files\Microsoft Office

good luck

VBAXLMan is back

Friday 1/16/2009 3:59:00 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
Sun
Jan 7
2007

How do you stop your pull down menus from scrolling?

I don't like the way the pull down menus have the unused ones hidden and i would like them all to be on. How do I fox that? I don't like turning them on manually. I am talking in Microsoft Word and Excel and the Start menu...thanks!


Answer

- In Excel and Word (All Microsoft Office applications) go to
Tools > Customize > Options
and check the option that says "Always show full menus"
- In Windows Start Menu go to
Control Panel > Task bar and start menu > Start menu > Customize (For Classic Start Menu) and scroll down to the last option "Use Personalixed Menus" and uncheck it

Enjoy my profile, I am the VBAXLMan

Sunday 1/7/2007 5:25:17 PM
Sun
Apr 2
2006

Where can I get a windows 98 compatible English spell checker for my PC. I have no English Word spell checker?

I lost my system and when I re-configured it can re-installed I didn't get the English spell checker. I live in spain and got the spanish one. That's okay but I need a word English spell checker, too. Any help appreciated. Prefer a free one but will buy one if a good one is recommended. Thanks. Henry


Answer

It depends on Office version (Word version) if you are talking about Word.
Any way re-Installing Office will solve alot of problems and saves you time and money.

Sunday 4/2/2006 8:24:31 AM
Sat
Apr 1
2006

Any software that will allow me to take notes about files on my computer?

In other words, I would like to open up my file explorer and write a note about a file that is shown in that window or tag the file. Is there any software out there like that?


Answer

All office files have this feature, Right click on any Office file (Word, Excel, PowerPoint, etc) and select properties, You will see Custom and summery, in these two tabs you can type any thing you want, and in Explorer these info will be shown in the ToolTip and in the status bar.

For all other kinds of files, i belive this will be easy in the new Windows VISTA.

Saturday 4/1/2006 7:55:38 PM

Tags

History