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

85 Q & A posts found in year 2006

Wed
Dec 20
2006

Matching with Ms Excel?

I have a spreadsheet which contains 5-6 columns of info, with about 200-300 rows. Column D contains totals. Some of the totals in column D will match with one another, just with a minus sign. Say if there is a 54300, then there is another -54300, just its with a minus sign (this is actually a ballance of a clearing account).
What I want is to write a formula or macro that would take column D value from the first row, search through all column D, find matching value, cut those two rows and paste in another sheet within the same file. Then repeat this with all the rows, cutting rows with matching value in column D, so that all the matching values are pasted one below another in another sheet. This way the original sheet will only contain unmatched items.
I work as an accountant so have to go through account statements like that very frequently. Having a formula or a macro like that would make my life a lot easier :)

Thanks for any responses!

Happy Xmas!


Answer

You can solve it in one of these ways
1- Formula
2- Macro
I can post here the formula solution, because it is easier to understand.
Now, leave column E as seperator, go to F2 and paste this
=ABS( D2)
and fill it down to all the other cells. In G2, paste this
=LARGE( F:F, ROW()-1)
And fill the G2 down to all the cells below
Hay, it is your exact list, but sorted in Descending order

Yes
That is because VBAXLMan show you how to do it

You can cut and paste this G column cells to what ever you want

Enjoy it and..

Enjoy my profile, I am the VBAXLMan

Wednesday 12/20/2006 5:36:13 PM
Wed
Dec 20
2006

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

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


Answer

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

VBAXLMan

Wednesday 12/20/2006 1:17:03 PM
Wed
Dec 20
2006

I have a problem in writing Excel formula?

Hi guys,

I have a problem in writing an excel formula .. IT looks very simple.. I wanna say that if the value in a specific cell is less than 1000, add 30 ..

I have tried =if(K5<1000,"30").. it never work


Answer

Yes do it like this

=IF( A1<1000, A1 + 30, A1)
This will add 30 to the cell in A1 if it is less than 1000 and bring the origin cell value if not

Enjoy my profile, I am the VBAXLMan

Wednesday 12/20/2006 10:11:54 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

The little icons beside the inbox etc. in yahoo mail are missing?

again after formating c drive and reinstalling xp.. when I log onto my mail in yahoo and my homepage in yahoo the small icons beside the text do not display.
what is the problem?
installed java


Answer

Make sure of these:
1- Enabling graphics in Tools > Internet Options > Advanced
2- Clear History
3- cookies are enabled
4- Clear cookies


VBAXLMan

Monday 12/18/2006 9:17:44 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
Mon
Dec 18
2006

Firefox 2.0 wine installation problem?

I am trying to upgrade to Firefox 2.0 on my openSUSE 10.2 and when I launch the installer, it comes to the page where you select where you want to install the files and it doesnt matter where I select, it always gives me "You don't have sufficient disk space to install in this location, Please click ok to select another"


Answer

This message comes up when you are trying to install in a full hard drive.
Make sure that your C drive (Or wherever you are installing in) is not full and have the space in the program recommandation
Try install in another hard drive.
If you have only one, then clear some data from it then try again

Enjoy my profile, I am the VBAXLMan

Monday 12/18/2006 12:14:17 PM
Sun
Dec 17
2006

Is there any formula to convert numbers to words in "Excel Program" other than Add-ins. Pls answer me.


Answer

Microsoft do have a function like this, it is a macro, so you may need to copy it first to your VBE module window

Check this out
http://www.ozgrid.com/VBA/CurrencyToWord…

Enjoy my profile, I am the VBAXLMan

Sunday 12/17/2006 9:43:26 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
Sun
Dec 17
2006

How to convert web files in excel?

or how to covert txt file from dos to excel


Answer

Excel can read *.csv files
So just make your list a comma seperated list, like
V1,V2,F4,450
and so on, then
open the file in Excel, and it is all here in a sible sheet

Enjoy my profile, I am the VBAXLMan

