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

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

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!


Answer

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

Here is a lesson on how to do that
http://www.vbaxlman.com/Lessons/?ID=b1vi…

VBAXLMan

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

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.
Thanks


Answer

Hmmmm
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


VBAXLMan

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

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


Answer

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

Try it

VBAXLMan

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

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


Answer

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

VBAXLMan

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

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!


Answer

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


VBAXLMan

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

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!


Answer

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


VBAXLMan

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

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 :)


Answer

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

VBAXLMan

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

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?


Answer

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
Tue
Dec 19
2006

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???


Answer

Search it in
http://www.download.com
I am sure you will find something good and free

Try to search for "VCDCutter", "DVDCutter"

VBAXLMan

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

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


Answer

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

Tags

History