Why do the 0 in front of phone numbers get removed when I save a csv file? 

by on December 22, 2010

Q: In a csv file I need a 0 prefix next to all phone numbers. When I save it disappears. How can I make it stay?


Can I use an excel list of filenames to bulk locate images in a folder? 

by on December 17, 2010

Q: Can I use an excel list of filenames to bulk locate images in a folder (on my external hard-drive) and move them to a new folder on the same hard-drive?


How can we allow users to run VBS scripts on their laptops when not on our domain? 

by on November 2, 2010

Q: I’ve got a batch file that creates a local account with certain rights and runs a vbs script that logs the success/failure ratio.

Only problem is… the average user doesn’t have the rights to run it successfully. We are in the process of removing DNA (NetSupport) and installing LanDesk, which will allow us to send the batch with admin rights, but our laptop users are complaining that they cant use their laptops at home because they’re not on the domain.

Is there a way we can run the batch file with admin rights? possibly with a script? (we had a contractor do it a month ago for something else with a visual basic compiled exe if I remember correctly…)


How come when I click on Word or Excel IE opens? 

by on August 7, 2010

Q: My laptop runs on Windows 7. Recently when all the programs like word, excel, etc when clicked goes into the IE page. How do I fix this? Has any settings changed?


How can I modify an Excel document without having Excel installed? 

by on June 20, 2010

Q: How can insertions be made in an Excel document without having Excel software installed? Can an Excel doc be converted to Word?


Can I edit Excel files on my desktop from my netbook if I do not have Excel on my netbook? 

by on June 16, 2010

Q: I have an WiFi network in my apt, and a desktop PC (dell studio hybrid) holding most of my files and software (like ms office). Can I use my netbook to access excel work books via ms excel – on my desktop – to open and manipulate (edit/save) files? I do not have Excel installed on the netbook, and I need to be able to access/edit files on my decktop using excel.

Should i use a remote SW or can i install excel to my netbook somehow (without an exterior cd drive)?

Are there other options?


How do I create a unique id in Excel using multiple columns? 

by on May 3, 2010

Q: I am working on a Mac OS X with data in MS Excel that need to be modified. In field A, I have ID numbers that are not currently unique. The records are unique when the ID number is paired with an Event number in field B. To make the ID numbers unique on their own, I want to combine part of the Event number with the ID number for each record. This could be done in large portions of the data at once b/c there are fewer than 10 different Event numbers and the data could be sorted easily. So, I am wondering if it is possible to write a script, etc, to automate the addition of 4 characters to the end of each ID number for a selected portion of the data.


How can I make a unit price populate in a spreadsheet based on a string in another column? 

by on March 24, 2010

Q: I am working on a quote worksheet in Microsoft Excel. I would like to be able to have my unit price automatically populate in column E based upon the string value I put into column B using Excel in Office 2003. How would I get this to work?


How can I import a CD full of emails into Excel? 

by on March 5, 2010

Q: I have a CD of internet email files. I would like to quickly import the to, from, date, and subject fields into a spreadsheet. How do I do this?


Will an Excel file opened on two different computers with two different resolutions have the same column widths? 

by on February 27, 2010

Q: When working in Excel 2007, on a machine that is running Windows 7, screen resolution is 1680×1050, column width is changed to specific amount of pixels, file is opened on another machine running Windows XP with1024x768 screen resolution, will amount of pixels for column width change from machine to machine?