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

189 Q & A posts tagged with N

Mon
Feb 6
2012

Copy pictures from sheet to another

i have two workbooks, lets say, workbook A and Library Workbook
Workbook A is where all the code has been going, Library has no code in it. My project in Workbook A needs to look up and pull a worksheet out of Library Workbook - just a direct copy. Simple enough in general, only one problem. Most of the sheets in Library Workbook have images embedded in them that dont get copied when doing a direct Workbooks(Library)Cells.Copy
i can get all of the formatting, column widths, and values/formulas, but not the images
now, there is one thing i havent tried that I think will work, but it has drawbacks...i could copy the entire sheet, not just the cells, but the sheet itself and put it in Workbook A. I think that this would work in theory, but Im reluctant to try it for one reason
I have embedded sheet code in Workbook A in the sheet that I want to be the destination for the copied library contents. The sheet code is event-based, and Id like it to stay in the code. So I was trying to paste the library contents into this sheet to retain the sheet code, where if I paste the entire sheet directly from the library, I dont get to keep the sheet code, because the library, by definition, is supposed to be (vba free)

so...Ive been chasing two different possible solutions, neither one with much luck yet.
(1) Learn how to copy cells from a worksheet with the images included
i know you can use vba to copy images, but the sheets have varying numbers of images, so theres no good way to programatically handle all sheets
shapes(1).copy, ...
might be more than one image


Answer

you still can use shapes.count and start a loop, did you tried that?
however, there might be a downside, when you copy and paste, they will all be over each other, but you can override it by using:
Sheet1.shapes(x).left = Sheet2.shapes(x).left
sheet1.shapes(x).top = sheet2.shapes(x).top
assuming copying shape from Sheet2 to Sheet1
does that make sense?

Monday 2/6/2012
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
Fri
Jan 13
2012

Opinion: memorizing maps?

I was just wondering if anyone else thought that memorizing maps (of countries) is completely useless.
In these times, if you wanted to study a riegon of the world, all you have to do is LOOK at maps...memorizing them seems un-necessary...because when would you ever not have access to a map?
I have noticed this too often in my school. Whenever the classes have map tests.....everyone would freak and put all their short term memory to the test. you see them the next week (or even day) and they don't remember a thing about the map. Just the whole idea of it seems stupid.
I would like anyone's ideas. If you don't agree with me, why do you think it's important to memorize maps?


Answer

So when some one told you "I am from Uganda", you are like, "hold on, let me see my MAP!".
I seam to understand the reason especially In this country of multi-culture.
The world is getting smaller and smaller (I mean the technology jumps for the last 2 decades) and therefore people are getting closer and closer to each other.
That when these maps are important, this is at least my opinion.

Also: besides the fact that people are depending more and more on machines now, there should be plenty of space to memorize other facts, don't you agree?

Friday 1/13/2012 5:15:36 AM
Mon
Dec 12
2011

3 questions in microsoft excel! please help me!?

If you want to change a setting that applies to Excel as a whole, such as R1C1 referencing style or showing the Formula Bar in the program window, what are your first steps?
Choose one answer. A. Click the Microsoft Office Button, and point to Prepare
B. Click the Microsoft Office Button, and click Excel Options
C. Use the commands in the Editing group on the Home tab
D. Use the commands in the Modify group on the Developer tab
..

Which of the following would allow you to insert a new column in an existing spreadsheet?
Choose one answer. A. Click in the column where you want to insert; then in the Cells group on the Home tab, click the arrow on Insert. Select Insert Sheet Columns.
B. With any cell in the worksheet selected (active), select the Insert option in the Cells group on the Home tab.
C. Click in the column where you want to insert; then in the Table group on the Insert tab, click the Table command.
D. Right click in the column where you want to insert; select Insert and then Shift Cells Right.
..


How do you adjust the column width to fit the information typed in the cells in that column?
Choose one answer. A. From Home tab, Cells group, click arrow on Format. Then select AutoFit Columns Width
B. From the Insert tab, click the Column command and choose the desired column style
C. From the Page Layout tab, click the Width menu and select the desired width
D. Right click on the column label, select Format cells and select the desired width
..


Answer

Q1 B
Q2 A
Q3 A

Monday 12/12/2011 1:15:48 AM
Sun
Dec 11
2011

How to convert to Excel formula?

Please help, im not sure about this Excel formula.
I need to enter the following equation into the formula/function bar in Microsoft Excel but not sure if its completely right .

V = 0.000045 + 1/4p0.09^2[0.15+0.035-(0.035cos180+v( 0.15^2-0.035^2sin^2*180))]

I think i got most of it right, but dont know how to do the Pi, Cos, Sin or the square root.


Answer

Pi is PI() in excel

So od this
... 1/4*PI()*0.09^2 ...

Sunday 12/11/2011 8:14:43 PM
Wed
Dec 7
2011

How can I combine two cells into one with Enter between them?

I have cell A1 with name, B1 with Address, I want C1 to have NAme from A1 in one line, then the Address from B1 in line below, I don't want to go all over my 13000 cells to do that manually


Answer

That is very good question, here is what you need to do:
In C1, paste this:
= A1&CHAR( 10)&B1

You might need to select "Wrap Text" to show that

The CHAR(10) is what is called the Enter inside the cell.

Wednesday 12/7/2011 10:50:00 AM
Mon
Dec 5
2011

Why won't Yahoo won't export contacts to .csv file?

I'm trying to create a csv file with all of my yahoo contacts. I hit the "export all" the file for a yahoo.csv, screen shows a file downloads but no contact data is included in the excel file. Its just an empty excel file that includes headers...ie first name, last name, address, email etc...but none of the contacts' data is included?
What am I doing wrong?


Answer

Could be a prblem in that file format
Try open it in Notepad

Also, try add some more contacts then export again

Did you try another format?

Monday 12/5/2011 3:06:03 PM
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
Sat
Nov 19
2011

What Kind Of Excel Function Do I Need?

Q: In cell B6, insert a function to calculate the total number of units in the apartment complex in A6. Be sure to enter the criteria range as an absolute reference. Copy the function down through B10.

In column A there is a list of different types of apartments and I need to find total units of each apartment column B. what kind of function would I use to count and recognize each number of units for each different apartment?


Answer

I am not sure what do you have exactly in A6, however, I am assuming only
paste this in B6
=COUNTIF( A:A, A6)

Then fill down

Saturday 11/19/2011 8:42:40 PM
Sat
Nov 19
2011

What function to use in excel?

I have a range of the first five digits of telephone numbers and I need to replace them into country name. so i need to compare very single digit of these telephone numbers with the range of prefixes i have before deciding the country name. is there any function to do that ?

I used lookup function but it compare the number exactly
example if i have the number 27800 and in my prefixes i only have 27 it will not recognize it.


Answer

You can also still using VLOOKUP but with some modifications

Modify your list of prefixes to have the entire number with zeros
so 27 becomes 27000, 15 to become 15000, etc

here you can use the VLOOKUP with Range lookup to be TRUE, like this

=VLOOKUP( A1, D:L, 2, TRUE)

The "TRUE" will let you search for the nearest item to the searched one before it

Assuming your list of prefixes is sorted in ascendant order by prefix number

Excel help has more details about the "TRUE" in VLOOKUP

Saturday 11/19/2011 11:42:40 AM
Sat
Nov 19
2011

Excel formula to convert gram to kilo?

Hi everybody ,

I would like to know if there is a formula to convert grams (example 375 gr) to kilos (0.375)
What is the easiest way to achieve that ?

Thank you very much for your help


Answer

Say grams is in A1, in B1, paste this
=A1/1000

That is all

That would be the easiest way

Saturday 11/19/2011 10:46:13 AM
Sat
Nov 19
2011

What function to use in excel?

I have a range of the first five digits of telephone numbers and I need to categorize them into country name. so i need to compare very single digit of the telephone numbers before deciding the country name. is there any function to do that ?


Answer

Use VLOOKUP with TRUE in "range lookup" as in this question
http://answers.yahoo.com/question/index?…

You can also use other suggestions there

Saturday 11/19/2011 9:29:16 AM
Sat
Nov 19
2011

How can I convert from pipe delimited txt file to excel file?

Then convert that excel file to rss feed?

Or am I making this more difficult than it needs to be?


Answer

Excel already have Text two Columns wizard, however, you can use this one
http://www.anmars.com/Work/?P=589970000

It is in pure formulas and can be used to extract unlimited columns with certain delimiter

Once you copy and paste the content into column A fill the formulas down to extract them

Saturday 11/19/2011 3:58:51 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
Thu
Nov 17
2011

Please Help! How would i draw this graph on excel 2010?

http://imgur.com/IMLLE

Sorry the pic isn't rotated, and it's kinda small...
I can't figure out how to graph it:S I don't know how to insert negative x values in the graph, and i don't know how to change the default x values of 1,2,3,4, etc. to different numbers...
Please help! best answer will get 10 points today cause i'm in a ruuuush!
Thanks!


Answer

This one looks like a SIN(x) graph for me
just do 1, 2, 3, 4, etc in col A, then do
=Sin(A1)
in column B

Then graph it

hope this is not too late

Thursday 11/17/2011 4:27:33 AM
Wed
Nov 16
2011

Recently uninstalled Winzip and I can't download stuff anymore?

Well I recently uninstalled Winzip because I whenever I downloaded something, it would show up as winzip and when I clicked on it, I needed to get the pro version of Winzip. I deleted it and now whenever I try download something it just shows up as if its an Internet Explorer file and then when I click on it in uncontrollably duplicates itself and keeps popping out so I have to manually reboot my computer. So how can I download stuff normally again. By the way I have a PC Windows Vista and I'm trying to download Paint.NET. Thank you.


Answer

You just need a program that register .zip files with
When you first installed WinZip, it overwrites the default registration of .zip (Which was with Windows extract app)
And after uninstall, the .zip files are not registered with any app

So installing a program that register .zip files with, will solve the problem

I would suggest installing 7z, it is a free and light, and does what WinZip does mostly
http://www.7-zip.org/

Wednesday 11/16/2011 7:26:45 AM
Mon
Nov 14
2011

How to get a HP Compaq Presario CQ60 out of hibernation mode? and how to disable the hibernation mode?

I have a HP Compaq Presario CQ60 and it's been accidentally put into hibernation mode about three times now. It never wants to come out of hibernation mode, I was just wondering if anyone knows how to get it out of hibernation mode? and if anyone knows how to manually disable the hibernation mode option. If you could help me out by giving my the directions for the first, second one, or both it would be greatly appreciate. Thank You, very much!


Answer

Q1) If the computer goes to hibernation by itself, it means there were no power.
I can tell that the power cable is not firmly connected, or a worse scenario, you battery is broken
Try the following:
- Remove the battery, plug in power cable only and run the laptop
- if it runs, that means you need a new battery to replace
- If not, then mostly there is a problem inside the laptop (main board, cpu, etc) It looks like time for a new laptop.
Sorry

Q2) Once you have the laptop run, go to
Control Panel > Power Options > Change when your computer sleeps
Then remove the hibernation from all drop downs
That was if you have Win7, older versions of Windows should be something like that.

Let me know if that helped

Monday 11/14/2011 3:30:11 AM
Sun
Nov 13
2011

Is there a program that allows all downloads for windows to a mac pc?

Isn't there like a program that makes all downloads for windows work on a mac? Because there are some programs that don't work on mac.


Answer

There is something called (Virtual Machine)
http://www.vmware.com/products/fusion/ov…

That should enables you to run Windows on Mac, at that time, you can download and install just like you are having a PC

good luck

Sunday 11/13/2011 9:12:42 PM
Sun
Nov 13
2011

How to exchange text into random number and then exchange back?

I need a code so that when I run a macro in excel it will exchange items enclosed in a parenthesis to a random number. For example the text in cell A1 is: {I have a (cat) and a (dog)}. {I have (two) cats and (three) dogs}.
What I need the macro to do is that:
1. Look at the cell and search for curly braces
2. Look for text enclosed in a parenthesis
3. Replace the text with a random number
4. Replace the number with the original text
5. Then move on to the next curly braces and repeat the process

So it would look like this:
1. {I have a (cat) and a (dog)}. {I have (two) cats and (three) dogs}.
2. {I have a (1.8) and a (3.4)}. {I have (two) cats and (three) dogs}.
3. {I have a (cat) and a (dog)}. {I have (two) cats and (three) dogs}.
4. {I have a (cat) and a (dog)}. {I have (.9) cats and (1) dogs}.
5. {I have a (cat) and a (dog)}. {I have (two) cats and (three) dogs}.

All your help will be greatly appreciated.


Answer

Try doing something like this

Range("A1").value = Replace(Range("A1").value, "(dog)", "(" & Int( Rand()*100) & ") dogs")

This is the main command that you will be needing
You can actually repeat it to cover all options like these:

Range("A1").value = Replace(Range("A1").value, "(dog)", "(" & Int( Rand()*100) & ") dogs")
Range("A1").value = Replace(Range("A1").value, "(mouse)", "(" & Int( Rand()*100) & ") mice")
Range("A1").value = Replace(Range("A1").value, "(cat)", "(" & Int( Rand()*100) & ") cats")


And then put it inside a loop to check for them, like this

X1=1
Max1 = range("A1" ).currentregion.rows.count
do until x1>max1
Range("A1").offset(X1 ).value = Replace(Range("A1").offset(X1 ).value, "(dog)", "(" & Int( Rand()*100) & ") dogs")
x1=x1+1
loop





let me know if you need more help

Sunday 11/13/2011 6:58:22 PM
Sun
Nov 13
2011

How to assign a random number as an id to a marked text in a cell in excel?

What code can I use so that I can assign a random number as a the ID for a text in a cell. For example cell A1 has these sentences:
{I have (three) dogs and (two) cats}. My pets always fight. {My (dog) is afraid of my (cat) and they are both afraid of (mice)}.
I need an excel macro code so that it will assign a random number as an ID for the items enclosed in the parenthesis. I need this macro to assign a random number ID one at a time. In other words what I want the macro to do is to:
1. Search for curly braces in the cell
2. Get all the items enclosed in the curly braces that are enclosed in parenthesis
3. Assign a random number as an ID to the items in the parenthesis without touching the other text
4. Then move on to the next text enclosed in curly braces and continue until there are no more curly braces in the cell

