ANmarS - Search results

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

We are moving ...

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

14 Q & A posts tagged with PO

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
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
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
Sat
May 8
2010

How do I get my PDA to scan bar codes into pocket excel while I'm scanning into another program?

I use a Dell Axim x5 with a scanner attached to scan the bar codes of books in order to find out their prices on the net. I would like to get a listing of each bar code scanned in pocket excel without having to scan each bar code twice.


Answer

Usually scan bar devices got the scanned bar info into one application
So you need to have any book scanned twice in order to make it in both applications

If you want it to read the bars into Excel only, then just open Excel, and start read the books

You might need to press enter after each read


VBAXLMan

Saturday 5/8/2010 11:00:50 AM
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
Mon
Apr 5
2010

Export/Save from Oracle to Excel Spreadsheet?

Im not getting the option to save to excel.

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

Many Thanks


Answer

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

Try it

VBAXLMan

Monday 4/5/2010 6:31:43 AM
Tue
Apr 21
2009

How do I import data into a program like excel through a virtual RS232 port?

I bought a scale and a USB interface kit, which connects the scale to the computer by using a generic interface based on the RS232 serial standard. According to the manual, data sent from the balance is in USB format, which is then directed to a virtual port. This port then appears as an RS232 port to the application program. It came with a cd with software to create the required virtual port, but I don't know how to get an application to connect to the port, or which application to use.


Answer

I am afraid this will depend on the application you have in that CD

What is the type of the files that that application can export to?

If it is a common one (I guess they must have a common one) then you can easily export ti to Excel

Common ones like
Tab delimited text (TXT)
Comma Separated Values (CSV)
etc


VBAXLMan

Tuesday 4/21/2009 3:56:31 PM
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
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
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

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

Tags

History