Sunday 12/17/2006 5:12:24 AM
Sat
Dec 16
2006

Hey, Excel users?

What has happened to my Excel file?
I suddenly can't enter any data. The damned cursor moves where ever it wants to and won't accept an entry in the selected cell.
No idea what question to ask in Excel Help.

Thanks.


Answer

Mske sure that
1- Your sheet is not protected against changing (See Tools > Protection > Protect worksheet)
2- You are not openning a shared file that is already opened by someone else
3- You are not openening a file that is accedently closed
4- Copy the file in another folder with another name and try again
5- You don't have a virus in that particular file

mail me for any details here

Enjoy my profile, I am the VBAXLMan

Saturday 12/16/2006 10:01:52 PM
Sat
Dec 16
2006

Where can I find an excel spreadsheet of question and answers?

I am looking for question and answers for students for basic tests and exams for things like chemistry, geology, science. Just basic stuff like:
What is oxygen? An element that makes up our atmosphere.

I have many text files of info but they are taking for ever to manually copy/ paste into Excel (which is what my test creation program imports from).


Answer

I made somthing like this (Based on text files database) that will read these files and make the 10 questions with the 3 random ordered choices in VBA of Powerpoint, check this link
http://shiekhali.com/anmar/projects.html
and go down until the "Ayad Project" in 2002 and see the screenshots for it.

It is VBA in PowerPoint that will calculate the result of points, I can mail it to you and show you how to customize it if you are interesting, mail me here in Y! Answers


Enjoy my profile, I am the VBAXLMan

Saturday 12/16/2006 11:47:30 AM
Thu
Dec 14
2006

How do I get file attributes such as picture size type etc into an excel database using Visual Basic 6.0?

I'm making and index of my CD's in Excel and Everytime I get a new CD I need to right click and get the properties and copy them in excel. Thats why I want to make an application in VB which will do the job for me.


Answer

I would rather do the program in VBA of Excel, it is close to plain VB, besides you don't need a setup, just open the Excel file and run the macro (VBA subroutine)
Now the answer is using a special DLL to get the picture properties, there are alot of libraries sites out there in the net like:
vbaccelerator.com
a1vbcode.com
and much much more, i don't remeber all now.
If you got the declerations part, you can easily use it in the VBA of Excel

mail me for more info, i would be glad to help

Enjoy my profile, I am the VBAXLMan

Thursday 12/14/2006 4:45:18 PM
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
Tue
Dec 12
2006

In the Excel Sheet(Microsoft Excel),I am not getting the 'FILE'option in the menu bar.How can i restore it?.

The excel sheet is starting with 'EDIT' from the left side.


Answer

The easy way is as follow:
- Go to View > Toolbars > Customize
- in that window make sure you are in the tab that named "Toolbars"
- Select "Worksheet Menu Bar" which is the last one in that list of toolbars
- Now press the "Reset" at the right
- Enjoy it

Enjoy my profile, I am the VBAXLMan

Tuesday 12/12/2006 1:10:19 PM
Tue
Dec 12
2006

I am not able to tick the 'chart menu bar' in ('tools'-'customise')Excel sheet.How it is possible?

This is to bring back the 'file' option in menu in Excel Sheet.Presently it is not displayed.Display starts from 'EDIT'


Answer

I answered you,
Check the answer for this question in this link
http://answers.yahoo.com/question/index?…

Enjot mt profile, I am the VBAXLMan

Tuesday 12/12/2006 5:47:50 AM
Wed
Dec 6
2006

Excel Macros help!!?

If you have the following macro:

Sub CleanupGridReport_1()
'
' CleanupGridReport_1 Macro
' Macro recorded 12/6/2006 by me
'
'
Sheets("GridReport_1").Select
Range("V22:V29,Y22:Y29,a33:d33D32").Sele…
Selection.ClearContents
Range("I32").Select

End Sub

Can someone tell me what are the steps I have to follow, starting from >>

Sheets("Grid_Report_1")

So, I start the macro, then what do I do?