So what the macro will do is that it will look at the contents of the selected cell. Then look for curly braces then look for words that are enclosed in parenthesis and then assign a random number as an ID for each then move on to the next curly braces.

The curly braces and the parenthesis may be changed to any marker.

All help is greatly appreciated.


Answer

The main command you might need is:
Range("A1").value = Replace(Range("A1").value, "(dog)", "(" & Int( Rand()*100) & ") dogs")

Doing it repeatedly is the trick that you will be using to replace all options once found, note that "Replace" works only if that text is found

And then put it inside a loop to check for them, like this

X1=1
Max1 = range("A1" ).currentregion.rows.count
do until x1>max1
Range("A1").offset(X1 ).value = Replace(Range("A1").offset(X1 ).value, "(dog)", "(" & Int( Rand()*100) & ") dogs")
Range("A1").offset(X1 ).value = Replace(Range("A1").offset(X1 ).value, "(cat)", "(" & Int( Rand()*100) & ") cats")
Range("A1").offset(X1 ).value = Replace(Range("A1").offset(X1 ).value, "(mouse)", "(" & Int( Rand()*100) & ") mice")
x1=x1+1
loop


let me know if you need more help

Sunday 11/13/2011 6:47:20 PM
Sun
Nov 13
2011

How to scan a passport size photo?

I use an HP printer/scanner and want to scan a passport size photo 600(width)X450(height) but when i scan the picture it doesn't come passport size what to do.


Answer

Sizes in digital world (on screen) are not measured with regular units
we have pixels instead of inches
meaning, you can scan in any size then adjust that size in any printer app (like word) to make it ready to print in the size you want.

Sunday 11/13/2011 2:18:35 PM
Sun
Nov 13
2011

Low disk space when unrar?

I've CCcleaned all junk files in my PC, and my C driver can only has 4gb left. Except progams, i store all games,media files, doccuments in a 1,5tb HDD . But whenever i extract a >4gb rar file in the HDD, the disk space in the C driver goes down until the "low disk space" warning appear.If i stop the extraction, the disk space rise up again. How do i solve this problem ?


Answer

You can tell WinRaR to use the other drive as temporary location

Here is a screenshot for that setting
http://folder8.com/View/?XDCV07RTB

Sunday 11/13/2011 7:41:27 AM
Sun
Nov 13
2011

Does 4g connect to the internet even without an access point?

such as in a car.
in a restaurant with no hotspots.
outside.
etc.


Answer

Yes

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

How do you order a recovery disc for a Altec laptop for windows 7?

anyone know the phone number and how much should expect to pay for this?

also, if can actually get a Windows 7 installation disc..what is the difference? (Btw, this Windows Installation disc is for 1 computer only..but can it be used again and again like a recover disc?)

WHAT IS DIFFERENCE BETWEEN A "RECOVERY DISC " AND AN "OPERATION DISC"?
PLEASE EXPLAIN.


Answer

Recovery disc is a Windows disc made especially for that particular PC
years ago, people used to be able to do a recovery disc on machines that not came for, but not anymore.
In another word, recovery disc is a special version of that OS with all additional drivers and software.

Here is the answer to your question:
Some companies lately have the option to save your recovery disc on your hard drive instead, and have a special software that enables user to create those recovery disc(s) for you. If you have that you can create recovery discs for free. Search something called "Recovery" on your start menu.

While Operation disc, or so called OS disc, is the OEM version of the system that should be installed on only one machine (unless they authorize you to do more)
IT IS ILLEGAL TO INSTALL ONE OPERATION DISC ON MORE THAN ONE MACHINE if it was not made for that (Some Windows7 versions allows you to install on 3 machines like Windows7 family pack)

Otherwise, it is illegal.

Let me know if that makes sense

Sunday 11/13/2011 3:23:36 AM
Sun
Nov 13
2011

Toshiba C660 cam video recording?

i have a toshiba C660 laptop it has a built in cam but i don't think any software came with it to actually record and store vid files on my laptop i am interested in making vlogs for youtube .. help <3


Answer

There are a lot of software that do that
try this
http://download.cnet.com/1770-20_4-0.htm…

Sunday 11/13/2011 2:44:24 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
Sun
Nov 13
2011

What is a good user to user chat to add to a website?

Like the user to user chat in facebook not like a chatroom.


Answer

I am personally using Chatango (http://www.chatango.com/)
It is kind of making its purpose for me

Sunday 11/13/2011 2:06:24 AM
Sat
Nov 12
2011

Simple financing in Excel for personal business?

Hey,


I've looked online for templates and such but didn't really come up with much.

My small business is in Repairs. So all I really need is an Excel spreadsheet (I have windows excel home and student 2010)

Could someone explain how i could make one with some basic formula.

Basically, I need a column for costs such as parts, and then the final invoice bill. And hopefully i can have a box to the side that will work out the final balance for that month/year.

Thanks,
~D


Answer

I have a very simple sheet that should do exactly what you are looking for

You can download it for free here
http://folder8.com/F/?Yan


Called "SimpleANBox" in 2007/2010 format

Saturday 11/12/2011 5:36:22 PM
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
Sat
Nov 12
2011

How do you insert external data into excel STARTER?

This question is specifically for Microsoft Excel STARTER. It's not like on other versions of excel where you have a data tab and can follow the steps from there.
I have already checked google also so please don't suggest pages on their or searching it on google. I have also checked the microsoft website.

BASICALLY, if you personally know how you insert data into Microsoft Excel STARTER I would really appreciate the steps on how to do it :) And will rate best answer for whoever tells me. Thanks


Answer

There are actually several ways, basically using VBA or macros
If you know how to do that there are several macros out there

I would suggest one of these
http://www.anmars.com/Work/?P=598866300
to read directly from MySQL DB into Excel sheet

or use
http://social.msdn.microsoft.com/Forums/…
to read from sql or Access

Also
http://www.bygsoftware.com/Excel/SQL/Usi…

Again, those are macros (Using the back door for Excel) to insert these data

If none of them helped, let me know from where are you inserting the data and I would be glad to show you the way.

let me know if that helped

Saturday 11/12/2011 2:17:09 AM
Thu
Nov 10
2011

Is there a way to change the auto-assigned value of empty cells in excel?

In excel, empty cells are treated as though their numeric value was 0, and as though they had no text value.
I'm using a custom function that runs through a range of data (which contains 0 values) and gives me a result based on the range's findings.
Currently, there are no blank cells before the end the range. Therefore, I can use CountA(range) to tell my function how many times to iterate (i.e. to continue until it reaches the end of the range).
I wish to instead specify to the program that it must continue to the end of the range (another problem) and ignore blank spaces.
Rather than re-writing all of my functions to ignore these empty cells, is there an excel option that will allow me to force excel to treat empty cells as a value other than 0?


Answer

If I got you correctly you can use the formula
ISBLANK()
When you put it inside IF, you will will get if the cell is blank

CountA will not count blank cells either

let me know if that solves it or not

Thursday 11/10/2011 3:34:45 AM
Sat
May 15
2010

Cluess! I need help getting my barcode scanner Qw2500 to work.?

I have the QS2500 RS-232 scanner. It seems to be working, lighting up, beeping, but it is not working in excel, or inflow program. Help!!! thanks


Answer

Try it on another port
Try it on another computer
Try it on another OS
Reinstall its own software (from manufacturer website)

After doing all that, you can tell if the problem is in the scanner itself or in the software

VBAXLMan

Saturday 5/15/2010 1:00:58 AM
Sat
May 15
2010

Is there a way to send batch emails from a list in Excel through Outlook at different times?

I am curious to know if there is such code or function that can send batch emails from a list in Excel with a personalized message through Outlook for delivery at different times.


Answer

This is the file that does that
maybe except for the "delivery time" thing
http://www.vbaxlman.com/Files/?ID=4S374y…

You can customized it if you like

VBAXLMan

Saturday 5/15/2010 12:03:22 AM
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

Can we use excel worksheet to evaluate a multiple choice question answer sheet?

for eg: to a question, 1) Prime Minister of UK is
a) David Cameron b) Nick Klegg c) Gordon Brown d) None of the above.
how to use logical formulas in EXCEL for candidates answering as a/b/c/d and to assign 1 mark for correct answer and 0 for incorrect


Answer

You need to put the answers in one row or one column
Then use the COUNTIF formula to calculate how many A's there

Something like this:
=COUNTIF(3:3,"A")

Assuming your answers a,b,c,d are wherever in row 3

VBAXLMan

Friday 5/14/2010 1:52:10 PM
Fri
May 14
2010

Excel question currency question?

Basically what i want to do is take colum m multiply it by 1.42 and show the results in colum N in the cell ajoining the original amount this make sence?


Answer

If you have the first value in cell M3
then in Cell N3, paste this

=M3*1.42

Then copy N3 down until the end

VBAXLMan

Friday 5/14/2010 11:14:43 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
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
Tue
May 11
2010

How can you make an excel workbook, with about 1500 formulas that total from 3 other workbooks?

The auto fill does not work because it is pulling in information from 3 separate workbooks. Is there a quicker way then building all the formulas separately.


Answer

It looks like you have custom external links,
something like this

http://www.vbaxlman.com/Lessons/?ID=fjam…
This lesson will show you how to get values from several sheets

And also this one to show you how to generate external links
http://www.vbaxlman.com/Lessons/?ID=pbkw…

VBAXLMan

Tuesday 5/11/2010 8:36:52 AM
Sat
May 8
2010

How to create a fixed x-axis in Excel 2007 charts?

I need to make an Excel 2007 line chart with a fixed x-axis that starts at 0 with tic marks every 10 values up to 100. My data values fall within this range, but I don't want the data points to determine the x-axis. Can someone tell me how to do this?


Answer

Right click on that X-axis, and click "Format Axis"
Then, make sure you check the options that said "Fixed", instead of "Auto"

Doing that will make it fixed to the specified values, even when the line goes out

VBAXLMan

Saturday 5/8/2010 7:10:13 PM
Fri
May 7
2010

How can I insert intervals of numbers, not discreet elements into Excel?

I need to sketch the sin, cos functions' graph in Excel. I have a problem with a domain. I don't want to manually type myriad values - even then, the graph is sharp, not curved, and inaccurate. Is there a possibility that I simply set an interval, infinite, but bounded set, as a domain? If yes, how do you do it?


Answer

You need as many points as you can to do the exact curved sin
to answer your question, do the following:
- Do the first number you want in a cell, say you do 5 in cell E4
- Now do the second number with the intervals into the second say.
So if you want to have the numbers as 5, 15, 25 (with 10 interval), put 15 in cell E5
- Now select both cells
- Drag the selection from the black square at the right bottom corner down to whatever range you want.

Or, you can also do:
- Put 5 in cell E4
- Select some range of cells including cell E4 (Cells E4 to E20)
- Go to:
Edit > Series > Fill (if you have Excel2003 or earlier)
Home > Fill > Series (below SUM sign)

And select the interval and stop value

VBAXLMan

Friday 5/7/2010 1:54:43 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
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
Mon
May 3
2010

Any microsoft excel experts here? need excel formula please help?

i know i asked this before but i never got a formula and i am still looking

i am looking for an excel formula in which i can add exactly one month to the month thats on the left of it on the previous row.

for example

Date Date
12/27/10 1/27/10

the second one i wish to show up automatically,

i know that it would be something like this:
=DATE(YEAR(C13), MONTH(C13)+1, DAY(C13))

but i am looking for a formula for the entire column so that i do not have to add the formula to each individual cell

thank you in advance


Answer

Just Copy and Paste that cell (with formula) to the cells below

VBAXLMan

Monday 5/3/2010 8:23:46 AM
Sun
May 2
2010

Excel help? 10 points?

http://i181.photobucket.com/albums/x93/x…

1. Add the numbers in the Student Number column as labels. (Example: '1203)

What does this question mean and how would I add the labels?


Answer

Labels by default are enabled, means you can use them right away
however, labels are usually the first column (or first row) of a table

It is confusing that you want to ADD labels
may be you need to enable them, if they are disabled
Go to Excel Options > General tab
And search for the "Use labels in formulas" check box, make sure it is clicked

After you enable them, you can use them in formula, just like
=SUM(Student Number)
to sum all the numbers


let me know if it worked or not

VBAXLMan

Sunday 5/2/2010 5:33:27 PM
Sun
May 2
2010

I need to have the auto sum function in excel calculate alphabet characters?

I would like to have the sum function include alphabet when calculating sums. How can I do this?


Answer

Did you try the formula LEN
LEN is the formula to sum how many characters in a cell

So, if you add this in column D (Assuming the column C has the cells you want to sum its chars). paste this
=LEN(C1)
Then copy it down to get the length of all cells characters

Then do a regular SUM on column D

Hope this will help

VBAXLMan

Sunday 5/2/2010 6:53:36 AM
Sat
May 1
2010

Why does it come up with "#VALUE!" when i subtract 2 cells in excel? and how do i correct it?

How do i get it, to come up with the actual answer. Thank you! :)


Answer

Another way is using the N function
Like this

=N(A1)-N(A2)

N will convert the text (that represent a number) into a number

VBAXLMan

Saturday 5/1/2010 2:11:18 AM
Wed
Apr 28
2010

Is there a formula for a name count within the entire workbook of excel?

I am creating a workbook in excel with January - December Spreadsheets. I need to find out if there is a formula that I can use to count how many times a name is used through out the ENTIRE workbook, not just each sheet. Thanks in advance.


Answer

You have two options:
1- is use the COUNTIF with multiple-3 dimensions ref
In English, do this
=COUNTIF( January:December!A:IV, "name")
Just make sure that the sheets January to December are in the regular order.

2- Using INDORECT to retrieve the value for each sheet (In a new sheet), then total that
- Put sheet1 name in cell A2 in new sheet
- Paste this in B2
=COUNTIF( INDIRECT( A2&"!A:IV"), "Name")
- Put other sheet names below and fill B2 down
- Total the column B to get the total plus the number for each sheet

