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

12 Q & A posts tagged with IE

Nov 13

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

I Recently Saw that 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!


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
May 14

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


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


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

In Excel 2007, how do I make specific number values correspond to specific text values?

I'm trying to create a template for entering social science questionnaires, and SPSS has spoiled me. When I start entering the data, I want to able to type numbers and then have the correct text fill the box. For example, one question concerns race. I want to be able to type "1" and have "caucasian" automatically appear in the box. However, I want to RETAIN the number values so that I can easily run statistical analyses. Can Excel do this? Someone please help!


Yes, it can
This called VLOOKUP function, it is very popular and widely used

Here is a lesson on how to do that…


Wednesday 5/12/2010 8:55:57 PM
Apr 5

My excel is not working well, as soon I open it.?

The samething is happening with acrobat, is there any free program I can use to fix these problems.


Most problems like this are caused by temp files

Let us try the following.
- Clear history and cookies
- Delete temporary internet files
Both 1 and 2 are in Internet options from Control panel
- Go to C: > Documents and settings > YourUserName > Local settings > Temp
and delete every thing here
(If you could not see Local settings, type it in address bar)
- Restart computer and try again


Monday 4/5/2010 4:45:47 PM
Apr 5

Export/Save from Oracle to Excel Spreadsheet?

Im not getting the option to save to excel.

When I press save for tsv the program stops responding then I oracle shuts down. I have checked the pop up blocker is off, enabled downloadds from IE and have also made sure the path is correct from IE - windows, Still cannot get the option to save as .xls

Many Thanks


If you can try to do export to CSV format, Excel will also be able to read that

Try it


Monday 4/5/2010 6:31:43 AM
Apr 26

How to calculate expected return and correlation coefficients in excel?

Hi everybody. Someone have any idea how to calculate and what excel formula i have to use to find the expected return and correlation coefficients if I have the following data:

Date Open High Low Close Avg Vol Adj Close*
1 868 872 827 866 7083169900 866
2 855 876 836 870 6839301900 870
3 840 857 815 857 6226187600 857
4 809 846 780 843 6286869900 843
5 772 833 772 816 6952819900 816


The CORREL function will give you the correlation coefficients, like this
=CORREL( A1:A5,B1:B5)
To find it between the two arrays A1:A5 and B1:B5


Sunday 4/26/2009 5:38:15 AM
Apr 23

Microsoft Excel - Treeview 6.0 in User form?

I have treeview 6.0 in a user form. Does anyone know how to link charts or data to the tree view, to display in a window in the user form when clicking a node? Any help would be GREATLY appreciated. Thanks!


Since you are in the VBE of Excel, you can do this

- Draw a picture box that shows when the user clicks the node
- Copy the chart and paste it as picture in some temp sheet
- Then read that picture into that picture box

This is what I have in mind right now, I think there are other ways...

Let me know what you came up with, I liked your advanced question


Thursday 4/23/2009 9:05:09 AM
Apr 6

How to print a chart in Excel 2007?

Help! I have an assignment due tomorrow where I had to make bar graphs in Excel 2007. The graphs are showing up perfectly in print preview, but the actual bars won't print. The X and Y axis and chart title prints only. I have a HP Officejet 6210. I have no idea what to do. Thanks!


You need to do these steps as they are the most popular reasons for problems like this

1- Clear history and cookies
2- Delete temporary internet files
Both 1 and 2 are in Internet options from Control panel
3- Delete "Temp" folder content (and not the folder), it is in your C: > documents and settings > YOURUSERNAME > Local settings > Temp, this will solve a lot of problems
4- Restart computer and try again

Do Step 3 if you are using WinXP, if you have VISTA, then step 3 would be
3- Delete "Temp" folder content (and not the folder), it is in your C: > Users > YOURUSERNAME > AppData > Temp, this will solve a lot of problems


Monday 4/6/2009 4:14:56 PM
Jan 21

Windows Dvd Maker & Movie maker continuously shutting down?

Opening the two associated programs is fine, its when i click on something or try to add something the program freezes and the message:
Windows Movie Maker has stopped working.
It does the same for DVD Maker.
Ive checked that all my programs have been updated but yet this problem still occurs.
I have plenty of ram and all that so its nothing to do with the hardware. Im on windows vista.

Not sure if this associates with the problem but when i try to insert my USB into the laptop a message appears in the bottom right (a balloon) saying USB has malfunctioned.
Any ideas on how to fix this?
Thanks :)


You said it might not related with hardware, but I am afraid it is
First you need to do the following:
- Delete Empty files from (C:\Users\ [YOURUSERNAME\ \ AppData \ Temp) Windows put some files for temporary and that could make that problem
- Did you changed the Ram recently? it sounds like a ram conflection to me
- If not, then make sure you are having a good VGA card (Display adapter) that can hundle the files you are working with.
- Check also if you are facing this in some files or not
- Do you case this also in any other heavy graphic applications (Like Premier or PhotoShop)?

Good luck with that


Wednesday 1/21/2009 5:30:29 PM
Jan 11

How to view more columns in Excel 2007?

I just got Excel 2007 and I can't figure out how to widen the spreadsheet to display more columns. There's an inch of grayspace on the left of the spreadsheet and four inches or grayspace on the right, yet only 9 of my 25 columns are viewable. In other words, I have to scroll left or right to get to the other columns. It's as though the spreadsheet is in a viewer that needs to be resized. Any suggestions?


Try double click the title bar of that worksheet window
If you can't, then it might be protected
When a worksheet protected mode is "Windows", then you can not resize it unless you unprotect it

VBAXLMan is back

Sunday 1/11/2009 10:07:22 PM
Dec 19

Is there software that helps me edit out sound from movies?

I want to find software that will let me edit sound clips from movies or television shows on DVD. And can I get the clip in 5.1 if the movie HAS the sound in 5.1???


Search it in
I am sure you will find something good and free

Try to search for "VCDCutter", "DVDCutter"


Tuesday 12/19/2006 9:44:06 AM
Apr 18

How to copy a dvd to your comp for future viewing? dvd ripper?


Copying move DVD is as easy as any type.

Open the DVD in explorer
Just copy the DVD folders to any folder in your hard drive
And search for the big (I mean big) files, well this is your movie
If you have a DVD player, just double click the movie

Tuesday 4/18/2006 9:26:03 PM