Answer

Line 1: Sheets("GridReport_1").Select
Is going to select the sheet names GridReport_1
Line 2: Range("V22:V29,Y22:Y29,a33:d33...
Is to select these ranges of cells at the same time (Highlight them)
Line 3: Selection.ClearContents
Will clears the content of the selection (Contents means only whats inside the cell, not Formats or commints
Line 4: Range("I32").Select
Selects the cell I32

Thats it

good luck

Enjoy my profile, I am the VBAXLMan

Wednesday 12/6/2006 11:43:29 AM
Tue
Dec 5
2006

Hey! is there any Excel expert who can solve this.....? are u here Mr VBAXLMAN..?.?

i would like to create a line chart in ms excel....where "runs" will be ploted in y axis, or vertical axis and "overs" in horizontal axis....
runs will ploted in 50 runs interval and overs will be in 10 overs interval....u might have seen this in cricket...
wait .....it's not so easy one....i've a few conditions
1) the resultant line will be displayed in a single line,,,,i repeat ..in a single line....as u would have noticed in cricket score analysis.
2)it will start from the (0,0) point...that means 0 run at 0 over...
and will travel with the increasing runs and respected overs...(as it is made in graph papers.)
3)i'm using msexcel 2002....so pls solve it in 2002 or older....
i think i've expressed it enough....
if u 've done it then try this for two teams for there score analysis .....obviously there will two seperate line for two teams , say India & Pakistan or Australia & NewZealand...
every good answer will get a thumbs up and the best answer ......u know better


Answer

I got your e-mail.
The solution is all in the table that you will create for it
Wherever hard you think the chart is, the solution is in the table
Excel charts are created from tables, means that you can not (Never) create a chart without its data.
So we are (You and me) have to see how to build the table that will represent the chart

I can't e-mail you through Yahoo, you have not confirmed your e-mail there...
send me your e-mail address, I can not e-mail you

Enjoy my profile, I am the VBAXLMan

Tuesday 12/5/2006 2:10:13 PM
Tue
Dec 5
2006

How do you generate a PO number in an excel spreadsheet?

I have a purchase order form in excel that I want to automatically generate a purchase order number every time it is opened. Is this at all possible and if so how would I do it?


Answer

It is in macro (Did you heared of VBA?)
You will need to create the macro that will run at each start and adding new value to the old one.
It is something like this

Paste these lines in the ThisWorkbook object in your VBA window (Open excel, then press ALT+F11)

Private Sub Workbook_Open()
Starting
End Sub
Sub Starting()
Sheet1.Range("B1").Value = VAL(Sheet1.Range("B1").Value) +1
End Sub

Assuming that the cell B1 in sheet "Sheet1 is the cell with PO number

mail me for more info

Enjoy my profile, I am the VBAXLMan

Tuesday 12/5/2006 1:56:20 PM
Mon
Dec 4
2006

Excel Query: Closing Down the file you are in using a macro?

Hi,

Can anyone help?
I have an excel spreadsheet with various macro buttons attached. What I need is a piece of additional code where, once entered straight into vb, and one of the macro buttons is pressed, the file that they are in closes.

Thanks in advance


Answer

Closing Excel file has some details
1- Closing the file (the file that have the macro) is in this line
ThisWorkbook.Close TRUE
TRUE for saving file before close
2- Closing the Active file, the one that is selected in the Window menu is
ActiveWorkbook.Close TRUE
3- Closing Active window will not all times closes the file (You may have two windows for the same file) it is like this
ActiveWindow.Close
4- Closing Excel is another issue, you will need to save all opened file to let Excel close without asking for saving files:
- If you have one file opened, save it then exit Excel, like this
ThisWorkbook.Save
Application.Quit
- It you have more than one file opened, then you can make a loop to save all opened files, like this
For i= Workbooks.Count to 1 step -1
Workbooks( i ).save
Next i
Application.Quit

I think this will solve your issue

Enjoy my profile, I am the VBAXLMan