Let me know if all these makes sense or not (from my profile)

VBAXLMan

Wednesday 4/28/2010 12:53:03 PM
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
Mon
Apr 26
2010

How to add check boxes to Excel 2007 to a column if a the row has data?

I want to have check boxes in column D, but I dont want the box boxes to appear unless data is intered into column A, that way I can keep the spread sheet clean because I will be adding data to this spread sheet daily. I have no idea how to even start this process. Any help would be great! Thanks!


Answer

The only ay to add checkbox automatically is using VBA or macros

However, there is another way, but using Validation instead
You can use Validation based on Validation, or Validation based on your value in column A
Make the validation list of Yes, No and you will get something similar to check box

Check out Multiple validations here
http://www.file1.net/lesson.asp?id=6y0x6…

VBAXLMan

Monday 4/26/2010 7:24:31 PM
Tue
Apr 13
2010

How do you write a VBA function to work in any Excel spreadsheet you have open?

I wrote a function and saved it in my personal.xls file. When I want to call that function from another spreadsheet, I have to write Personal.xls!FunctionName(). Is there a way to write the code so that I don't have to reference my personal file each time?


Answer

That is because your function name is the same as a build-in function already used in Excel
Try a unique function name, like MYFunc0001

That is the only reason I see, otherwise, the function would be work easily as long as the function file is open

I am using that all the time

let me know

VBAXLMan

Tuesday 4/13/2010 7:47:09 AM
Mon
Apr 12
2010

How do I find an 10 character alphanumeric string in a Excel spreadsheet cell with 70+ characters?

I need to find a 10 digit character string that is in a cell in Column G that has 70 plus characters. It can be located anywhere. The 10 character string will have these unique attributes:

* 10 characters long
* 1st two characters will be alpha (can upper or lower case)
* last 8 characters will be numeric

The following formula provided by this forum gives me a TRUE return if the this string is the only data in the cell, starting in position 1.

=AND(LEN(F2)=10, CODE(LEFT(F2,1))>64, CODE(MID(F2,2,1))>64, ISNUMBER(VALUE(RIGHT(F2,8))))

How can this formula be modified to:

1.) Allow me to find the string anywhere in the text
2.) Place the 10 digit string into Column H

Thank you.
Your assistance is appreciated.

Mark


Answer

I would do it if I only have the file

mail it to me so that I can do what you want

Trust me, If Excel can do it, then VBAXLMan can do it

Monday 4/12/2010 5:10:35 AM
Mon
Apr 12
2010

How do I remove blank (but not necessarily empty) cells from a drop down menu in excel?

I want to have a row of drop down lists. In each drop down I want all the options to exist EXCEPT any that have already been selected. This is my primary problem. The closest I can get is to remove value from the drop down range by an IF function in the source data, so that the list updates based on what has already been selected. This requires extensive functions and also leaves blanks in my drop down menus. I'm keen to have the drop downs only contain the remaining options and no blank gaps. Are there any solutions to either the primary problem, or, failing that, a solution to remove the blank (but not empty) cells from my drop down menus?

Cheers :)


Answer

You have very interesting request

Check out this file
http://www.File1.net/Links/NewList.xls

It has new list populated every time user selects an item, the new list will have the same as old list without the newly selected one, it was done for tutoring purposes

It should do what you are looking for, you might need some tweaks though
That was done using the following Excel features:
Data Validation
OFFSET function
IF function
Name

Let me know if it helped or not

VBAXLMan

Monday 4/12/2010 2:35:47 AM
Sun
Apr 11
2010

How do you add an npv function into vba for cash flows?

I have interest rate as 10% and future value of 1,000. I've already done everything in VBA that allows excel to show 10 years of present values, future values and compounding factors. I just don't know how to add a function in for NPV so that a specific cell would add up all the present values that were already calculated with the formula pv = fv / (1+irate) ^ 1 using VBA and not excel's npv function or sum of values.


Answer

You have several options here
1- Use the mathematical way to calculate the NPV
2- Use some temporary cells to set the values and use NPV in another cell do calculation, then read the result
3- And the one I used a lot is to use WorkSheetFunction object to use Excel function in VBA, like this
NewValue = Worksheetfunction.NPV( MyRate, MyAmount, etc)

If none of those helped, that means I didn't get your question right, reply me here.

VBAXLMan

Sunday 4/11/2010 4:36:44 PM
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
Sat
Apr 10
2010

Microsoft excel function?

how would i enter f(x) = 33.5 +1.3log(x+3) in microsoft excel as a function in order to graph it?


Answer

Let's say you will have your x's value in cell A2, paste this in B2

=33.5+(1.3*LOG( A2+3))

And press Enter

If you got new X value in cell A3, copy and paste cell B2 to B3, and so on

VBAXLMan

Saturday 4/10/2010 10:08:03 PM
Fri
Apr 9
2010

How do I populate corresponding cells with a code in excel?

Hello Everyone,
I have been struggling this for so long , your help will be much appreciated.
I am trying to make an invoice for a sales order with many different items. I need to know how I can populate the corresponding cells automatically from data stored somewhere else when I enter the product code for the specific item so I don't have to always enter it manually. For example, if I enter product code A-1 on cell A, I want the other cells on the line to be filled out automatically like "Hair Styling Iron" on cell B and "$50" on cell C and so on...

Thanks!


Answer

Once you have this table in some sheet (say Sheet1)
A, B, C, D
ID, Name, Description, Price
ID1, Name1, Hair Styling Iron, 50

Then in your invoice sheet, let me assume you have cell B15 has the Item ID that you want to populate its values, then in cell C15, paste this
=VLOOKUP( $B15, Sheet1!$A:$D, 2, FALSE)
And paste it down to fill other items

Then in D15, paste this
=VLOOKUP( $B15, Sheet1!$A:$D, 3, FALSE)
And paste it down to fill other items

=VLOOKUP( $B15, Sheet1!$A:$D, 4, FALSE)
And paste it down to fill other items

And you got what you are looking for

Let me know if that make sense or not

VBAXLMan

Friday 4/9/2010 9:02:55 AM
Mon
Apr 5
2010

How do I create a book collection list in excel 2007?

I am trying to categorize the library books I have read based on the receipts the library provides on check out. The library cannot provide me a list of the books I have read because of "Privacy" laws. I cannot remember if I have read a certain book before till I start reading it after checking it out.


Answer

I am not sure if this will help you or not
but if you have the ISBN number you can easily get the book info using this small Excel-app

http://www.file1.net/project.asp?id=8061…

VBAXLMan http://www.file1.net/project.asp?id=8061…

Monday 4/5/2010 6:17:17 PM
Mon
Apr 5
2010

How do you run a macro within a formula in microsoft excel 2007?

.... for example If(A2=A3, "Run Macro", "")

thats what i want to do, i just dont know how to do it


Answer

A formula is ACTUALLY a macro
It is FUNCTION macro and not SUB macro

So, to do that, you need to replace the lines of your macro
from
Sub WhatEverName()
....
End Sub

TO

Function WhatEverName()
...
End Function

AND, putting that function in a module (and not a form module) will enables you to run it as formula
However, you need to go to "User-Defined Functions" in the Insert Function dialog and you should see it there

Keep in mind that this is a macro, means that you need to have the macros enabled for that file to make it run

Also, you can run that formula from any opened file, as long as the file that has the function (the function macro) is open

You can see it in action in this free file
http://www.file1.net/project.asp?id=b2vi…


Does that make sense? let me know if not

VBAXLMan http://www.file1.net/project.asp?id=b2vi…

Monday 4/5/2010 4:33:00 PM
Mon
Apr 5
2010

How do I view and edit Excel documents on my HTC Snap?

I have been trying to figure it out, it was the main reason for buying this particular phone. I have read through the manual twice, but most of the stuff in there is common sense stuff...not what I need. Can anyone help me?


Answer

Your phone comes with Windows Mobile 6.1, right?
Then you should already got Microsoft Excel Mobile.
Just copy the file into your phone and open it

If you don't have Windows Mobile, then I you need to have a third-party app that opens it.

VBAXLMan

Monday 4/5/2010 10:52:34 AM
Sun
Apr 4
2010

Create an automatic table based on the past three months?

hi, i have an excel sheet with the past five years data on it. Each row represents a month so each month it gets one row longer.

I already have a defined range that selects the most recent 3 months, but i need to know how to display the last 3 rows and the field headings on another sheet in a specific position by the click of a button(macro).

I can make a line graph using the last three rows of data with just a click of a button and now i want to show the data used underneath the chart.

Thanks for all answers


Answer

You don't need a macro to do that
You can make it in Formulas which means faster, auto updated, etc

Let's start with some assumptions:
- You have two sheets (Sheet1 has the full data and Sheet2 to have the last three months)
- In Sheet1, your data starts from cell A1 along to V1, with headers in first row and the data below it.
- In Sheet2, you want the last three months to be in A2 to V2, A1 to V1 has the row headers

Now, in Cells A1:V1, just copy the headers (you need to do that once)
In cell A2, paste this
=OFFSET( Sheet1!$A$1,COUNTA( Sheet1!$A:$A)-ABS(ROW()-1),COLUMN( )-1)

Then copy A2 along to V2, then copy Row2 into Row3 and Row4

These three rows will bring you the last three rows from your table in Sheet1 assuming you don't have any empty cells in that table in column A
And when you add new values at the end of that table in Sheet1, these will automatically updated

Does that make sense?

let me know

VBAXLMan

Sunday 4/4/2010 11:13:43 AM
Sat
Apr 3
2010

Excel Data Bars. How to change its orientation?

I want to use Conditional Formatting > Data Bars in excel 2007.
The challenging part is that I want the Data Bar to grow from Right to Left in the cell.
By default in excel they go from Left to Right in the cell and I can not find a way to change it.

Is it possible to change the the orientation? If so, How to??

thanks


Answer

I can't see a way to go over that

Sorry!

VBAXLMan

Saturday 4/3/2010 1:34:04 PM
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
Fri
Apr 2
2010

Database records exported to Excel CSV encode language characters?

I have database records that use different language characters (European languages mostly). When exported to Excel file, CSV to be exact, these characters are come through as encoded. I have an example here, characters "zlw" output as "zlw". I tried "charset=UTF-8", "charset=ISO-8859-1" and nothing. Any ideas?


Answer

You might need several attempts
- Copy the CSV file, in case you messed it up
- Open the CSV file in NotePad (Open NotePad, drag the file to it.)
- Do "Save As", now what is the suggested format of the file?
- I recommend importing the file in Excel instead of open it
- In both cases, use the same format used in Notepad

I faced issues like that when I work with Arabic/Hebrew chars, and these steps usually work it out

If not, then pay attention to the format when you export the data from the database, most database applications give you the ability to choose the format when export

Good luck and don't forget, VBAXLMan is here

Friday 4/2/2010 3:25:51 PM
Fri
Apr 2
2010

Can you insert a drop-down or subcategory into an Excel text filter list?

I have a vocab spreadsheet that filters terms by their assigned Category, but there are a great many categories and I'd prefer to make many of them subcategories within the Category filter (essentially, a drop-down within a drop-down, but within a text filter list), rather than create a separate column from which to filter the subcategories, but so far it does not seem possible!


Answer

Using AutoFilter, the only approach I see is what you already did, which is adding another column with the subcategories

However, you can still use some trick to make it in one column by having certain mask in the categories name
So if you have Cat1, Cat2, Cat3
And Cat10 is sub of Cat1, Cat20 is sub of Cat2, etc
Then do this in the category column
Cat1 - Cat2
Meaning combining the two categories into one cell, the do sort and you can now easily visually see the category/subcategory in one column

Does that make sense?

let me know if not

VBAXLMan

Friday 4/2/2010 2:59:51 PM
Fri
Apr 2
2010

How do i set up a formula in excel using "choose"?

i've got this for example : "11.Jul.95" and need to use a formula ( which i guess is "choose") to pick the season like July - Summer
please helpp!!! :D


Answer

Actually it is like this
If your date is in cell B1, then in C1 paste this

=TEXT( B1,"mmmm")&" - "&CHOOSE( MONTH( B1),"Winter","Winter", "Spring","Spring","Spring", "Summer", "Summer","Summer","Fall","Fall","Fall", "Winter")

This will show it exactly how you want it

VBAXLMan

Friday 4/2/2010 12:56:16 PM
Tue
Jun 9
2009

In excel, is there a formula to select the last cell of worksheet to calculate values in the next worksheet?

I currently used this formula:
='NSN Motorsports'!A12+1
In this example my previous worksheet is "NSN Motorsports" A12 is the last cell in that worksheet. I used this formula to create the next number on the new worksheet. This requires me to go back to the previous worksheet and click the last cell. My workbook will have many worksheets, so doing it this way is very time consuming. Any ideas for formulas that will not require me to leave my current worksheet to get a value from the previous worksheet?


Answer

You can create a pattern for your sheet names
After that, use some formulas to determine "the previous" sheet to the one you are in...
1- In an empty cell (make it B1), paste this
=MID(CELL( "filename",A1),SEARCH( "]",CELL( "filename",A1))+1,500)
This will give you the name of that sheet, so copying that cell into another sheet will give the name of that sheet, etc
2- Now, If your 'Pattern" is NSN1, NSN2, NSN3, then paste this in B2
="NSN"&VALUE(Mid(B1,4,1))-1
This will give you the name of the "Previous" sheet to the one that you are in
So if you are in NSN4, B2 will give you NSN3, and so on
3- Finally, to get the last value of the "Previous" sheet, do this
=MAX( INDIRECT( B2&"!A:A"))+1

Good luck with that, this will be totally automated method, justcopy and paste the three cells into the new sheet

If you need more info or think that you can customize it more, please contact me here

After all, it is the VBAXLMan here

Tuesday 6/9/2009 11:08:54 AM
Sun
Apr 26
2009

In Microsoft Excel, how does protecting a worksheet affect the autofilter function?


Answer

In the Protect Sheet dialog, you can select what the user can do

You can select any of the checkboxes in the List including
1- Sort a table
2- Filter table (Show/Hide rows)
3- Select cells

VBAXLMan

Sunday 4/26/2009 4:36:54 PM
Sun
Apr 26
2009

Windows Vista Question! Please help!?

Okay, so I have a Windows Vista home edition, and all of the sudden, my video player has stopped working. a few Youtube videos work at random, I have no idea why some work and some don't there no correlation between them, and nothing completely flash dependent like games works. I know I have the newest version of Adobe flash player and Java, and I have enough RAM (my computer has fifty GB to work
with), and it goes nearly daily cleanup, so why won't videos work?


Answer

From your question I understood that you might need to do Windows Media Player updates

Do that here
http://www.microsoft.com/windows/windows…

Good luck

VBAXLMan

Sunday 4/26/2009 12:11:15 PM
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
Sun
Apr 26
2009

How to made a 'formulae spreadsheet'.?

Does anyone know how to print a excel (2007) document the displays the formulas used to create the numbers.


Answer

First you need to show the formulas
- Click the OFfice Logo at the top left corner
- Excel Options > Advanced
- In the "Display Options for this worksheet" select "Show formulas in cells instead of thier calculated results"
- Ok
Now you can print it with CTRL+P as usual

Good lock

VBAXLMan

Sunday 4/26/2009 4:03:30 AM
Sun
Apr 26
2009

Excel: is there a way to emulate the lower function without using lower()?

Excel: is there a way to emulate the lower function without using lower()??

note: it has to work for cells with 2 or more words


Answer

I think there is, but it is going to be too long and time consuming
If your cell is in A1, paste this in B1
=IF(CODE(MID( $A$1,COLUMN()-1,1))=32," ",CHAR( CODE(MID( $A$1,COLUMN( )-1,1))-32))

Then drag it to right to cover all letters of that text
After that, you can easily use CONCATENATE or the & symbol to assemble them into one cell text, like this
=B1&C1&D1&D1
or
=CONCATENATE(B1,C1,D1, E1)

until you reach the end


good luck


VBAXLMan

Sunday 4/26/2009 3:23:34 AM
Sat
Apr 25
2009

Code in Sheets vs. Code in Modules; Excel?

I transferred all my module code into specific worksheets modifying Subs to Private Subs and replacing Form Controls with ActiveX controls. Am I running into any disadvantages doing so? Is it helping me any, besides the fact that pressing ActiveX buttons feel more like clicking buttons than Form Control buttons do?


Answer

I can think of one...
If you want to do a USER-DEFINED-FUNCTION, then you can not do it in a worksheet module, you would have to do it in a Module

Other than this, You still can call any sub/function in a worksheet form other worksheets, using the "Public" key before the sub/function name


One more thing, selecting ActiveX or Form controls are not affected by Module or sheet module


VBAXLMan

Saturday 4/25/2009 1:48:16 PM
Sat
Apr 25
2009

I want to add no. of hours spreaded in multiple rows in excel, can any body tell me the formula for the same?


Answer

If you have these cells values entered as numbers (and not dates), then use the regular sum function, like this
=SUM(A1:A5)

If you have these cells values as times (or dates) then that would requires some work
Try using this one
=HOUR(SUM( B:B)-INT(SUM( B:B)))

Where you have the dates in column B


VBAXLMan

Saturday 4/25/2009 8:50:20 AM
Sat
Apr 25
2009

I am using Microsoft Excel 2003.?

I am wanting to make a list of words so that by typing in the first letter it will automatically fill in the whole word. I do not want to have to type the list of words first (there are alot of them!!), but for this to be a setting which i can apply to different sheets. I do not want the validation option of a drop down list (there are just too many words i need to auto fill) Is this possible?
Please help! thank you!


Answer

Options 1:
If you have these words in one column, once you try to enter a word, Excel will automatically list the words that starts with the same letter

Option 2:
If you have all these words listed in a column also, right click on the empty cell (below it) and select "Pick from list"

Option 3:
Data Validate (which you already refused to do) but, you can make it Auto-updated, so when you add a word to your list, it will automatically be in the populated list
http://www.file1.net/lesson.asp?id=a1vh8…

Option 4:
Use some macros to do that

Option 4 requires some work and sample files, reply me here if you are interested



VBAXLMan http://www.file1.net/search.asp?query=va…

Saturday 4/25/2009 7:05:09 AM
Sat
Apr 25
2009

How can i enter my country date in excel instead of english date?


Answer

You need to set the date in Control Panel to your country code to do that

Control Panel > Regional Options


Once you do this, it is automatically changed in Excel to your way


VBAXLMan

Saturday 4/25/2009 4:46:46 AM
Sat
Apr 25
2009

I want Convert Numerical numbers convert in characters in excel.?

What’s the formula for the converting while I am use a formula =num2text(e5) e5 is a cell where is a numerical digit.
Example 100 hundred
101 hundred one
102 hundred two
Tell me what’s problem in above formula or if any other suggestion.


Answer

Here is the file that does that

http://www.file1.net/project.asp?id=KoFR…

It can do English and Arabic


Enjoy it

VBAXLMan

Saturday 4/25/2009 4:34:20 AM
Thu
Apr 23
2009

I need an MS Excel Formula that generates the total time taken from a list of times.?

Example.

I have a list of times (clock times) and I need to get the total time (duration).

5:30 am
5:45 am
6:15 am
6:30 am

The total duration time spent should be 1 hour and 15 mins or 75min.

Can I get an excel formula that does the above?


Answer

I am not sure if I got you correct here, but let me try this...

Option 1:
Now, if you have that list starting from cell A1 down
Paste this in B1
=MINUTE(A1)+HOUR( A1)*60&"min"
Then paste this down to get the others

That is one possibility answer to your question

Option 2:
Another one is this
=HOUR( A1)&" hours and "&minute(A1)&" min"

Option 3:
Or this
=SUM(A:A)


Let me know

VBAXLMan

Thursday 4/23/2009 11:41:34 PM
Thu
Apr 23
2009

Excel > Use formulas on the last x rows of data?

I'm keeping track of the total number of wins and losses for a sports team. There's one game a week. I will have 16 rows in my Excel sheet to mark a win or loss. If the team wins that week, I'll put in "W" for that week's row, and "L" for a loss. As you can imagine, a new row will be populated with either a "W" or "L" as the weeks progress.

I'm trying to get a win/loss count of the last 5 games played. So if the team has played 7 games, I want to show the total number of wins and losses of the last 5 games (games 3-7). If 10 games have been played, then show the total number of wins and losses for games 6-10. This is similar to the L10 statistic for baseball, hockey, and other sports, but in this case, I'm trying to do a L5 for the last five games.

How can I achieve this in Excel? I'm going to use COUNTIF for counting the total number of "W" and "L", but I need it to count only the last five rows of data.

Any help is appreciated. THANKS!


Answer

Do this so that whenever you add new row/week it will automatically updated

Now, if your list of Ws/Ls starts from A2 down, paste this in D1
=COUNTIF( OFFSET(A2, COUNTA(A:A)-6,0,5,1),"W")
To get the number of Ws in the last 5 non empty cells in Column A

And do this in E1
=COUNTIF( OFFSET(A2, COUNTA(A:A)-6,0,5,1),"L")
To get the number of Ls in the last 5 non empty cells in column A

Also assuming you have the cell A1 with text as header

Good luck


VBAXLMan

Thursday 4/23/2009 4:19:56 PM
Thu
Apr 23
2009

I want to convert number to text using Excel 7.0 function.please give suggestions?

Ranjeet chiplunkar
email ranjeet_chiplunkar@yahoo.co.in


Answer

Here is the file that does that

http://www.file1.net/project.asp?id=KoFR…


VBAXLMan

Thursday 4/23/2009 4:18:21 PM
Thu
Apr 23
2009

Excel line between rows 264 and 265?

If you scroll in your all the way down in excel you will see a black line between does two rows. Is there any point to it?


Answer

That usually because you had data before (or Format cells) up to these rows and deleter them using Clear and not delete

To get rid of that, you should "DELETE" the rows (Right click and select "Delete")

This will also reduce the size of your file

If you have any problems or didn't understand the answer, mail me here


VBAXLMan

Thursday 4/23/2009 3:32:19 PM
Wed
Apr 22
2009

Ms excel help.. .. finding the coefficient of correlation, r^2?

ok so i need help finding the r^2 of linear and nonlinear regressions, to compare which ones fit better......... using excel.

eg. if power reg. curve is 0.998 and quad. curve is 0.992 ... then id choose power reg,

i know how to do it on a graphing calculator... but i need it for an assignment......

so how do i find it for a curve?

p.s. ive got excel 2003.....


Answer

Once you got a graph
- Right click on the line
- Select "Add Trendline"
- Select the type of that trendline
- Go to "Options" tab
- Click on "Show R2 equation"


That is all


VBAXLMan

Wednesday 4/22/2009 6:17:33 PM
Wed
Apr 22
2009

How do I write an excel formula to display an asnswer if a Number in one cell appears in another column?

I need to find out a formula that will display an answer in a blank Cell if the number contained in another cell in the same row is present within a whole column on another worksheet.

For example, if 1 is present in cell B1 in worksheet 1, then I want the formula to be able to search the whole of column C in worksheet 2 for that number (1) and if it is present display a custom text (e.g. training) in the blank cell A1 on worksheet 1.

I know my description is pretty garbled, but if someone could help I’d be eternally grateful.


Answer

I guess you want to know the famous VLOOKUP function

Here is a free video lesson that talks about that
http://www.file1.net/lesson.asp?id=b1vi8…


Check out other lessons below

VBAXLMan

Wednesday 4/22/2009 2:26:46 AM
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
Apr 21
2009

Excel 2007: Autoshapes dislocated on printing?

I have a 2003 excel file which has many arrows (autoshapes)... once we upgraded to office 2007, these arrows appear bit moved (dislocated) when printing or previewing. Tried file xls and tried to upgrade it to xlsx and still the same problem when opening in Excel 2007. Any idea why this is happening? is it a bug of compatiibiltiy between Excel 2007 and Excel 2003?
why?


Answer

Mostly yes, it is a bug

I would recommend to open that file in Excel2003 and group these objects then save the file and use it in Excel2007