Monday 12/4/2006 1:03:15 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
Sun
Dec 3
2006

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

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


Answer

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

mail me here for it

Enjoy my profile, I am the VBAXLMan

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

How to find the largest non-empty row of an Excel column with VBA code?


Answer

I guess you mean the largest value in a range of cells, right?

If so, then you can do one of the following:
1- Use another cell with the function of
=Max( B:B)
then call that cell using the object [Range]
MaximumValue = Range("A1").Value

2- Use the powerfull feature WorksheetFunction that will enables you to use some of Excel built-in functions in VBA, example:
MaximumValue = WorksheetFunction.Max( "Sheet1$B:$B")

Or...
You may want to find which row have the largest no of non-empty cells.
If so, then you will need som fomrula combination, I will need you to mail me here if you are looking for that in particular.
I also will need you to answer some questions like (Do these rows are one after one? means they don't have empty rows in between?)



mail me here for any further info

Enjoy my profile, I am the VBAXLMan

Sunday 12/3/2006 3:19:22 AM
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
Thu
May 11
2006

What software can you get thats free and that you can upload videos and burn them onto a VCD format?

?HELP?


Answer

limewire from limewire.com

XLMan

Thursday 5/11/2006 5:11:38 PM
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

When i am in yahoo chat ,in a pm,why cant they see my display pic,n i cant see theirs,i have it enabled to see


Answer

Hmmmm
Let us try the following.
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

Sunday 4/23/2006 10:12:58 PM
Sun
Apr 23
2006

Which motherboard is better- intel 915 or intel D101ggc?


Answer

Intel 915

Sunday 4/23/2006 8:08:14 PM
Sun
Apr 23
2006

How do i recover files off of a harddrive when you try to open the folder and it says access denied?


Answer

You don't have the privileges to open this folder, you may have a guest user account.

You need to log in as administrator to open this folder

e-mail me your exact problem and mail address to solve this out.

Sunday 4/23/2006 7:44:38 PM
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

Where can I find the file WD H-4.mdb?


Answer

It is Microsoft Access database file, did you try to google it?

Just search for that full file name in Google or yahoo


Good luck

Sunday 4/23/2006 4:42:31 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
Sun
Apr 23
2006

Retrieve deleted pictures on compact flash CARD?


Answer

I have been in this problem with a guy here in Yahoo Answers, he could retrieve his 80GB hard disk (Check my best answers).
I don't think there is a differances in CF memory, any way e-mail me your address and mark me as best answer to go through the steps AGAIN.

Again, I am not quite sure if this will bring them back.

XLMan

Sunday 4/23/2006 1:38:54 PM
Sun
Apr 23
2006

Why isn't there a scroll bar for my aol mail?

i can't retrieve my email from aol for there is not a scroll bar.


Answer

Hmmmm
Let us try the following.
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- Check for antivirus, you need one

Sunday 4/23/2006 11:53:15 AM
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
Sat
Apr 22
2006

How do i work whit files txt files in visual basic , i need some functions?


Answer

I still use VB6 and open it as sequential file using

-Open [filename] for [open_method] as [file_no]
-line input #[file_no],[variable]
-print #[file_no],[variable]
-close #[file_no]

see MSDN for all these functions

Saturday 4/22/2006 3:21:09 AM
Tue
Apr 18
2006

Compaq notebook power problem? can i just simply change power without changing the whole motherboard?


Answer

Do you mean power supply or cable?

I need more info

Tuesday 4/18/2006 9:53:04 PM
Tue
Apr 18
2006

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


Answer

Copying move DVD is as easy as any type.

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

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

How do i send web-page like news letter of site in yahoo and hot mail mail in box ?


Answer

First, if you want to send as Whole page
you need to save the web-page on your computer.
1- Go to File > Save As > select where you want to save the web page > select "Web archive single file" in file type > Save.
2- Send this file as attachment in any web-based e-mail.

Second, if you want to send the page as link.
1- Go to File > Send > Shorcut to desktop
this will make a shortcut to that page on desktop.
2- Again attach tnis file and send

Enjoy

Tuesday 4/18/2006 8:49:03 PM
Tue
Apr 18
2006

I sometimes get e-mails from yahoo a day or two late, or sometimes later, does this happen to anyone else?

It doesn't happen every time or to the same sender. It just seems to happen at random. Big e-mail or small e-mail it doesn't matter.


Answer

It happened to me, I think because we are using free e-mail, And Yahoo have too many e-mails to deal with, so it have to proceed the paid accounts first, then the free ones.

Tuesday 4/18/2006 7:40:21 PM
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

Can anyone tell me a site which offers full version ppc softwares?


Answer

Try one of the links below

You can search for free or freeware in them.

I do have almost 50MB of free software just from these sites

And There are alot more. http://www.handango.com
http://www.freewareppc.com
http://www.pocketgear.com

Friday 4/7/2006 4:02: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

Where can I find the driver for this?

where can I find the driver for this?

Intel 82801DB ICH4 - AC'97 Audio Controller [B-0]


Answer

It seams to me it is built-in sound card, well may be the best way is to connect to the internet and let the Add Hardware wizard do the job for you.
Or
As anyone could say, go to one of the drivers sites, I recommand Driverguide.com www.driversguide.com

Thursday 4/6/2006 9:19:21 PM
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

256MB ATI MOBILITY™ RADEON® X1400 HyperMemory™?

System : Dell Inspiron E1505

I would like to know a list of all the games that can be played using this graphic card. Other laptop configuartions include: 1.66 intel duo core processor, 2 gb ram , 15.4 inch Wide Screen XGA Display with TrueLife™, dual layer Dvd burner, 120 gb (harddisk), Intel wi-fi card, XP media centre edition. Im gonna pay 1350$(inc tax). Is this a gud deal for a laptop ? is the Operating system gud. i would like suggetions.


Answer

It seams this one is multimedia laptop, I don't know games because i don't play them, but this one is good until the end of this year.

Expect new games will ask for a beter performance in the next 10 months

Monday 4/3/2006 2:19:43 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

Need a sapi disk for my sound on my computer. where do I find it?

Lost sound telling me to re-instaal sapi???????


Answer

It seams you need Sound Card driver.
What is your sound card brand and model?

Check the company website for it.
Or
Check Driverguide.com

Sunday 4/2/2006 8:25:39 AM
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

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

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


Answer

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

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

Saturday 4/1/2006 7:55:38 PM
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

I need a driver i81xnt5.sys?


Answer

When I Yahoo it I got these links, by the way what device is this for? If you put the manufacteror and the model I will lead you to the driver.

I had in throgh all these files, It seams to me a built-in VGA card, can you give me more info about hte main board I had alot of CDs of built-in VGA boards.

Friday 3/31/2006 11:27:13 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
Fri
Mar 31
2006

Looking for suppy of ASUS P4P800-X motherboard?

in Malaysia


Answer

I had the same one, What exactly do you want?

Driver CD?
or
Manual?
or
What?

Friday 3/31/2006 6:31:29 AM
Thu
Mar 30
2006

In excel,when I try to enter formula it is not applied on the cell.Pls suggest me?

Excel


Answer

Sometimes, Excel do autoformat to the result if one of the references are date or if the result can be converted to a date, so just go to Format--> Cells and make sure in the Number tab the Number value are selected from the list.

Thursday 3/30/2006 2:34:14 AM
Wed
Mar 29
2006

I don't know how to save my avatar properly. I click on save but it doesn't appear on my yahoo mail?


Answer

You must do the follwoing:
1- Close all sessions of Internet Explorer.
2- Right click on your Internet Explorer icon on descktop.
3- Choose Properties.
4- Click on "Clear history" and ok to all questions.
5- Click on "Delete Cockies" and ok to all questions.
6- Click on "Delete files" and ok to all questions.
7- Try to make your avator again.

Wednesday 3/29/2006 11:34:14 PM
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