Also, try the following:
1- Install the same printer you were using in Excel2003 and make it default
2- Do some cleaning to your computer (Follow these steps http://answers.yahoo.com/question/index?…
3- Make sure you have the Print scale to 100%



VBAXLMan

Tuesday 4/21/2009 7:22:25 AM
Sat
Apr 18
2009

Can you format an Excel cell with a formula and without using a macro or the Conditional Format menu?

Can you enter a formula directly into a cell to change the format of the cell, mainly the font color or the background shade color?


Answer

No
No formula there to change the format of another cell (If not macros nor Validation)

Forget it

Sorry!

VBAXLMan

Saturday 4/18/2009 12:52:04 AM
Fri
Apr 17
2009

What does the $ do in an excel spreadsheet?

What is the function of the $ sign in an excel spreadsheet?


Answer

It is called the Absolute and Relation symbol
Here is a free lesson about what it is doing
http://file1.net/lesson.asp?id=GlcNf6q11…

VBAXLMan

Friday 4/17/2009 9:44:03 PM
Wed
Apr 15
2009

Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.?

Frequently i get this type of Error Report when am using Microsoft Excel. What does this mean exactly? What is the problem? How to prevent this? After this message i could not able to open my file. Could anyone answer for this?


Answer

I faced that exact problem a month ago, it turns that because I have an HP as the default printer
Once I chose another one, this problem gone

Try it, that might be yours


VBAXLMan http://guymclaren.com

Wednesday 4/15/2009 11:11:01 PM
Mon
Apr 13
2009

Separate English and Traditional Chinese (excel file) into 2 columns without special characters (; or : or *)?

Hello there:

Hope u can help me...

I have a huge list of Buddhist terms (20,000) in Traditional Chinese, together with the English definition for each of the 20,000 entries. Problem: all of the terms are listed in a single column, with the english definition coming before every Traditional Chinese concept: what I try to mean with this is that some english definitions involve more than one single word (some definitions have 23 words as a whole), and the same concept, but in Chinese, might involve more than just one character (up to 7).

I cannot use a "space" to separate the text into different columns, because of the amentioned reason, there are not special characters that separate the English of the Chinese (such as ; or : or *), its all like the following sample:


9-11 am ??
a (walled) city ?
a bed ??
a day without work is a day without food ????????
a heap ?
a ko?i of nayutas ?????
a man ??
a thread, a butt ????
a wild fellow ???

like this, all the way up to 20,000

So, do u know of any way I can separate the whole text into different columns, based on the used script (Chinese and English)?

I asked some Computer science teachers at a local university: they suggested to create a macro that differentiates the script in use according to ASCII (english letters come with very low numbers, while Traditional Chinese must involve really big numbers, or so they said), but, I confess that my knowledge of computing is extremely low (main reason Im contacting u, btw...)

Hope u read this message, understand my broken english, and give me an answer...

Thanks a lot

Cheers


Answer

You don't need a macro to do that
I just fixed something like this (in pure functions) few days ago, it was about changing CamelCase to Proper, here is the file in case you are interested

Modifying that file, you can do something like this

If you have the cell in B4, paste this in E4

=IF(OR( COLUMN()-4>LEN( $B4),SUM( $D4:AC4)>0),"",IF(CODE( MID( $B4,COLUMN( )-4,1))>150,COLUMN( )-4,""))
Then copy and paste up to column AD (to get the possibilities of 26 characters)
Now in cell AE4, paste this to get the left side of the text (Before the first Chinese char)
=LEFT(B4,MAX(E4:AD4)-1)

And this in nAF4 to get the right part (after the first Chinese char)
=MID(B4,MAX( E4:AD4)+1,500)


Good luck with that, let me know if you didn't understand it or you want to edit it

VBAXLMan is here to fill your Excel needs

Monday 4/13/2009 12:09:05 PM
Mon
Apr 13
2009

Can you change the color of the Split or Freeze lines in Excel?


Answer

This splitter is one of Windows environment colors, you will need to change it from there

This is not Excel issue, Excel itself reads it from the OS

VBAXLMan

Monday 4/13/2009 10:45:24 AM
Mon
Apr 13
2009

How to add Counter to an excel workbook?

How to add Counter to an excel workbook, such that we can track how many times the excel had been viewed. The countability can be tracked?


Answer

- Press ALT + F11 to open VB Editor
- Double click on the "Workbook" object in the Project Explorer window
- Paste this in the white code area
Private Sub Workbook_Open()
Sheets( "Sheet1").Range("A1") = val(Sheets( "Sheet1").Range("A1")) + 1
End Sub

- You need to make sure that your sheet is named "Sheet1", if not, just put the name of your sheet instead of Sheet1 in this line
Sheets( "Sheet1").Range("A1") = val(Sheets( "Sheet1").Range("A1")) + 1


Good luck

VBAXLMan

Monday 4/13/2009 7:45:11 AM
Mon
Apr 13
2009

MS Excel . I want to search the value of one cell among other cells to check the validity of that cell among o?

Dear Sir/Madam,

To make my question more clear I want to search the value of one cell among other cells to check the validity of that cell among other cells.for instance,

a1:Jack
b1:paula
b2:jack
b3:matue
b4:sara
in case of making chart c1:true or false
in this example=T

a1:Jack
b1:paula
b2:sam
b3:matue
b4;sara

in case of makin chart c1:true or false
in this example=f


Answer

You can use COUNTIF, like this
=COUNTIF( A1, B:B)
To count the number of times that the cell A1 showed in the range B:B

Or may be like this
=IF( COUNTIF( A1,B:B))
To get True or False


That is what I could understand from your foggy question

VBAXLMan

Monday 4/13/2009 3:44:05 AM
Mon
Apr 13
2009

Is it posible to change the colour of a cell by using functions in MS-Excel ?

By Using functions in Ms Excel can we change the colour in a cell.
for example: if A1=1 then RED colour, A2=2, Then YELLOW colour..


Answer

In Excel2003, go to
- Select the cell
- Format > Conditional formatting
- Enter the values and the format for each condition (maximum 3 conditions)
- Press Ok

In Excel2007
- Home > Conditional Formatting > Highlight cells rules > More rules
- Select the values and the format for each
- You can do up to 256 conditions

Enjoy it

VBAXLMan

Monday 4/13/2009 3:04:36 AM
Sun
Apr 12
2009

Excel cannot access or encrypted hey friends plz help me this is a big problem for my HR Department?

Excel cannot access or encrypted hey friends plz help me this is a big problem for my HR Department


Answer

You need to give more details, please

It is not helping when you repeat the question


VBAXLMan

Sunday 4/12/2009 2:46:21 AM
Thu
Apr 9
2009

How do I merge multiple Excel worksheets into one Master sheet that updates?

I am creating a program for the agents in my real estate office. It is a Lead Management program. It has 5 worksheets, one for each different type of customer. I would like a 6th sheet that will contain all the names from the other 5 sheets. I also would like the "Master" sheet to update automatically when a new lead is added or changed. HELP!!!


Answer

Actually
SUM function WILL work fine
It will omit cells with names, or anything else than numbers
So it will sum only the numbers in the range

I would suggest checking out this video lesson, it will help you to do SUM across sheets
http://file1.net/lesson.asp?id=fjame5p10…

Then do the SUM using the same context
=SUM( INDIRECT( bla bla bla))

Lets assume you have the sheet name in cell A1, and you want to sum the row 1 from that sheet.
So paste this in cell B1
=SUM( INDIRECT( A1&"!"&ROW()&":"&ROW() )

Then copy it down to cell B2, B3 and B4 to make these cells get the total of the corresponding rows from the sheets in the range A1, A2, A3 and A4 respectively

Hope this helped

If not, mail me here

VBAXLMan is here to fill your Excel needs

Thursday 4/9/2009 2:01:12 PM
Thu
Apr 9
2009

Can I count number of rows based on 2 critera that are inputted by the user?

I have many sheets of raw data that I am trying to Roll up in a simple Dashboard using excel. So far I have managed fine but have come stuck on this part.
I am trying to count a number of rows based on 2 criteria. The problem is these criteria are inputted via validation list from the user!

The user selects a name of a program and what week number they would want to view a button is selected to run a macro that calculates this information.

The macro is no problem just the input of the search criteria via validation list.
I have tried everything I know but cant figure it out.
Any help is much appreciated


Answer

I would rather you do DSUM
Here is a video lesson on how to do it
http://file1.net/lesson.asp?id=6d2CvCTrt…

You can make the criteria range as the same as the validation cell (Excel will not mind)

Let me know if everything goes well or not

VBAXLMan

Thursday 4/9/2009 12:12:14 PM
Thu
Apr 9
2009

Microsoft Excel question?

I have a column of percentages E127:E132 and I need a formula that will return one answer ($250.00) if there are three or more items in the column above 98% and another answer ($0) if there aren't.


Answer

=IF( COUNTIF(E127:E132,0.98)>=3,250,0)

Paste this in a cell

VBAXLMan

Thursday 4/9/2009 8:23:55 AM
Thu
Apr 9
2009

How do I create a formula that pulls information from one excel spreadsheet to another?

I have multiple spreadsheets in the same excel file and I am trying to create a formula or a set of formulas that will recognize a number, compute how many of the items have that number and then on a separate spreadsheet, show that sum. What I am working with are 7 spreadsheets- 4 weeks, month, quarter and year. In the week spreadsheets, an incident is labeled with a 1,2,or 3 depending on its severity. I need a formula that would calculate all of the 1s, 2s and 3s separately as their own value and then place that value in my month spreadsheet in the 1, 2 or 3 category.

Thank you in advance for your help.


Answer

If you have:
1- The week sheet name is "week"
2- The range where the 1s, 2s and 3s are in "week" sheet is A1 to A20
3- The month sheet name is "Month"
4- 1 in cell A1 in "Month" sheet
5- 2 in cell A2 in "Month" sheet
6- 3 in A3 in "Month" sheet
Then paste this in B1
=COUNTIF( Week!$A$1:$A$20, A1)
Then copy it to B2 and B3

VBAXLMan

Thursday 4/9/2009 5:20:30 AM
Thu
Apr 9
2009

I want to know the Ms-excel formulas. to use excel.?

I want to know different formulas in excel like vlookup,hlookup,pivot table,conditioning formats & links ect.,


Answer

There are a lot of websites that can help you
try these

http://MrExcel.com
http://www.File1.net

VBAXLMan

Thursday 4/9/2009 12:16:34 AM
Wed
Apr 8
2009

How do I find and list all values in Excel?

I have a workbook with many sheets listing all of the schools my org interacts with. Each sheet lists 1-5 email addresses, depending on how many contacts we have.

I want to have a summary sheet that lists all of the email addresses so it's easy to copy-paste them to send out newsletter.

I did a FIND/REPLACE for "@" and it found all of the email addresses, but it won't let me copy paste them from the search results.

I've also been trying to do reserach on how to do this with a formula, macro, or VB but haven't come across anything.

Thanks!


Answer

Here is a simple macro that will help you doing that

http://www.file1.net/project.asp?id=x16f…

Enjoy it,, it will copy all rows from all other sheets than the current one into it for manipulating easy

VBAXLMan

Wednesday 4/8/2009 1:16:26 AM
Tue
Apr 7
2009

Percentages in excel?

how do i calculate percentages on one column and post them on the next column?


Answer

If you have the number you want to get its percentage in A1, paste this in B1
=A1*50%
To get 50% of the value in cell A1

Then copy and paste B1 down to match all values in column A

VBAXLMan

Tuesday 4/7/2009 8:15:32 PM
Tue
Apr 7
2009

Filtering data in Excel 2007 based on formatting?

I have two columns I need to filter. Some have text and some have text with strike-through (a line going through the text). Does anyone know how I can filter based on the strike-through - or if that's not an option can I filter based on anything that is not formatted like the regular text so it will separate the cells with the strike-through? Thank you.


Answer

There have been a lot of requests to read format through formulas

Since it is nit supported yet, here is a user definec function to do that

Function IsStrickeThrough(CellAddress As Range) As Boolean
If CellAddress.Rows.Count = 1 And CellAddress.Columns.Count = 1 Then
IsStrickeThrough = CellAddress.Font.Strikethrough
End If
End Function

To use it...
- Press ALT + F11
- Insert > Module
- Paste this
- Now go to any cell and use it like this
=IsStrickeThrough( A1)
Assuming the cell you want to check is A1



Enjoy it



VBAXLMan

Tuesday 4/7/2009 9:01:21 AM
Tue
Apr 7
2009

Auto Generate Calendar in Excel?

Anyone know how to generate a calendar, in excel, with appointment entries from worksheet data as a sourc?. Just like creating a graph and using worksheet as data source. Want to do the same thing, but populate a calendar. Thanks


Answer

Here is a free calendar for any month any year
It also has the ability to show your appointments for a full year

http://www.file1.net/project.asp?id=k7fr…

Enjoy it

VBAXLMan

Tuesday 4/7/2009 5:43:51 AM
Tue
Apr 7
2009

Is There A Function On Microsoft Excel Which Allows Me To Highlight Duplicate Records?

What I need to do, is to paste 2 different corporate structures into one spreadhseet and then delete the duplicates. Is there a function on microsoft excel which ahighlights any duplicate records in column A of excel?

Thanks


Answer

Yes
If you are using Excel2007, the Conditional Formatting in the Home tab has duplicates, go to
Home > Conditional Formatting > Highlight cell rules > Duplicate values

If you are in Excel2003, then you may need to use a function plus the conditional formatting like this
Use the COUNTIF function in an empty column to show 1 if duplicated, 0 if not like this
=IF( COUNTIF( A:A, A1)>0,1,0)
Then apply conditional formatting to that column to color if the cell value equals 1

Enjoy it

VBAXLMan is here to fill your Excel needs

Tuesday 4/7/2009 5:22:21 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
Mon
Apr 6
2009

Excel Chart Function?

The problem is this: To generate chart on a chart sheet u should:
1. Generate it on excel sheet 2) Select the function Move Chart 3) select Chart.
In my case, when I select Chart (3) I get a blank sheet and the chart does not appear on the selected chart
Thank u


Answer

That sounds weird
Try this...

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

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 2:14:09 PM
Mon
Apr 6
2009

Not Show Excel Formula Results?

hi

I have a formula with IF function in a cell and I dragged it to replicate the formula .

This added FALSE in all the cells how do i avoid that and have nothign displayed but the formula will still be active in that cell

thanks


Answer

Use this mask

=IF( [condition] , "", [result])

Something like this
=IF(A1-"", "", 40/A1)
This will show nothing if the cell A1 is empty

You can also try this
=IF( NOT(ISNUMBER( A1)),"",40/A1)


Enjoy it

VBAXLMan

Monday 4/6/2009 1:40:53 PM
Mon
Apr 6
2009

In Microsoft Excel, the auto filter does not show all my items that are listed.?

There are a lot of drop downs, but it randomly does not have all come up in the list. If I go to them in the spreadsheet, they are in there correctly but do not appear in the filter drop down. Does anyone know why this is? thanks


Answer

Autofilter requires no empty spaces between rows
That could be the reason
Or

Make sure that you disable / enable the Auto filter

VBAXLMan

Monday 4/6/2009 7:58:05 AM
Mon
Apr 6
2009

Moving a chart to a new page?

I am using excel 2007. After I making the chart on the excel sheet I cannot move the chart into a new chart sheet


Answer

Try cleaning up your temp...

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

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 2:45:48 AM
Sun
Apr 5
2009

How can i restore deleted excel files?

In my Server excel file missing then how can i restore that file


Answer

I faced similar issue a while ago and restored all my deleted files
There is an application called FinalData, it worth every penny

Just make sure that you didn't create / copy large files into that drive that had your files

Check it out here
http://download.cnet.com/FinalData-Enter…


VBAXLMan

Sunday 4/5/2009 7:49:07 PM
Sat
Apr 4
2009

How to solve this problem with Excel conditional formatting?

I have a table on an Excel spreadsheet, which table contains only numbers. I want to color a "path" in this table using the following algorithm:

1) Make current the upper left cell and color it.

2) Examine the cell to the right of the current one and the cell beneath the current one. Make current the one that contains the smaller of the two numbers and color it. If the two numbers are equal, make current and color the cell beneath the current one.

3) Repeat 2) until the bottom or the right edge of the table is reached, whichever occurs first.

Can this be done using only the means of Excel's conditional formatting (i.e., no VBA) and how? That is, what formulas for conditional formatting to use?


Answer

Conditional formatting will "FORMAT" the cell and not change the cell content

To change cell content (or value) you will need a function

Based on your request, IF function would do the trick for you
Now, if your first cell is A1, then paste this into it
=IF( OR(A2="",B1=""),"", A2<B1, A1, IF( A2>B1, B1, A2))

Then fill cell A1 down

Now, Since the Conditional Formatting is to "FORMAT" cells, I don't see where you need it here

let me know

VBAXLMan

Saturday 4/4/2009 11:14:45 AM
Fri
Apr 3
2009

Working with Excel 2007?

In Excel 07 how do you put in the formula to make time add (i.e.)
1330hrs - 1500hrs = 2hrs. 30mins in one cell


Answer

What you need actually is to convert a regular number to a hr. min format
So, you can do this
=INT(A1/60)&" hrrs. "&A1-INT(A1/60)&" mins"

This will convert the number of hours in cell A1 into the format you wanted

Since all you have are numbers of hours doing the add is just like any other numbers

Or, you can do this
=INT(( A1-B1)/60)&" hrrs. "&(A1-B1)-INT(( A1-B1)/60)&" mins"

To subtract B1 from A1

VBAXLMan

Friday 4/3/2009 9:41:41 PM
Fri
Apr 3
2009

CountIF, DCount or DcountA, please help?

Hello
How are you? Hope you are fine & will receive this message at your best.

I have a problem & I need your help.
I have created a work sheet in MS excel where I have entered all our transactions during the last year processing by our different sales representatives in different cities of country.
Column D contains CITY which may b like Lahore, Karachi or Islamabad where they have sold the items, & column I contains sales representative name like Ali, Asad, Waqas etc who have sold the items.
I need to do a count of all the transations where the city is "Islamabad" AND the Sales representative is "Ali"

Please help


Answer

You have these options:

1- If you are in Excel2007, you can use COUNTIFS, which will count based on more than one condition (up to 30)
2- If you have Excel2003, you can do DCOUNTA, since the cells are having strings
3- You can also do DCOUNTA in Excel2007.
4- You can add a column having the criteria you want using simple IF, then count that column, something like this
=IF(AND( A1=T1, B1=U1),1,0)
Assuming
A1 has the city name and the list goes down to whatever
B1 has the sales man and it goes down also
T1 has the city you want to search for
U1 has the sales man you want to search for
Then do a SUM for that column to have the count
5- You still have another option, which is PivotTable, but I don't recommend using that powerful tool for something simple like this

let me know

VBAXLMan

Friday 4/3/2009 12:45:16 AM
Thu
Apr 2
2009

Shopping List software for Pocket PC Windows Mobile with POS style interface?

I would like to get a shopping list software for my smartphone, but all of the ones i've seen are either overly complicated or just simple checklists.

I would like to have a program that functions similar to a point-of-sale, when you search for an item in a database, it adds it to a "cart", you specify the quantity, and it adds the total cost as it goes. I would also like the ability to alter a line's quantity or price, as well as add a one time MISC item that is not in the database. I also have Pocket Excel; I'm not sure if there is a clever way to setup something like this with the limitations of Office Mobile.

I've searched freewarepocketpc.net and haven't found anything I like. Any ideas?


Answer

Try these websites also

http://Handango.com
http://wiki.xda-developers.com/
http://www.spbsoftwarehouse.com/

If I were you, I would do it in Pocket Excel, step by step using functions

It is true that it is limited Excel, but even though you can do a lot with it

VBAXLMan

Thursday 4/2/2009 7:58:01 PM
Tue
Mar 31
2009

How can I create a Macro with Excel 2000 and Visual Basic.NET?

When I start Excel 2000 and click tools > marcro > visual basic editor, it starts Visual Basic 6. I also have Visual Basic.NET and would like to program Macros in a more up to date version of VB. Is there a way to do this?


Answer

No, Cozmosis you are wrong

Sorry Nathan
All Excel versions after Excel97, (Including Excel2007) are having VBA version that is based on VB6
Excel97 has the VB5 version of VBA

You can not program VBA code in Excel using other than the built-in VBA

Which is for now all in VB6

You would may be wait until they might put .NET in the coming version of Office

VBAXLMan

Tuesday 3/31/2009 3:42:01 PM
Thu
Feb 12
2009

How to create a function in Excel...a second question?

Thank you to the person that helped me yesterday...a huge help! The isanswer and match functions worked great!

I now need to write a formula to do the following: I need to find if the value in cell C1/Sheet 1 is in column D/Sheet 2. If true, return the value (text) in Column E/Sheet 2 that is in the same row as the value found in Column D. If false, return "null" or "false".

I tried the same isanswer and match formula as it seemed it was close to the solution but it didn't work. Can you help me again? :)


Answer

Paste this in cell E1 Sheet2
=IF( ISNA(MATCH( Sheet1!C1, Sheet2!D:D,0)), "","Text")

And fill it down

----- Edit ----
Yes, in this case, use this
=IF( ISNA(VLOOKUP( Sheet1C1, Sheet2!D:E,2,FALSE )),"Not found",VLOOKUP( Sheet1C1, Sheet2!D:E,2,FALSE))

This whould work

VBAXLMan

Thursday 2/12/2009 3:18:14 PM
Wed
Feb 4
2009

In excel, is it possible to find a string or data in a set of pdf files?

I Need to extract information automatically from a set of pdf,, lets say I have 3 pdf files named. f-1.pdf, f-2.pdf, f-3.pdf and I need to extract a value inside the f-2.pdf file. that string will be something like "force A =100lb"
I need to extract that 100.

any clue where I can start to look?


Answer

If you don't have Adobe Acrobat (and not Acrobat Reader)? then I guess the only solution is copy and paste

May be any pfd creator application can help you automate that

VBAXLMan

Wednesday 2/4/2009 6:33:25 PM
Wed
Feb 4
2009

Excel 2003 - VB - Accessing abilities between modules for public functions?

I have one module with:
"Public Function Code128B(inpara As String) As String"
and then the function (i'm pretty sure it's copyrighted etc; it said Shareware on a few sites i was at and it's for barcodes)

I have another module with:
----------
...
Dim foot As String
foot = ActiveWorkbook.Name + " " + ActiveSheet.Name
ActiveSheet.PageSetup.CenterFooter = "&""MRV Code128bMA,Regular""&14 " & Code128B(foot)
...
----------

And the error is returning is that it is an "Ambiguous Code Name"

Is there something fishy going between modules with public functions? I'd think that a public function means it's always available to every module but I'm not sure.

If this is not enough data to solve the problem say so and I'll just let the whole thing drop (it's not my code or job to fix it :P )


Answer

You are right
"Public" will set this function public to every other module inside that workbook
And I quote "That Workbook"
If you are running this from another workbook, you need to call the function in another way
Workbook1.xls!Code128B(Foot)

If you are using the same workbook, then you may need to check two stuff:
1- You have a reference to the library that is used by that function
Some function requires you to add a reference (Toos > References) to a specified library to make it rub
2- You don't have the "Option Explicit" in any of your modules

If you still face the problem again, mail me some sample files, I can do it for you (May be for free)

VBAXLMan is here to feed your Excel needs

Wednesday 2/4/2009 9:05:51 AM
Wed
Jan 21
2009

I have no space in my local disk? Help?

I was trying to download a program for my laptop and i hadnt enough space to download it and save it to my local disk.

But in my TEMP_PART01(D:) 76 gb of unused memory.

How do i use this memory?


Answer

You can move the download folder to D:
What is the application you are trying to download with?

Go to ite settings and change the download folder into any folder in D:

Also you can select the folder you want to install that application in into D:

So you can make use of it

VBAXLMan

Wednesday 1/21/2009 8:09:23 PM
Wed
Jan 21
2009

Searching across sheets in Excel?

How can I do a search for several items across sheets in Excel, whether using vlookup or any other function


Answer

This is the lesson for that
http://www.file1.net/lesson.asp?id=28

Enjoy it

VBAXLMan is here to feed your Excel needs

Wednesday 1/21/2009 6:54:45 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
Wed
Jan 21
2009

What are the available Note-Taking Apps for Windows?

I'm looking for the best note taking app that runs on windows and saves locally (at least has that ability). Does anyone have any ideas?


Answer

You can try any of those:
1- Install Yahoo! Widgets and get the notepad widget, it is all free
2- There is an application comes with Microsoft OFfice 2007 that does that too
3- Or check free ones here
http://www.download.com/1770-20_4-0.html…

VBAXLMan is back

Wednesday 1/21/2009 5:26:35 PM
Wed
Jan 21
2009

Urgent! MS Excel Macro help needed!?

Hello

For worksheet A, I need to loop through the values in column A, and if AX="cow", then I need to copy cells CX, FX and HX into worksheet B.

Any tips or code on how I can accomplish this?

Thank you very much.


Answer

Sure, Advanced Filter is your solution
- While you are in Worksheet B, type the name of the AX field in Worksheet A and type "cow" below it
- Go to Data > Filter > Advanced Filter
- Check the option "Copy to another location"
- And enter the three values, knowing that, the Criteria range is your two cells in Worksheet B

Enjoy it, it is a powerful feature

VBAXLMan is back

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

In the new excel (2007) when you type in a cell, it comes up like normal text (so you can highlight it etc)...?

but I want it like the old version, so that you cant highlight it etc. apart from in the formula bar, does anyone know how to do that thanks


Answer

Go to Excel Options by clicking the Office logo (at the top left) and press "Excel Options"

Now, in Advanced > Edit Options
Make sure the checkbox "Allow edit directly in cell" is unchecked

Enjoy my profile, VBAXLMan is back

Wednesday 1/21/2009 2:49:20 PM
Wed
Jan 21
2009

Excel Formula - I need help!?

Hi,

I'm not sure if I'm supposed to use the If formula for this - and if so, how. Here's what I want to do:

Something has X views, 10,000 for this example. I want:

1) The first 100 views to be worth 3 points each (=300 points)
2) The second 100 views to be worth 2 points each (=200 points)
3) The third 100 views to be worth 1 point each (=100 points)
4) Any view thereafter to be worth 0.75 of a point (in this case, 9,700 views times 0.75 = 7,275) points.

How would I create a formula like that (without having to actually divide up the views into four groups and do the separate calculations?)

Thanks!


Answer

So these views are in column B I assume starting from B1
Then in C1, paste this
=CHOOSE( INT( ROW()/100)+1,3,2,1,0.75)

And copy it down to the end of your list

This column will give you the points you have to multiply by, just add another column multiplying the value you want time this, or change the C1 into
=CHOOSE( INT( ROW()/100)+1,3,2,1,0.75)*B1

VBAXLMan is back

Wednesday 1/21/2009 2:42:33 PM
Wed
Jan 21
2009

How do you convert a sound file to play on a power point?

I'm making a power point and i want a song to play through out the presentation. I tried to apply the song, and it said it needs to be converted to .wav ? Or something like that? Can anyone tell me how to do this PLEASE!!! Thank you in advance :)


Answer

The best one I tried is this one
http://www.download.com/WM-Converter/300…

It is free, try it

VBAXLMan

Wednesday 1/21/2009 12:08:47 PM
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
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
Mon
Jan 19
2009

How do you print comments on microsoft excel 2007?

i can't make the comments print on microsoft excel 07


Answer

Go to Page Setup by:
- Click the "Page Layout" tab
- Click the small arrow next to Page Setup section (below the "Print Titles" command)
- Then in "Sheet" tab select "As displayed on sheet" for "Comments"

VBAXLMan is back

Monday 1/19/2009 11:31:33 PM
Mon
Jan 19
2009

Excel % formula non-blanks?

I have an xls where I want to enter a formula that counts the # of non-blank cells & divides by # to get a % result. i.e 56 non-blank cells/735=8%. Can anyone show me how to do this?


Answer

Sure, COUNTA will do it for you
like this

=COUNTA( A:A)/735

Format that cell as Percentage to get the %

VBAXLMan is back

Monday 1/19/2009 2:57:55 PM
Mon
Jan 19
2009

Can you help me with my Excel question?

I have people send me a lot of reports that were created through AIX access. I usually take those reports and dump it into Excel, where I do some formatting afterward. A problem that I run across every now and then, is when I hit a multi-valued field and the information is displayed vertically... like so (I will put in which cell it would fall into next to the value)

A1 - [patient 1] B1 - [perscription number 1]
B2 - [perscription number 2]
B3 - [perscription number 3]
A4 - [patient 2] B4 - [perscription number 1]
B5 - [perscription number 2]
A6 - [patient 3] B6 - [perscription number 1]

and so on, and so on...

Is there any way to get those values to move to be displayed on line like so

A1 - [patient 1] B1 - [perscription number 1] C1 - [perscription number 2] D1 - [perscription number 3]
A2 - [patient 2] B2 - [perscription number 1] C2 - [perscription number 2]
A3 - [patient 3] B3 - [perscription number 1]



I appreciate any assistance you can give, and I apologize if I've made my own question sound more complex than it has to..


Answer

Yes, you have two solutions:
1- Using macros, which sounds to me in your situation faster and easier
2- Using formulas, but this will be kind of duplicated formula (or set of formulas)

Now, I want you to answer some questions:
1- How many is the maximum number of drugs per patient you can expect?
2- The formula below, can work in cells C1, D1 and E1 and below, but the problem will be deleting the empty rows, if you answer Q1, then I think I can do that also
Now paste this in C1
=IF( $A1="","",IF( OFFSET( $A1,COLUMN( )-2,0)="",$B2,""))
And this in D1
=IF( $A1="","",IF( OFFSET( $A1,COLUMN( )-2,0)="",$B3,""))
And this in E1
=IF( $A1="","",IF( OFFSET( $A1,COLUMN( )-2,0)="",$B4,""))

then copy those three down

I told you it is a complicated, now these three will transpose your rows into columns
You will still need to delete the empty row, I could delete them using formulas, but I needed more details as I told you

Enjoy my profile, VBAXLMan is back to feed your Excel needs

Monday 1/19/2009 8:44:10 AM
Mon
Jan 19
2009

How can i sum or count Yes or no in a column and categorized them in Product group im just one formula?

Excel Formula


Answer

SUMIF will do only one criteria, so you will need SUMIFS, but this will work in Excel2007 only
If you have Excel2003, then you can do DSUM

DSUM is criteria based sum, but you will need to build range of cells as your criteria range

You didn't give that much info, otherwise I could do it for you

Mail me here with more info or some sample file, and I can do it for you for free

VBAXLMan is back

Monday 1/19/2009 4:34:55 AM
Sun
Jan 18
2009

Excel - how can I have a cell auto-completed with a description of another cell filter?

Hi
I have a spreadsheet with lots of orders on it that I want to filter by name, I have set up the filters fine and that is working well. However, I want another cell in the same sheet to show what I have name I have chosen to filter.
Is this possible? If so, how.

Any help appreciated.

MGB

Any help appreciated.


Answer

The AutoFilter does not do that
Or you can not do this in AutoFilter
However, you can do this if you are using Advanced filter

Advanced Filter allows you to filter range based on a criteria in another range
Meaning you can see the filter criteria when you filter the table

But, you will need to use the criteria in cells that are not affected by the filter, I mean you will need to shift the table down starting from A10 for example and put your criteria range in A3:C7 for example
This way you can see the filter settings and the filtered range

VBAXLMan is back to feed your Excel needs

Sunday 1/18/2009 7:31:54 AM
Sun
Jan 18
2009

What is the simplest way to extract text pattern in Excel spreadsheet?

I have a sheet of a few columns of URLs. I need to extract a text pattern (I.E. extracting an URL parameter) and then replace it with something else and place it into another link structure. What's the simplest way to do that in Microsoft Excel spreadsheet? Does Excel provide regular express?


Answer

Yes, sure
I do this all the time
Now, the link you have may look like this
http://www.file1.net/project.asp?id=89

If this link in cell A1, then paste this in B1
=LEFT(A1, SEARCH("?",A1)-1)

This will bring you the first part until the "?"

Then in another cell, say C1 type 5

Then in D1 paste this
=HYPERLINK( B1&"id="&C1, B1)

Now this link will have this result
http://www.file1.net/project.asp?id=5

So doing 6 in C2, 7 in C3, etc
Copy and paste D1 down to generate multiple hyperlinks to different locations based on your criteria

I did this as example, because you didn't give any details

try applying your criteria and see

VBAXLMan is here to feed your Excel needs in case you want more help

Sunday 1/18/2009 4:34:54 AM
Fri
Jan 16
2009

Excel - How to get the frequency of the words in a para?

The para contains 1000 words. I need to find out the the top 50 words appearing most often in the para together with the number of appearances only using excel commands - can't use VBA or any other s/w!

any help ??


Answer

The only way to do it is to convert that para into cells (For temporary)

Now, if you have that cell in A1, paste this in B1
=LEFT( A1,SEARCH( " ",A1)-1)
And this in C1
=LEN( B1)
And this in D1
=COUNTIF( B:B,B1)
And this in B2
=MID( $A$1,SUM( $C$1:C1)+2,SEARCH( " ",$A$1,SUM( C1:C1)))
and copy C1 to C2, D1 to D2

Now copy cells B2, C2 and D2 down until you find all the text you have in that para in the cells of column B

Now, the D column will give you the number of any corresponding text found in cell A1

The interesting thing, is that when you change cell A1, all of these will be changed automatically


Enjoy it, Yes, I know I am good at this, I am the VBAXLMan here

Friday 1/16/2009 6:13:55 PM
Fri
Jan 16
2009

2 questions regarding memory stick and excel file?

1.I put memory stick in pc and work on some files. Now, when I want to save some typing I did on a file in a folder on the memory stick and go to save, pc box says" Cannot open the ..... 3 reasons. One reason is a file with that name is already open." I have to close file without saving revision.

2. I exit computer and then later turn on and click on drive with memory stick plugged in and it cannot access the files I previously saw when I double clicked on K-file. Blank screen where previously the screen showed the files I was typing in.


Answer

Sounds like a virus to me

Make sure you have a good antivirus

Besides that
The best way to edit files from USB drive, is to copy it to a fixed drive

Sometimes Windows disconnect the USB drive and that will delete the connection between the application and the file opened

VBAXLMan

Friday 1/16/2009 11:31:51 AM
Fri
Jan 16
2009

Is it possible to add a calendar alert to Excel spreadsheet?

I've created a Excel '07 spreadsheet as a calendar. Is it possible to insert pop-up alerts/reminders in the spreadsheet?


Answer

Yes, using macros, for example:

Put this code in the Workbook module in the VBA (ALT+F11)
Private Sub Workbook_Open()
Application.OnTime Worksheets( "Sheet1").Range( "A1").Value, AlertSub
End Sub

And put this in a new Module after you insert it

Sub AlertSub()
MSGBOX "Alert", VBOkOnly
End Sub

Assuming you have the cell A1 in Sheet1 having the time that you want to alert in

Close the Excel file, and reopen it again with macros enabled, then it is done

VBAXLMan is back to feed your Excel needs

Friday 1/16/2009 9:14:43 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
Fri
Jan 16
2009

I need excel spreadsheet help for my new company?

I'm starting a company based on commission only. I need an equation for excel in which I can input a $$ amount sold and have it auto read the different pay scales and generate their income. in $$s and on a line graph. The pay scale is as follows:

$612 to $1223 is 6%
$1224 to $2447 is 12%
$2448 to $4895 is 24%
$4895 to $ 8499 is 26%
and $8500+ is 27.5%

Thanks!


Answer

Do this pay scale in a separate sheet, make it Sheet1 cells A2:C6 having A2 is 612, B2 1223, C2 6%
and so on
Now, in another sheet, put your amount in cell D4, and in E4 paste this:

=INDEX( Sheet1!C2:C6,MATCH( D4,Sheet1!A2:A6,1))

and this in F4
=D4*E4

That is all

VBAXLMan is back to feed your Excel needs

Friday 1/16/2009 12:14:18 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
Mon
Jan 12
2009

Can i back calculate a formula using excel?

I have a polynomial function here that i known of the y values and want to derive the corresponding x values. Anyone knows how to do it??

y=-0.0969X^4+342.16X^3-452972X^2+3*10^…


Answer

Your formula is cut

Try to insert spaces between it, Yahoo! Answers cut the rest of it

VBAXLMan

Monday 1/12/2009 12:12:20 AM
Thu
Jan 18
2007

How do you conditional format a hyperlink in excel?

trying to hide links where data doesnt exist yet with white font


Answer

You will need to use HYPERLINK function, (Not Insert Hyperlink)
along with IF function.
It is somthing like that
=IF( A1=1, "", HYPERLINK( "destination"))
So when cell A1 equals 1, then this cell will show nothing, but when A1 equals anything but 1, this cell will show the hyperlink you specify

Enjoy my profile, I am the VBAXLMan

Thursday 1/18/2007 7:59:31 AM
Mon
Jan 8
2007

How can I??.....?

I'm creating a calendar on excel ...how would it be possible to add a background picture to the calendar? .....how do i do it step by step? can anyone please help me??


Answer

You can
1- Put the picture as in (Format > Sheet > Background) and then remove the gridlines from (Tools > Options > Show gridlines)
2- Make the calendar itself as a picture using the camera option in Excel. (You will need to mail me for this help file, I can't attach files here)

In all of these ways, you can use my calendar that I would be proud to give freely, it works for all years all months

take it from the free applications section here
http://shiekhali.com/anmar/projects

Enjoy my profile, I am the VBAXLMan

Monday 1/8/2007 12:55:55 AM
Wed
Dec 20
2006

Is ther any way to install a .wba file which is a windows blind file.It is a neet desktop theme?

I downloaded it not knowing it was a .wba file.I want to install it but apparently this is a windows blinds extension.I dont plan on buying windows blind to install the theme is there any free way. Other wise I will try to find a free one somewhere.Its reaaly neet though.
Thanks for all help


Answer

I don't think there is away to see the file only by installing the software
check the website, they can give you a try version

VBAXLMan

Wednesday 12/20/2006 9:39:46 AM
Wed
Dec 20
2006

I have data in a column in an Excel spreadsheet and I need to use it in formulae in a row on another sheet.?

I don't want to have to type the formula over and over for each cell! Is this possible? Using the '$' sign doesn't work...


Answer

You can use
1- The Copy + Paste Special (Transpose)
2- Use the COLUMN(), ADDRESS functions like this:
Your source column is in D in Sheet1, you want it in row 5 in sheet2, so in cell A5 in sheet2 paste this
=INDIRECT( "Sheet1!D"& COLUMN())
the function in cell A5 will call the value in cell D1 in sheet1 and so on.
You can change the sheet name of the source column by changing Sheet1 in the formula.
If you are not starting from D1, or you want the row to start from other than A5 then add the -1, +1 after the COLUMN() to modify it

3- Use the TRANSPOSE function

I think this will answer you

Enjoy my profile, I am the VBAXLMan

Wednesday 12/20/2006 4:36:07 AM
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
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
Mon
Dec 18
2006

I have added new users to Windows XP. In each of these new accounts the Firefox addons have disappeared.?

Recently I have added new user accounts to Windows XP. Since then I have been experiencing numerous problems regarding the use of Mozilla Firefox. All bookmarks, add-ons and customizations have disappeared completely. I've solved the bookmarks problem by importing my old bookmarks list into my new account. In addition customizing Firefox to back my likings was a breeze. However the problem of the missing add-ons remains. I've painstakingly been searching Google for the missing add-ons are re-downloading them one by one.

This brings me to my question. Is there a way to copy Firefox add-ons from one XP account to another? Can I somehow copy add-on files from their location in one users account to another? If such a feat were possible it would save immense quantity of time and reduce my download usage. Help is much appreciated.


Answer

Who said copying addons files will copy the addons itself.
If you are sure of that, you can do this:
1- Open the Documents and settings, you will see a folder for each of the users
2- Open the main user (The one that was active when you installed the addons), then go to Application Data folder
3- search in there for the firefox addons files (It should be there in the folder named "firefox" or something like that)
4- If you found nothing there, try the folder "Local Settings" then "Application Data"
5- Copy it into the exact place in all of the users folders
6- restart computer and try again

I still can not think that copying these files will enable them into firefox, any way, you can try

VBAXLMan

Monday 12/18/2006 10:56:14 PM
Mon
Dec 18
2006

Where do i download the Vista Theme for my computer..?


Answer

Get it here
http://www.astahost.com/vista-theme-t955…

good luck

Monday 12/18/2006 5:55:20 PM
Sun
Dec 17
2006

How can I compress a MPEG video clip? The current clip is too large to attach and send by e-mail.?


Answer

MPEGs files are already compressed, even if you zip them
You can only control the resolution (bit rate) by reducing it to fit the size you want.
Try one of editing video applications on download.com

VBAXLMan

Sunday 12/17/2006 4:30:20 PM
Sun
Dec 17
2006

MS Excel fomular for link sht?

=SUMIF(INDRECT(C$4&"!$A:$A"),$6,INDIRECT…
An expert told me to use the above fomular to link 3 work sht into one main sht for summary purpose. I can't contact him now.
Can anyone tell me :
1) How to COPY the data in the 3 work sht and use the above fomular to pPASTE it on the main sht.
2) please explain the meaning of the fomular in layman term.

Thank you very much for help.

WT Tan


Answer

Hello my friend, it is me who send you the formula.
Now what is the problem?

mail me

VBAXLMan

Sunday 12/17/2006 10:04:44 AM
Sun
Dec 17
2006

How Can I Do This, And Were Can I download The Program To DO IT.?

I want to make this figure looke like if it were really fighting. Its from a cartoon, so i just want it too look like if two characters from diffrent cartoons were really fighting each other, also i need to know how to erase a background so only the figure from the cartoon character will be left. PLEASE HELP..


Answer

There are alot of video editing software out there, try Premiere from Adobe, I think it is good

VBAXLMan

Sunday 12/17/2006 9:07:28 AM
Tue
Dec 12
2006

This is regarding Concatenate function in Excel:?

I am trying to concatenate a Currency value ( $ 233,456,389) with a

percentage ( 74 %) in Excel using this function :


=CONCATENATE("$ ", TRUNC(B313)," @ ",TRUNC(C314)," % ")



I would like to have it as $ 233,456,389 @ 74%

Instread I am getting $ 233456389 @ 74% (currency value without commas)

Can someone help me in getting the commas in the currency display ?


Answer

Add this to the TRUNC function
TEXT(B313 ,"###,###")
Means the TRUNC would be
TRUNC(TEXT( B313, "###,###"))
and your final function will be

=CONCATENATE("$ ", TRUNC(TEXT( B313, "###,###"))," @ ",TRUNC(C314)," % ")

Enjoy my profile, I am the VBAXLMan

Tuesday 12/12/2006 11:03:16 PM
Mon
Dec 4
2006

An Excel search question?

I am trying to make an excel worksheet simply count the number of each persons names in a, say 10x10 grid randomly filled with names. Can it be done? And how!? I just want a list underneath of, for example "John - 10; Dave - 3; Kim - 28" depending on how many boxes each person's name appears in. I have tried DCOUNT but probably incorrectly, as it brought back totally random figures that dont make sense. Please help!!


Answer

You will need COUNTIF
it goes like this
=COUNTIF( A1:F10, "*John*")
I recommand using * to allow finding the cell with John, and cell with John - 10

Enjoy my profile, I am the VBAXLMan

Monday 12/4/2006 12:50:00 PM
Mon
Jul 17
2006

My rogers goes through Internet explorer I do not want it to go that way I want the rogers browser?

Can you tell me how to change to the rogers browser?


Answer

go to Control Panel > Add or remove programs > Set program access and defaults
and change the Internet browser to what you want

note: you must have rogers browser installed before you do that

XLMan

Monday 7/17/2006 3:53:30 PM
Sun
Jul 16
2006

How do i connect my phone to my pc using bluetooth?

I have a nokia 6111[with bluetooth, which i activated] and i have downloaded the nokia pc suite, but when i try to connect the phone to my pc[compaq armada m 700] it doesn't work. It says something about drivers etc. , but it doesn't specifay what. What should i download? I mean exactly, and from where ? Please, somebody!!!


Answer

If you are sure that you have a bluetooth device on your armada, you need to download the driver for it, go to http://www.dell.com and download any bluetooth driver you found there on your computer section and run it, then, you should see "My bluetooth places" in My computer means that your driver is ok.
then, enable your bluetooth, by Fn plus a key in your computer, and here you go.

good luck

Sunday 7/16/2006 5:02:25 AM
Sun
Jun 11
2006

What hardware do i need to transfer all my vhs to dvd?

i have a pc but am thinking of buying a mac. this is one thing i want to be able to do. any suggestions?


Answer

I am using a VHS video recorder connected to a PCI TV-Tuner and a proper software, with DVD-RW and you can go

XLMan

Sunday 6/11/2006 6:14:04 AM
Sun
Jun 11
2006

The 'folder options' are gone from tools menu! any help to return this?

not only 'folder options' were missing but about 4 other choices under tools menu are missing after my laptop was infected by a virus.. i succesfully removed all viruses but the missing options are still gone.. i tried opening it from control panel but it was missing there too.. i tried 'view>costumize then add the folder options.. the icon appeared but nothing happens when i click it.. i cant open my hidden files anymore!!


Answer

I sow this happened several times to computers with viruses, I think you need to reinstall windows over the old one.

About hidden files, you still can open it using the program you created it with. just type the name in the dialog and you go.

Hidden folders still can be viewed if you type in the name to the right of the address bar after "\"

XLMan

Sunday 6/11/2006 6:10:28 AM
Mon
Apr 24
2006

What is the best color laser printer so far?

good quality, good printing with real-colors. Value-for money type printer


Answer

I am using Epson laser color printer in the office (I don't remember the model).

But in Home use I prefer Canon, it is more officiant

Monday 4/24/2006 1:06:44 AM
Mon
Apr 24
2006

Mr rocktowatsreal how can I contact you as you mail is not going?

i tried to send you a reply but your mail address does not get confirmed


Answer

Try to ask another question which may interest him, he will answer

Monday 4/24/2006 12:51:24 AM
Sun
Apr 23
2006

Sprint scp 8100 driver?


Answer

Check the manufacteror site, or the site below, it has alot of device drivers http://www.driverguide.com

Sunday 4/23/2006 6:39:39 PM
Sun
Apr 23
2006

Anyone know where I can find a free laptop battery monitor that displays the time remaining on the battery?


Answer

Your laptop comes with CD, it has the necessary software for that.
If you could not find it there, try the manufacteror website.
If you still want more try the link below. http://www.download.com
http://www.programfiles.com

Sunday 4/23/2006 3:00:50 PM
Sat
Apr 22
2006

How do i set up hotkeys on my Sony Vaio PVCA-KB1P/UB keyboard?


Answer

You need to install the software for it, check the CD comes with the keyboard.

OR

Check Sony website for support and download keyboard driver and software

Saturday 4/22/2006 3:06:35 PM
Sat
Apr 22
2006

I can get emails but i can't move them or send never happen before?


Answer

Hmmmm
I think you have virus (I am not quite sure), but let us try the following first.
1- Clear history and cookies
2- Delete temporary internet files
Both 1 and 2 are in Internet options from Control panel
3- Restart computer and try again
4- Mark me as best answer if the problem goes with the wind
5- otherwize I suggest install and run a good anti virus.

Saturday 4/22/2006 1:31:48 PM
Sat
Apr 22
2006

Getting xp boot cd to format?

i am having problems with my XP cd.. half way through the setup the storm turned my comp off.. now i cant boot up using my cd because it was a copied version and i have to be logged in to be able to install it.. is there a way i could use a install cd that booted up and installed. i already have my bootlist having cd boot frist... anything i can download?


Answer

If you are formatting, you don't need to log in.
All you need is to boot from CD and - following instructions of WinXP setup - install new windows.

But If you are upgrading, installing WinXP from WinXP, I am afraid you need to format it.

There are alot of tools to download, but all will not fix your program, they will recommand you to format.

Good luck

Saturday 4/22/2006 1:08:40 PM
Sat
Apr 22
2006

Animation shop 3?

downloadable animation shop 3 links please..probably you can give not only from jasc others are accepted as well..as long as their downloadable


Answer

try http://www.download.com

Saturday 4/22/2006 5:12:43 AM
Sat
Apr 22
2006

Dell Latitude D600 Laptop USB problem.?

Hello, I have Dell Latitude D600 laptop and have a problem with it.

USB devices aren't working propertly when charger is plugged in and rarely when it is unplugged. For example my USB mouse can move around 10-15 seconds, then stop for 2 or 3 sec and cursor continue moving. If I run Windows I hear sound notification that device is disconnected and sound notification that device is connected after 2-3 seconds again.

It is not looking like Windows problem, because I have same issue under Linux.

Thanks. Any advice appreciated.


Answer

Did you installed all device drivers?
If you didn't you should do that first, including BIOS update from Dell company site.
Second: does only the mouse making that problem? or is it any USB device? so you can tell if it is the mouse problem or not.
Third: Do you have any other USB devices connected to the computer at that time, there may be a conflict in the USB.
Forth: Try to use other USB port.
Fifth: Mark me as best answer if this helped you
Sixth: If all these couldn't help you I suggest reinstall Windows.
Seventh: If it is still the same, just put your computer below one of your cars tyres, I am sure this will help.

Thanks

Saturday 4/22/2006 4:53:03 AM
Sat
Apr 22
2006

Why internet explorer not functioning as good as before? always making errors on page and then it hangs me up?

for instance, after i install the yahoo messenger the problem of hanging began..just simply hanging. So did the IE, it annoys me coz the time when im in a hurry for a topic then it was also when the explorer hangs me..how this be settled?


Answer

1- Clear history ans cookies.
2- Delete temporary internet files
3- restart computer
4- mark me as best answer cn2572@yahoo.com

Saturday 4/22/2006 4:44:19 AM
Sat
Apr 22
2006

My pc is showing error no ntld it keeps crashing every time i try to format it its a 1100 proceser windows xp?


Answer

You need a bootable disk, try the WinXP bootable disk then install from it.

Otherwize...

Check your memory (RAM)

Saturday 4/22/2006 3:23:32 AM
Tue
Apr 18
2006

I have a IBM Infoprint Color 8 printer. Im using Window XP. So the Printer will not work.?


Answer

If you have the driver for it, it will work.

Tuesday 4/18/2006 7:29:01 PM
Fri
Apr 7
2006

How the process of retrieving data once it is deleted from computer works??


Answer

The deleting does not occur on the files body.
It wipes out the first letter of the file name only, then mark the file body as free (Does not empty it) to be used when needed.
That is why SOMETIMES we can Undelete, and SOMETIMES we can not.

And that is why you need a software to WIPE a file to ensure that you deleted it.

Friday 4/7/2006 4:56:37 AM
Fri
Apr 7
2006

What's a Sub Module?


Answer

I know Sub Module as a programming sub, Sub is a subroutine to write down the commands in, and Sub Module is a container of differant Subs.

That is what I know about it.

Friday 4/7/2006 4:46:50 AM
Fri
Apr 7
2006

Free Softwarre to Restore my Notebook Hardisk?

Hello please help if u can
My Notebook was stolen and recently found by the Police Authorities - YES the system was ok but all the hard disk contents had been formatted.

Now - I do a lot of Database development on DBF which I had planned to convert to Alpha 5 - but the way it is now i do not know how to go about it considering the fact that all my data are locked up in the formatted hard Disk


Can anyone give me a software that will enable me unformat my hard disk? I have tried on the NET but all the ones i got could not handle 80GB on NTFS - and besides - they all asked for money

Please if u have a software that works - do me a kind favour and forward same to this email address - I will show my appreciation please

My email addresses are (1) johnsonokunade@gmail.com and (2) firstjos@yahoo.com

In addition - i am available on Yahoo Messenger for chat on firstjos - thanks a lot


Answer

Try Download.com to download FinalData2.
This one is powerfull, I used it myself to recover my 160GB NTFS partitions and files.

I will send you the key by mail if you want

Belive me it worth every penny. http://www.download.com

Friday 4/7/2006 2:17:34 AM
Fri
Apr 7
2006

How do i install iSO games?


Answer

Also there is WinISO will help. Meee

Friday 4/7/2006 1:49:41 AM
Fri
Apr 7
2006

Some very important videos & music clips got deleted from my hard disk shift+deleted how do i get them back???

i heard that we can get them back using the net.plz plz tell me some way to get them back coz they r very important.


Answer

There is a good software named FinalData2, I had your exact problem (I had 160 GB full of files and lost it in reformat, but this one bring all my files back).
Belive me it worth to try, You will need to buy it or get the crack from the crack sites (if you want), It is available in Download.com Download.com

Friday 4/7/2006 12:34:56 AM
Thu
Apr 6
2006

My printer cuts 1/4 inch of my printouts vertically, how do I fix it?


Answer

I need more info
Are u using Word or which application?

In that application go to paper size and make sure it is the proper size.

Thursday 4/6/2006 6:27:06 PM
Thu
Apr 6
2006

This is really starting to chafe my willy. When I try to open Limewire, it blinks, then dosnt work. Help?

Lime wire was working just fine and dandy before. But when my system restore program on my Windows PC reset... it dosn't work. It will just blink like one ur' two times, then nothing happens. If someone could help me out here, that would rock, thanx.


Answer

1- Remove it from your computer.
2- Your songs are saved, don't worry
3- Install JAVA (see links below)
4- restart your computer
5- Install the latest version of LimeWire again (see links below)

And enjoy again http://www.java.com/en/download/
http://www.limewire.com

Thursday 4/6/2006 3:15:26 PM
Thu
Apr 6
2006

Is there software like audiograbber for videos where I can start and stop recording part of a clip that i want

in audiograbber you insert the song you want from a cd and then select wether you want the whole song to be recorder or part if you want a part you specify the time or play the songa and prees a button and the time shows up so my question is is there such a program for video????


Answer

You should see the VCDCutter 4.0, it is fantastic, it can do all you need in just minutes, I still use version 4.0 although it is old, well i don't need to upgrade this one looks like made specially for me.

Try it, it is worth it. u can get fastcap at: http://www.ejoystudio.com

Thursday 4/6/2006 1:27:44 PM
Mon
Apr 3
2006

Accidently removed yahoo mail quick select tool..how to re-install?

cannot compose or send mail at this time


Answer

Where was this too?
Was it in the messanger? or in your Yahoo toolbar?

I must know.

Monday 4/3/2006 2:52:39 PM
Mon
Apr 3
2006

How do you save a copy of windows registry onto a cd?


Answer

1- Open Windows registry editor (Start Menu > Run > type regedit > Enter)
2- go to File > Export > Select file and place > make sure you select "All" check box in Export range
3- Burn this file to CD.

Registry is changing always, so sometimes the importing registry may make problems.

Monday 4/3/2006 1:02:25 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
Sun
Apr 2
2006

What type of file is a DEOD file?? ie 1-28-2865.deod ; found in my TEMP folder on WindowsXP system?


Answer

You will find alot of files there, Alot of applications are making alot of temperary files in this folder.
They should be delete, so do.
If you could not, it mean it still open, leave it

You can delete all files in this folder.

I am doing that daily.

Sunday 4/2/2006 6:32:27 AM
Sat
Apr 1
2006

How do you burn programs onto dvd disks?

How do you burn programs onto dvd disks? And what is the the most memory a dvd can hold?


Answer

If you have a DVD burner, You can easily write any thing on it either using it's own program (Install it from the attached CDs) or using Windows by just Copy-and-Paste the files into the Cd then select "Write these files to cd" from the File menu.




The most DVD type can hold up to 4.5 GB of memory, Double layer DVDs can hold up to 8.5 GB, the new Ultra DVD can hold up to 17 GB of memory.
You must make sure the your burner support the technology of the DVD blank you are writing in.

Saturday 4/1/2006 7:30:08 PM
Fri
Mar 31
2006

My photoshop 7 is freezing on it's start up. It says searching for plug in's picture package.. Help me get in.

It seems to be seaching for an unavailable plug in and freezing. I uninstalled and reinsatalled it. I can't get it open. It was working fine. Any ideas how to by pass seaching for that plug in. Thanks


Answer

Check if there are plug-ins in the CD that hold the application, check in the readme file if you need to install plug ins before installing Photoshop.

And make sure you have a geniune copy of it.

Friday 3/31/2006 9:34:57 PM
Fri
Mar 31
2006

How do I fix video playback on my computer?

Any time I play video on my computer the image gradually becomes green, regardless of the program I use.


Answer

It seams to me that your SVGA card (Graphic card) problem. Try to reinstall the driver for it, If it still the same I am afraid that your Graphic card is damaged and need to be replaced.

Friday 3/31/2006 11:38:14 AM
Fri
Mar 31
2006

Why does photo gallery keep trying to set up on my computer?


Answer

Becuase you didn't finish it in first time, or the setup application was terminated unexpectedly.
try to set it up again and finish it this time, then remove it from the control panel.
This is the easiest way.
OR
Get one of those registry program that enables you to access the startup fields to remove the one that runs the setup.

Friday 3/31/2006 10:30:23 AM
Wed
Mar 29
2006

Why wont my Limewire open?

Ok Limewire was working fine until i tried to download counterstrike. After that i gave up becuase i couldnt get it to work. When i tried to open BF2 nothing happened except it froze loading the black screen. It kept doing this counteuiously. I performed a system restore and everything was going fine.. except limewire kept popping up every 10 seconds and my ctrl alt delete wouldnt work. I restored again and got everything working fine. Later when I tried to start Limewire it wouldnt come up and all i got was the little hourglass for a split second like it was going to load it but it cant. I really need my music!!!! I have tried uninstalling and installing but that didnt work. BTW I did a spybot scan and found viruses so I killed them. I also tried undoing those viruses to see if it would work then, but it still didnt so i killed them again. PLZ HELP!!!!


Answer

I don't think you can solve this problem without installing antivirus software, And As it mentioned get ready to format and reinstall Windows because will see a brand new creative problem every day.
BUT you still can get your music by copying the files in C:\Program files\Limewire this is the place where it usually saved your music, Unlless you change it.

Wednesday 3/29/2006 7:36:45 PM
Tue
Mar 28
2006

Epson stylus cx4600 installation?

ok we had some probs with our comp and a virus wiped us out, i have lost the installation cd for my printer, is there a site i can go to, to download a driver for this specific printer/scanner? well actually the printer works just the scanner doesnt? i need a site to go to for the scanner... thanks!


Answer

Did you tried Epson.com, don't tell me you didn't.
Ok If you already did and searched for this printer/scanner in the database. I think you still can search for it on one of the drivers' sites (like Driverguide.com), Actually this is one of the biggest I have seen in Drivers database.

Good Luck

Tuesday 3/28/2006 5:34:14 PM
Sat
Mar 25
2006

Where can I find the Smartsound Quicktracks plugin.msi file for download?

the plugin is to be used by FakeWebcam


Answer

You can search for it by typing
"Smartsound Quicktracks plugin.msi" exactly in Google or Yahoo.

Good Luck

Saturday 3/25/2006 3:18:48 PM

Tags

History