Tech Problem Aggregator

Paths changing in VLookups (Excel)

Q: Paths changing in VLookups (Excel)

There is an Excel App on our network that gets used by multiple users. In this app there are some VLookups that pull information from other spreadsheets. The problem we are having is that the physical paths in the VLookups are being changed to relative paths. Instead of using L:\Files\somefile.xls it changes to \\server\share\somefile.xls.

When this happens the VLookup stops working, it's odd because both paths are legetimate but only the one with the physical path works. This is happening on several different spreadsheets and the formulas have to continualy remapped.

All users are using Office 97 but the OS are mixed, Win ME, 2000 and 98. Any ideas?

Here are the Vlookups:

Before
=VLOOKUP($C18,'L:\shared files\[EmpDataLog.xls]RATE'!$B$10:$AZ$642,5)

After
=VLOOKUP($C18,'\\server01\shared files\[EmpDataLog.xls]RATE'!$B$10:$AZ$642,5)

A: Paths changing in VLookups (Excel)

Hi, Tal. I suspected, so I confirmed with someone else here at work, that your users have drives mapped differently and they really need to be the same.

3 more replies
Answer Match 73.08%

I have a "scorecard" that I use to rank helpdesk analysts based on performance, and make note of the "top 3" analysts for the time period.

The problem I am having is that if two analysts are "tied" for 1st or 2nd place, the next place (2nd or 3rd) shows up as "#N/A" - meaning there is no 2nd or 3rd place, since Excel's "Rank" function can display more than one "2nd place", then skip 3rd place, etc...

If I have a 1st place, and 2 2nd place analysts (skipping 3rd place); how can I incorporate a "=IF(ISNA)" into a VLOOKUP to show one of the 2nd place people in the 2nd place position, and the other 2nd place person as "3rd place".
 

A:Solved: vlookups in Excel

Hi,

Take a look here...

http://www.cpearson.com/excel/Rank.aspx

HTH
 

3 more replies
Answer Match 64.26%

Hello! I recently upgraded my computer with an SSD for boot and main programs and use my 1TB HDD for general programs and media storage. The thing is I want it to by default install to my D:\ drive.

Now the only solution I see is editing the registry ProgramFilesDir - Which has some serious flaws. It will attempt to launch every program off of the D:\ drive even when it is stored on C:\ and about 9 out of 10 times, it still default installs to C:\.

Does anyone have a fix for this?

More replies
Answer Match 63.42%

Hi friends!

I'm experiencing a very strange bug with a custom library. On the odd occasion when I open an explorer pane and navigate to my library on the left-hand side, two of my included folders - which are both located in 'C:\Program Files\...' will change to a non-existent 'C:\Program Files (x86)\...' version of the same folder. If I click on that folder in the library pane it will tell me the folder doesn't exist.

It happens infrequently but often enough to be annoying. It's not immediately clear what causes it or why it stops. When it happened just now I closed all open explorer panes and opened a new one, and the library displayed the correct 'non x86' folder structure.

Any idea what causes this and how it can be avoided?

Thanks!

Adam

More replies
Answer Match 63.42%

I have a program that plays music on VB 2008 Express Edition. It accesses music from my memory stick because I'm going to need to move the program to another computer. However, the memory stick was always listed under the J:\ drive, but now randomly it's listed under the K:/ drive. Is there a way so that I can just get the music "into" the program so that it can just play the music no matter what computer it is on. P.S. I also need to get this program to run on XP, and the file path is E:\, I'm afraid that since mine changed randomly, the XP computer I'm moving it to will also change randomly.

Please Help!
 

A:File Paths Changing Randomly

You can change the drive letter by going to Administrative Tools in Control Panel and them going into Computer Management, there is a section called Disk Management which will show all connected drives, from there you can change the drive path.
 

2 more replies
Answer Match 63.42%

I'm trying to figure out how to change my file path names. The system name on my computer is Tsula but all paths still say the 'Owner' thing.

Example: C:\Documents and Settings\Owner\My Documents\My Music\Enya\Enya (new age)\2005 - Amarantine

Know how to fix it? x3

A:Changing Root Name In File Paths

I think you need to create a new profile and move settings from old to new, How to copy data from a corrupted user profile to a new profile - http://support.microsoft.com/?kbid=811151 Louis

2 more replies
Answer Match 63.42%

On my desktop-computer i have shared some folders with my home network. Then i changed their paths, as i reorganized myself. Now it seems, when I acces the network, those folders paths dont seem to be updated, as i cant access them.

I can now of course "unshare", rename and share them again, which makes them again accessible through the network, but the old "folder names" still remain. why is that, how can i correct it?

Same problem with some old "synched folders".

A:shared folder and changing their paths

Curious, where do the old 'folder names' remain? Just in the drop down menu under 'Map network drive ...'?

If so those paths are saved in your registry.

Best Wishes,
R?nce

2 more replies
Answer Match 63.42%

I changed the user name from "user001" to "user888". That changed the name on the login/logout screens. But the user folders and paths all stayed with the old name "user001". As a result some things, like the name installed programs will grab and use, are still called "user001".

Is there a way, short of re-installing Windows, to change all the appropriate folders, paths and registry entries to read "user888" and get rid of the old user name completely?

A:Changing the User Folders (and paths)

You may want to create a new account and move the user files over to that new account. Then delete the old account.

A good explanation can be found from Brink below:
Creating a New User Account Similar to an Existing User Account

6 more replies
Answer Match 63.42%

When I first installed Win 7 I simply went with the default user name of "Owner". I wouldn't mind changing it now but I'm concerned about the effect on my shortcuts and so on.

If I rename it, will Windows go through and automatically update all the shortcuts and program paths and so on? My gut reaction is "Of course it will" but I've learned to be cautious with Windows! Will I end up with a lot of tidying up to do?

A:Will changing username mess up paths?

Only the username will be changed. The c:\users\<username> path does not get changed and this can lead to more confusion.

Better method:

1) Create two new accounts. One in the username you want, and one temporary...you can even call it TEMP if you like.

2) Log in as TEMP. Use Windows Easy Transfer to migrate all files and settings from your old account to the new one you just created.

3) When this is complete, log in as your new user and make sure everything is there and working.

4) Delete your old user and TEMP.

3 more replies
Answer Match 62.58%

By default, programs install to the same drive that the currently running OS is installed on. What I'm trying to do, is to tell it to install programs to another drive/partition.

This way, if I needed to reformat and reinstall the OS, the bulk of my programs will remain intact.

I've read other forums and they've given skeptical answers to indicate that it can't be done, but I figured I'd pose the question here myself.
 

A:Automatically changing program install paths

Yea, mostly games are what I had in mind.

I always move the My Documents folder to a completely different physical drive upon each OS installation (I've been reformatting a lot lately due to instablity with recent hardware upgrades).

I've gotten into the habit of keeping multiple, up-to-date copies of select Application Data--most importantly, Firefox browser data. Switching between a laptop and desktop regularly, I also am able to perodically sync the two systems with the same bookmarks, cookies, saved passwords, and the like.

I've heard there's a way to do it remotely with FireFox so you can import them from anywhere, but for this particular purpose I'm more comfortable keeping the information in my grasp.
 

3 more replies
Answer Match 62.58%

Hiyas

Here's my story. I've just managed to change a systems boot letter from E:\ to C:\. The machine is working fine now, but all the programs that were installed are still looking in E:\ which no longer exsists. I've gone through and changed a few of these paths manually, but after an hour of that i realised it'll take far too long to do it this way.

What i'm looking for is a tool to look through the registry and replace all instances of "E:\" with "C:\". Does anyone know if such a product is available? It's be a great help.

Thanks in advance
BW
 

A:Looking for registry tool for changing program paths

Good luck. This is going to turn out to be a real PITA, as I suspect you're finding out.
 

1 more replies
Answer Match 62.16%

I'm having an issue with Windows Media Player for Windows 7.

I imported a bunch of playlists and their associated music files from an XP machine to my new Win7 machine, and some of the music files aren't playing - Media Player simply says that there was "an error" with no further explanation given, but this error only occurs with files with a certain file path.

On my XP machine a large chunk of my music files were located in C:\Documents and Settings\[my name]\My Documents\My Music\[artist name]\[song title] as .wma files. I know that in Win7 the Documents and Settings subdirectory was replaced by Users or something - that's not the real problem, because for all my other music files, the file paths as shown in my WMP playlists will adjust themselves automatically and play the music files correctly no matter where the files are moved. My issue stems from the fact that WMP is not correcting the file paths for the files located in Documents and Settings the way it is for all the other files. There is no way to edit the file paths in WMP, or I would have tried that.

This is not the first time I've moved my XP playlists to a Win7 machine, but on my previous attempts I have had no problem simply copying all my music to one folder and playing them in WMP. So I'm not sure why it's not working this time.

I would prefer to avoid rebuilding all my playlists by hand - I really don't think that should be necessary, since as I said I've moved all my data from an XP to a W... Read more

More replies
Answer Match 61.32%

Hi, new to these forums so I really hope I'm posting this up in the right subforum.

Long story: My old hard drive was dying, and after installing a new one I used this "EaseUS" program to clone the old HDD's data onto the new one. This worked fine except for the fact that all of my shortcuts stopped functioning because the letter assigned to the new HDD was different from the old HDD.

Is there any easy, automatic way of making all shortcuts point to the new file path? Or do I have to manually change the hard drive letter in each shortcut's properties?

A:Changing letter assigned to HDD, need to edit program paths to match.

just reasign new icon back

2 more replies
Answer Match 58.38%

Hello.

I am currently using Skydrive to synchronize files and folders between my home and office computers. I created an Excel file which has hyperlinks linking to files located under the same folder as the Excel file on the local hard disk.
In the past I was using Excel 2010 and the synching would work fine. I would open the excel file in any of the two computers and when I clicked on the hyperlinks the file stored on the local hard disk would open. Recently I purchased Office 360 and suddenly the paths in the hyperlinks linking to the files were changed from a local relative location I.e. \test.xlsx! to a cloud address I.e. http://d.docs.live.net/afodfldfad/test.xlsx. On top of that even if I click on the hyperlink the file does not open.
Also Skydrive keeps creating copies of the files at random with the name of the computer where it was modified at the end I.e. test-Home-PC.xlsx.

Anybody know the reason for this and a way around it?

Thanks.
 

More replies
Answer Match 54.6%

I guess this may be a tiny bit off the subject here, but I am attempting this in windows 7.

I have a program file manager tool called 'Directory Opus' that is capable of calling windows external programs and passing them the current directory the file manager is sitting on.

So far so good.

Now I want to call a cygwin (linux/unix emulator for windows) terminal with that file manager.

Checking properties on the cygwin Icon I got the path: C:\cygwin\bin\mintty.exe -i /Cygwin-Terminal.ico -

So it is a path to a command and an argument to that command.

Actually I guess it is 2 arguments to a command since I think '-' in that position means to feed anything on STDIN to the command. At least that would be true in unix shell programming.

So using the Directory opus setup I pass this call:
'@async:C:\cygwin\bin\mintty.exe -i /Cygwin-Terminal.ico - <and here add {s}>'

So the call ends up:
'@async:C:\cygwin\bin\mintty.exe -i /Cygwin-Terminal.ico - {s}'

That call does just what it is supposed to. It passed the current file absolute address however cygwin terminal does not understand the windows path notation. If I were passing it: C:\subdir\blah\ It would just say 'No such file' Cygwin terminal wants to see /cygdrive/c/subdir/blah Or at least I think that is what is happing.

So to cut to the chase.... I'd like to put a little wrapper to Cygwin terminal in there with the code necessary to convert 'C:\subdir\blah\' to '/cygdrive/c/subdir/blah/'

But, I do not know how ... Read more

A:Dos paths and unix paths conversion

I would ask on DonationCoder.com specifically this forum:
General Software Discussion - DonationCoder.com

The reason is I know there are a bunch of DO aficionados, who also use Linux, on that forum. I've never tried DO myself. I have played around with CygWin. But it's been a few years.

If the site wants a donation to sign up just explain to Mouser why you want to post etc.. I think he'll be sympathetic.

3 more replies
Answer Match 54.18%

Okay.. here is one of those stupid simple things I never had to do before and can't figure out how to do it.. I know it's basic.. but .. I self taught so my training skipped around a lot.. sorry!

Basically I did a graph for a yearly set of values, not yet filled in.

My boss wants these charts to show percentages through 100% even blank, but it keeps defaulting to 0.something ranges.

For the life of me I cannot remember how to do this and on my search of the site was harry in trying to figure out a decent search range. Any help is most sincerely appreciated. I have a feeling it wil be a smack my head kind of thing.

Thank you!
 

A:Solved: Excel Graph: Not changing Cells, Changing Chart Value

7 more replies
Answer Match 51.66%

Hi there

I have an Excel workbook that I need help with. The following information has been changed to conceal its true nature.

In one worksheet, lets call that the master worksheet, I have a table with information regarding students assignments, there is their student ID, their name, their tutor, and which stream their assignment is for.

Column A = student ID
Column B = student name
Column C = tutor name
Column D = Stream A (cells in this column are either TRUE or FALSE)
Column E = Stream B (cells in this column are either TRUE or FALSE)
Column F = Stream C (cells in this column are either TRUE or FALSE)

I realize you may be wondering why there is not just one column displaying which stream the students are in but I need to work with another Excel sheet that has been inputted into the workbook I am creating, a new input will be used every month.

I then have different worksheets for each Stream. In the worksheet for Stream A, I want Excel to somehow check if against the TRUE/FALSE statement in Column D and then if the statement is TRUE to copy the data from columns A, B, and C

I think this may involve IF and LOOKUP statements but I am not sure

Many thanks and I look forward to a response
 

A:Solved: IF functions and VLOOKUPS

12 more replies
Answer Match 51.66%

I am trying to compare the contract ID in one spreadsheet to the contract ID in another spreadsheet and if they match bring back the data from the comments column on the second spreadsheet into the first spreadsheet. I am getting #N/A=IF(VLOOKUP('F:\Management Information\2016\UW MI Only\04 April\Month End\MI Compliance\[Data Quality Report- As at April 22, 2016.xls]Summary'!D2,$A$2:$D$246,4,TRUE)>=D2,"'F:\Management Information\2016\UW MI Only\04 April\Month End\MI Compliance\[Data Quality Report- As at April 22, 2016.xls]Summary'!$A$2,$Q$2:Q246,17,FALSE","BLANK")

A:IF statements with nested Vlookups

The basic VLOOKUPs should look like this:To return the value from Column P:=VLOOKUP(D2,Rpt_2!$D$2:$Q$246,13,0)To return the value from Column Q:=VLOOKUP(D2,Rpt_2!$D$2:$Q$246,14,0)Both of the formulas above will return #N/A if the lookup_value is not found. Assuming you are using Excel 2007 or later, the formulas below will return a blank cell if the lookup_value is not found. To return the value from Column P:=IFERROR(VLOOKUP(D2,Rpt_2!$D$2:$Q$246,13,0),"")To return the value from Column Q:=IFERROR(VLOOKUP(D2,Rpt_2!$D$2:$Q$246,14,0),"")Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

12 more replies
Answer Match 51.66%

Hi,
I use Windows 7 Enterprise Operating system.
Microsoft Office 2010.

I'm trying to lookup the same part number in an excel sheet, with multiple categories & different results on each line.
Please see below for example:

Part Category 2014 results 2015 results
ABC123 1 100 200
ABC123 2 200 300
ABC123 3 300 400

In a different sheet, I need to return the following 2014 results:

ABC123 = 100
ABC123 = 200
ABC123 = 300

In a different sheet, I need to return the following 2015 results:

ABC123 = 200
ABC123 = 300
ABC123 = 400

Please can you advise a possible formulae.
Thank you.
 

A:Vlookups for multiple results

Hi, maybe it's me but I don't really understand what you're trying to achieve.
Could you explain it a little more, maybe add a sample sheet with what you have and what to need as result?
 

11 more replies
Answer Match 51.24%

I feel like there is a simple answer to my inquiry and I have been trying various configurations that are too complex. I have two worksheets and I want to lookup values from one document based on two criteria from another.

In cell AO6 I have a color listed
In cell H6 I have a thickness listed
I want to automatically enter data based on those two items into cell L60

In a separate worksheet I have the data I need
Column A is colors
Column D is thickness
Column G has the code I want to be input into L60

For example if I look up Blue 1" (out of about 500 rows) I want it to return the code 12349 which will be on the same row. There are going to be other 'blue' colors and other 1" thicknesses, so a straight VLookup won't work. I tried putting a vlookup into an if statement and it just made a mess.
 

A:Solved: Multiple VLookups/IF statements

Is a macro a problem?
I imagine the other sheet you have will be source and the corresponding code to a value you select will be searched for in this sheet, Is this correct?
 

3 more replies
Answer Match 45.36%

Hello to all,

recently my excel started to change the dates lets say from 02/01/08 to 06/08/02 etc. But it doesnt change all dates just some. Please, help me with this.

My operating system is Windows XP.

Thanks,
 

More replies
Answer Match 44.94%

I'm not a Mac user, but a person I am working with is....
We have data exported from various applications into xls or csv files. When I open the files, I get the information needed. However, if the other person (using a mac) opens the file, the number field is changed to a date. The number input format is xxxx-xxxx & displays for her as x/x/xxxx. The date numbers are not at all similar to the orginal numbers (Example 1012-2012 does not display as 10/12/2012 but as 8/1/2514).
She is using excel for Mac 2011
Any suggestions?
 

A:Numbers changing to date in Excel for Mac

Hi, welcome to the forum,
The problem is that the is too much 'intelligence' built in Excel.
Excel makes it's own intertrepation when enetring a number and if 'it thinks that it's a data' it set the format to date format.

When importing a csv file you can also set the the format general but I don't know how the MAc version does this.
You could Google something like "Excel maintain original fort when reading csv file" and see what that brings you.

You have to thank Miscrosoft for this 'built in intelligence'
 

2 more replies
Answer Match 44.94%

Ever since installing SP2, when I download excel files from some bank websites, instead of downloading & opening them in excel, it opens them in a web based version of excel within IE. What setting can I change to make it open in Excel like it used to before SP2?

The Windows Firewall is disabled and I have the pop-up blocker enabled, but the websites I go to are in the exception list.

Thanks!
 

More replies
Answer Match 44.94%

I have an HP Pavilion dv7-1247d. The backlit volume controls at the back of the keyboard work fine for the volume, but touching the controls also opens Excel...sometimes multiple times. Any ideas?
 

A:Excel Opens When Changing Volume

LOL ok.. this one just.. caught my eye. That's funny. Did you accidentally set a hot key?
 

1 more replies
Answer Match 44.94%

Hi,
I have disabled every auto-correct and auto-format option I can find, but Excel still won't stop changing my numbers to dates. If I type 1-2, it automatically changes it to 2-Jan, and so on. I'd really appreciate any suggestions you can offer me. My bio grade appreciates it, too. Thanks.
 

A:Excel Keeps Changing Numbers to Dates

Have you tried formatting the field(s) to text?
 

2 more replies
Answer Match 44.94%

I'm having a problem that no one here can fix. When I try to open a file in Excel and need to switch directories it takes minutes, literally, to go from one directory to another.

I'm running Excel 2002 on an IBM T30 with XP. HD has plenty of room, I've tried defragging the disk, repairing Excel, running Spybot, Adaware, Norton etc. I have no problem with Word or Explorer.

Any help would be greatly appreciated.
 

More replies
Answer Match 44.94%

I recently changed the DPI setting on my computer. But now all my Office excel spread sheets do not fit within the margins and page breaks they did before the change. I had meticulously entered my data so it fitted exactly page to page, but now it has all changed so pages flow onto the next and exceed the margins.
Even before I made the change, if I emailed my spread sheet to others they could not view it the way I had set it up unless their DPI was exactly the same as mine (eg data not fitting within pages and margins)
Is there some way of overcoming this ? I could changing all my sheets so they now "fit" as I want them to with the changed DPI setting, but it won't alleviate the problem of email recipients being able to view them the way I had set them up.
I am using Windows 7 & Office excel 2003
 

A:changing dpi effects excel documents

16 more replies
Answer Match 44.94%

I want to be able that when I do a sum function, Excel automaticly makes the sum the color red and bold. For example:

2
2
2
6

I know I can format each cell that a sum will be in, but I don't want to do that if I don't have to.
 

A:Excel - Changing the font on sums

11 more replies
Answer Match 44.94%

When I try to change the fonts in Excel 2000, my computer locks up. Is this a known issue with Excel 2000 or is it just my computer?
 

A:Changing Fonts in Excel 2000

It's not a known issue, so must be a problem on your system. Have you done a Detect and Repair yet? Go to Help, Detect and Repair. If this does not correct the problem, you may have to uninstall and reinstall Excel.
 

2 more replies
Answer Match 44.94%

I am trying to change the color and font of a few words in an automated e-mail I am sending out VIA VBA in outlook. Here is the code: I would like to change the "payment due" so that the number it takes from the workasheet shows up be in the color red.

Compose the message
Msg = ""
Msg = Msg & "Hello" & Cells(cel.Row, 8) & "," & vbCrLf
Msg = Msg & "Please confirm the following payment(s) due " & Cells(cel.Row, 7) & ": "
Msg = Msg & Cells(cel.Row, 3).Text & " USD" & vbCrLf
Msg = Msg & "This is for invoice #" & Cells(cel.Row, 1) & " due " & Cells(cel.Row, 5) & vbCrLf
Msg = Msg & "If there is an issue regarding the invoice please contact me at the below number." & vbCrLf
Msg = Msg & "Thanks you" & vbCrLf
Msg = Msg & "Bill" & vbCrLf
Msg = Msg & "555.555.5555"
Let me know if this is possible. Thanks!
 

A:Changing color of words in Excel VBA

You must use HTML formatting in your email but just to let you know, the formatting will not show up on the other persons PC if their mail client uses plain text formatting. Here is some code to help get you started. If you can't put it all together just let me know and I'll help you with the rest.
Code:
Public Sub ColorMail()

Dim olApp As Outlook.Application
Dim olEmail As Outlook.MailItem

Set olApp = New Outlook.Application
Set olEmail = olApp.CreateItem(olMailItem)
olEmail.HTMLBody = "<font face='Arial' color='red'> HERE IS RED TEXT</font><br />"
olEmail.HTMLBody = olEmail.HTMLBody & vbCrLf & "<font face='Arial' color='green'> HERE IS GREEN TEXT</font><br />"
olEmail.HTMLBody = olEmail.HTMLBody & vbCrLf & "<font face='Arial' color='blue'> HERE IS GREEN TEXT</font><br />"
olEmail.Display

End Sub
Regards,
Rollin
 

3 more replies
Answer Match 44.94%

Can anybody help with this question? I have a massive spread sheet with numerical data in it. on paper I have associated a number to different ranges.

For example in columb A any number that is between 25-30 needs to be converted to 0.375. Can anyone tell me a quick way to convert these and other numbers in one go?
 

A:Solved: Changing all numbers in excel?

9 more replies
Answer Match 44.94%

I have a VERY LARGE worksheet typed all in caps. I would like to convert this to upper and lower case. Excel help says to use the formula =PROPER(CELL REFERENCE). This does work but with over 4000 lines in this particular worksheet, it would take forever to convert each cell in each line. I can't get it to work for multiple cells abut I'm not too familiar with writing formulas in Excel and might be doing it wrong. Is there a way to get that command to change several cells at once, or even better, to be able to do an entire column at once. I just received this worksheet and I only have until tomorrow to reformat it. ANY HELP GREATLY APPRECIATED!
 

A:Excel probelm - changing cases

11 more replies
Answer Match 44.94%

How can I get my chart to LOCK the way it looks. Sometimes it takes up the whole page and sometimes it is small like I created it.

Kristi

PS Excel 2000
 

A:Excel chart keeps resizing and changing itself ...

9 more replies
Answer Match 44.94%

I need a macro that will compare 2 lists in Excel and pull out any values that are identical in two columns. I got the macro in this post from microsoft's website, but the problem is, I think it only goes from A1:A100 while I need it to go from A1:A800000 I tried just changing the A10 and A100 to A800000, but I got an error 6. Can anyone help me change what needs changed?
Sub DelDups_TwoLists()Dim iListCount As IntegerDim iCtr As Integer' Turn off screen updating to speed up macro.Application.ScreenUpdating = False' Get count of records to search through (list that will be deleted).iListCount = Sheets("sheet2").Range("A1:A100").Rows.Count' Loop through the "master" list.For Each x In Sheets("Sheet1").Range("A1:A10") ' Loop through all records in the second list. For iCtr = 1 To iListCount ' Do comparison of next record. ' To specify a different column, change 1 to the column number. If x.Value = Sheets("Sheet2").Cells(iCtr, 1).Value Then ' If match is true then delete row. Sheets("Sheet2").Cells(iCtr, 1).Delete xlShiftUp ' Increment counter to account for deleted row. iCtr = iCtr + 1 End If Next iCtrNextApplication.ScreenUpdating = TrueMsgBox "Done!"End Sub

EDIT: I posted this and I notice that the forum did some formatting. I found the macro at http://support.microsoft.com/kb/291320 It is the second macro on the page.
 

A:Excel Macro, changing range

Well here's the problem.

800,000 cells is a lot of cells.
The Microsoft code isn't build to deal with this many, with good reason, as on making it large enough Excel crashes (at least on my laptop).

How many rows of data do you actual have?
And can I also ask how many columns?
Hopefully nothing like 800,000 records, so reduce the amount of cells to count.
 

2 more replies
Answer Match 44.52%

First time coding VBA in excell and I want to execute some code anytime any cell changes in my worksheet. Cant figure out what event needs to call my code.

I attached the worksheet and my test code in the module.
 

A:Cant get code to execute upon changing a cell in Excel

10 more replies
Answer Match 44.52%

I have a tab delimited .txt file. One of the fields has 5-2056 in it. When I open the file in Excel, it gets changed to May-56. How can I stop this? I can't edit the data, and I can't format the cell (it's not an actual cell/spreadsheet).
 

A:Solved: Excel, stop changing to date

If you want the 5-2056 kept as is, then do the following.
Select all the cells with data in
Click on Data, Text to Columns
Delimited, NEXT
Select the delimiters you want to apply e.g.TABS, NEXT
The 5-2056 should now be shown in its own columnand the heading should say general. If so just click on Finish
It should now be in its own columns and the 5-2056 will appear just as that.

hope that works foryou.

Come back if you need more clarity.
 

3 more replies
Answer Match 44.52%

Hello,

I am beginning to suspect this is not possible. What I want is to have a column with "notes" in which the cells (and the rows with them) expand downwards to accommodate additional text. Can this be done? All the online tutorials just seem to think people want lots of nice additional empty white space at the top of the cells when they change the cell height!

Am I missing something? And can anyone help?

A:Changing cell height in excel 2013

just select text wrap. Column will get longer not wider though. The effect will be visible after you will finish cell editing or of you preformat cell height then all will be as you write (assuming that cell is correctly pre-formatted)

2 more replies
Answer Match 44.52%

I am using Windows 98, Excel 2003.

We have 22 charts (pie and horizonltal and vertical bar charts) but the default colurs do not go with the corporate style of the reports that they need to go into.

Is there any way of changing the colour pallette ?
 

A:Excel Charts - Changing the default colours

Yes, open the Excel workbook that you want to modify, go to TOOLS then OPTIONS and select the COLOR tab , select a color beside Chart fills then click on Modify. Repeat with each color that you want to modify.
 

2 more replies
Answer Match 44.52%

I am trying to use part of a macro to change the active cell to a cell address determined from data entered by the user. For example, a user enters a date, the date is compared to a list of dates and when a match is found the cell address is returned. I want to then make the returned address the active cell. Can this be done and if so how?
 

A:MS Excel - Changing the Active Cell Macro

You would need to use VB code. I don't think you can record a macro to do that...do you already have a way to find the matching date or do you need help on that part too?
 

3 more replies
Answer Match 44.52%

In 2007 I use cell styles a lot when financial modelling, however I create all of mine from scratch and delete all of the default ones. This results in there being a Normal style in "Good, Bad and Neutral" and about 25 other styles in "Custom".Is there any way to:1. Change the name of the existing categories of Cell Style?2. Add a new category of cell style?3. Create a new cell style and assign it to a category other than Custom?I know there are add-ins that enable you to do all of the above in their proprietary windows but they don't then change the Excel gallery, I need this to change as I will then be getting other people to import styles from a spreadsheet I give them and those people will not have the add-ins.Hope that makes senseThanks
 

More replies
Answer Match 44.52%

I would like to have my list in excel have every other row of information a separate color so that the list is easy to read. (i.e. blue row, no fill row, blue row, no fill row, blue row, no fill row, etc.) I would like to be able to sort the data in this list without the color of each row sorting with the information. Is it possible to lock the fill properties of cells so that it does not sort along with the information in that cell?
 

A:Excel Sorting without cell properties changing

Here's how.

Select however many rows you need (click'n'drag on the row headers).

Choose Conditional Formatting from the Format menu.

Set Condition 1 to Formula Is. In the box, enter

=MOD(ROW(),2)<>0

Click the Format button. On the Patterns tab, choose a suitable blue. Click OK. Back in the previous dialog, OK again. The formatting will not be affected by Sort.

Rgds,
Andy
 

1 more replies
Answer Match 44.52%

Hi, there is one excel file that I have that I would like to keep a certain window size on my computer. I don't like to have to drag it back to the size I want every time I open the file. My other files don't seem to do this, once I change the size of the window it remains that size after I quit the program and re-open it. The file is protected but it seems to not want to listen to me when I try and format the window the way I want it to. Any suggestions?
Thanks!
 

A:Excel default window size keeps changing

What version of MS Office do you have?

As a general rule, once you drag the corner to the size you want and close the program, it will reopen to that same size. I don't think (but I could be wrong) that there's a way to choose a specific size for one particular document.

The only thing I can think of it to set your "restore down" to the size you want (assuming it's smaller than full screen) and then when you access that document you won't have to drag the corners but rather just click on the "restore down" icon in the top right-hand corner.
 

2 more replies
Answer Match 44.52%

whilst techguy was down today I also posted in officeexperts
[http://www.theofficeexperts.com/forum/showthread.php?s=&threadid=3599]
I have been putting together some pivot table charts in excel (for my brother who has excel2000, I have excel2003 - both versions show the same problem).
the charts default to a bar chart.
I have set up a custom chart which has 1 bar and 1 line - i have also set it to default.
However, every time the chart is updated or change - ot changes back to the barchart only.

so say we have 5 periods of data and on the chart we look at period 1 - with a bar/line combo with clear background graph, when we change to period 2 on the pivot the chart changes to just a barchart with a gray background.

how can i set our custome chart to stay default.....

thanks
 

A:pivot charts in excel changing layout

found this - so its a known bug

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904
 

1 more replies
Answer Match 44.1%

Trying to change the default save\open location for Excel 2000 queries which is:
C:\Documents and Settings\user profile\Application Data\Microsoft\Queries.

I would like to change this default location to a network drive????

Thank you.
 

A:Changing default location for Excel 2000 Query

Data - Get External Data - New Database Query - Options
 

1 more replies
Answer Match 44.1%

So I've figured out how to redefine Comma Style to the format that I want to use. But that only applies to a single workbook.

I also found instructions for how to save custom styles into a new default template. The problem here is that this only applies to new workbooks. Very rarely do I create a workbook from scratch, so this isn't much help.

I also figured out how to copy/merge custom styles from one workbook to another. But what do I do if I have hundreds of files I want this custom style to apply to?

Is there a way to redefine Excel's default definition of a given style such that it is applied universally in my local instance of the the program rather than just being file specific?

Thanks in advance!

More replies
Answer Match 44.1%

I have the following data:

1/1/05
2/1/05
3/1/05
Each of the cells is formatted as a date, and is a value.
What I would like to do (and what could be done under Lotus) is to record a macro that puts the ' in front of 1/1/05 and makes it a value. I realize there are other ways to do this, but the functionality of adding a character before a value is what I am looking for.

Functionally, I record this macro with these keystrokes:

F2 Home ' Enter

which results in this code:

ActiveCell.FormulaR1C1 = "'1/1/2005"
Range("A3").Select

If I run this macro, it changes the cells underneath to 1/1/05, instead of keeping their date. Where am I going wrong here and how can I make this work?

Thanks!
 

A:Solved: Excel and VB: Changing cell value to text with macro

16 more replies
Answer Match 44.1%

Does anyone know how to change the format of the [date] that is put into a footer?

Thanks!
 

A:Solved: Excel - Changing date format in footer

Hi slgraham22,

the only way is via a macro: http://support.microsoft.com/?kbid=213742

lol
Hew
 

3 more replies
Answer Match 44.1%

Hi everybody,

I really didn't know how to call this question, but I will try to make it clear.

I got an Excel sheet which contains in total over 1000 names and adresses. These adresses contain a lastname, surname and adresse etc.

Cell b10 contains for example, "Klaasen, P"
Cell c10 contains the adress of this person.

Now I would like to get the content of the b10 cell to "P, Klaasen" instead of "Klaasen, P"

Is this possible in any way? I can't find any options in Excel for doing this and I can't find anything on the internet.

Thanks in advance!
Willem
 

A:Solved: Adress list excel changing names

9 more replies
Answer Match 44.1%

Hey guys i need a formula that can change my 1000's of dates from regular mm/dd/yy into year and Quarter

so for example my date is 10/12/05

i need it to output 2005 Q4

thanks
 

A:Solved: Excel-Changing dates to year and Quarter

Assuming your dates are in column A, you can use this formula and drag it down all of the cells. Hope that helps.

=RIGHT(YEAR(A1),4)&" "&"Q"&ROUNDUP(MONTH(A1)/3,0)
 

3 more replies
Answer Match 44.1%

I have a spreadsheet with a "Data" worksheet and then several other worksheets with pivot tables based on the "Data" worksheet. Every month, the data list changes and I have to go into each pivot table and change the source data.

Is there any way that the Source Data can be changed for ALL pivot tables in a spreadsheet (based on a change to data in the "Data" worksheet)?

T

A:Excel Pivot Tables - Changing Source Data

how does the data change
if you put the data into a table on a sheet name and then just update the table and sheet name , all you should need to do is refresh the pivot tables

can you describe the process completely

7 more replies
Answer Match 43.68%

Hello guys, I just can't work this one out. A simple formula somewhere on the worksheet "=B1-B11" will give us the answer to the contents of B1 minus the contents of B11.

Here's where I am stuck. I want the answer to be B1 minus what is in the cell that is 10 cells down, in this case B11. But I want the be able to change how many cells it will go down to find the cell to subtract from cell B1.

In my example, if I put 10 in cell A1 how do I make so if I change it to 5, the above formula will effectively be "=B1-TheCellThatIsA5CellsDown", in this example the same answer as the formula will effectively be "=B1-B6" if even makes sense?

Thank you in advance.
Aussiemosis
 

A:Solved: Excel - Changing the range to include a certain number of cells

8 more replies
Answer Match 43.68%

Hi folks, got a question re: Excel 2010, running on win7 Pro 32-bit (it's not the machine in my stats).

I looked up tutorials to change the default save folder location for MS Office, and pretty much all of them reference MS Word 2010. Like for example the one in this forum, MS Office Word : Set Default Save Location -- which works fine when I try it, no problem with Word 2010. However, Excel 2010 is being a **** and refuses to following spec.

Consider:
When I click on File -> Options, then navigate to the "Save" tab, it displays a screen similar to the equivalent one in Word... except that the "Browse" button to change the folders is missing.



No big deal, plus the default file location is already pointing to my user folder: that's fine. However, when I go to save or save-as, this is what pops up:



Yea-- no. Why is Excel showing libraries? I don't want to use libraries. I don't want to see libraries. I've used the registry hack from this forum to remove libraries from showing up in the left pane of Explorer.

How do I get Excel to use my documents folder as the default?

A:Changing Excel 2010 default save folder location

After changing the location in the Excel Options --> Save tab... did you reboot?

9 more replies
Answer Match 43.68%

Hi all,

I have done a decent amount of Java, but VB is slightly confusing to me.

I want to be able to write a loop which will copy data, transpose it and then paste it. It needs to do this several hundred times, with each copied data-set being on a new row.
Code:
Dim Num As Integer


For Num = 1 To 10 'start loop

'cut source cells
Sheets("14402-ANSWERS-07-27-05-2").Select
Range("A2:C33").Select
Selection.Cut

'Paste-Copy-PasteSpecial
Sheets("Sheet1").Select
Range("A1").Select
ActiveSheet.Paste
Selection.Copy
Range("A34").Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
, Transpose:=True

'Delete Source Rows
Sheets("14402-ANSWERS-07-27-05-2").Select
Rows("2:33").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp

Next Num ' end loop

'Autofit the data
Sheets("Sheet1").Select
Columns("A:AG").EntireColumn.AutoFit

(nb The reason for the cut-paste-copy-pastespecial is because Excel won't cut and paste-special across different sheets.)

As you can see, I'm nearly there, but currently all it does is paste each new set of data over the existing one in cell A34. How do I make it increment the destination row by 4 or 5 on each iteration?

This is incredibly simple, but it won't let me j... Read more

A:Solved: Changing a Cell Reference: Noob question in VBA/Excel

You use Activecell.Offset(r,c).select to move from the current cell. You increment r for rows and c for columns.
Excel has no problems with "Paste Special Transpose" when moving from sheet to sheet. I just recorded this Macro of doing just that -
Selection.Copy
Sheets("Sheet2").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
 

2 more replies
Answer Match 43.68%

Hi,

I was a programmer in VC++ before activex, now I just need to do a little bit for my own personal project. So, bear with me as OLE is new to be and the last Basic I used was not Visual<g>.

I am trying to embed an excel workbook in a form on a SSTab control. I put an OLE container on the control, then cancelled when it asked for the object. In my code, (which I grabbed from the MS knowledgebase), I create the Excel object.

My only real problem is that when the workbook appears, it is not in the "visual container". In the design of the form, I dragged the corners of the object so they would be about 4"x6" on my screen. But when the excel workbook appears, it is only about 2"x3", and it's upper left hand corner is above and to the left of the upper left hand corner of my displayed OLE container.

How can I make the workbook display in the entire container with the upper left-hand corners matching? I tried the zoom, but that gave me the same cells, only a lot bigger. I've tried setting the width and height of the object's window directly, but that seems to have no effect.

Any suggestions?

TIA,

Cash
 

More replies
Answer Match 43.68%

Hi folks,

Does anyone know how to change the purple default colour for a used hyperlink in Excel 2003?
I have managed to use Format/Style/Modify option to take off the underline and set my font size but would like the actual text not to change clour from blue to purple.
 

A:Solved: Changing visited hyperlink colour in Excel 2003

Make sure you have a hyperlink and a followed hyperlink in the sheet

Format > Style and in the name dropdown choose hyperlink / followed hyperlink and > modify. You should be able to change the colour
 

2 more replies
Answer Match 43.26%

As part of a program i am working on data is transferred into an excel document with usually more than one worksheet. after that happens a mail merge is manually done to create labels. the problem i am having is that the first time i open the excel workbook i can choose a table and make labels fine but if i try to open the excel workbook again to change the table to make new labels an error pops up saying that word cannot open the data file because it is already open. i know for a fact that the only place it is open is in word because i already have labels open from it, and this operation works perfectly fine on another computer. i am concluding that this is a Microsoft office error however i cant find any other people having problems with this.
 

A:Error when changing excel data sheets in word mail merge?

Welocme tho TSG,
If word is open and linked to the spread sheet, opening the spreadsheet in exel would evoke the "in use" response. Closing word is the only option here.
 

3 more replies
Answer Match 42.42%

I have built a simple timesheet for someone in my dept, which includes amongst other things:

- hours worked over a month,
- how many hours owed/extra worked
- a cumulative of this figure over the months.

The requestor wants to be able to type a letter such as 'e' to represent a 07:30hr shift. So they type 'e' and the cell contents change to 07:30. There are about 6 different codes.

Normally a Vlookup would work EXCEPT you can't change the contents of the cell your are working upon.....cicrular referencing!

I could see two ways forward: either a function that allows the above

OR (perhaps more favourably)

leaving the lookups until the hour calculations at the base of the form. i.e Instead of a simple Sum for the hours worked that month, it could read the values in the range, look them up from a table(vlookup), and then sum the looked up figures to give the answer in the 'hours worked' cell.

I vaguely remember this being possible from my university days but can't remember how.

Can anyone help me?
 

A:Excel 2003: automatically changing a cell's contents based on keyword entered

9 more replies
Answer Match 40.74%
Q: Paths

Quote:




Sounds like your PATHS are wrong ?



This is always fun.



You need to ?locate? the nmake.exe and ensure that the path to this file eg, c:\myfiles\nmake.exe is listed in PATH




This is something someone told me i needed to do to finish compiling a program (anope IRC services)

Frankly I'm rather new to all of this and have no clue exactlly what to do

Any help would be greatly appreciated

A:Paths

This page has the full instructions for building Anope for Windows

4 more replies
Answer Match 40.32%

I was just wondering if there were a way to change the default cookie path in XP to another location; for example, my RamDrive...Thanks for any help! peace,
ian
 

A:XP Cookies and Paths

6 more replies
Answer Match 40.32%

http://www.mediafire.com/?hlnmttzzyrg

I am using Parallels running Windows XP.
I try opening the run.bat file from there but it appears and disappears in a second. I managed to click it like crazy and see what it says. "UNC paths are not supported." I also opened CMD and dragged the run.bat file over into it. This is that I got...

Any help would be much appreciated.
 

A:UNC paths are not supported

7 more replies
Answer Match 40.32%

Hello, I know (am pretty sure >.<) that there is a way to do this.

I am trying to set a file path for a folder, but I need the folder to go to the current username, instead of my username. For example..

C:\Users\Matt\Documents\ - Is my current path

I want it to be C:\Users\*THEIR USER NAME*\Documents\

A:Help With File Paths

Hello Anyok,

You can use the path below for a universal profile path instead.

%USERPROFILE%\My Documents

Hope this helps,
Shawn

3 more replies
Answer Match 40.32%

Is it possib to delete the shared document and libraries from my Seven ? Or will windows keep generating new ones at each boot ? Can I stop windows from doing this ? or have i have to live with this ?


PC-specs

Packard Bell Imedia
q8400
4 gb ram

etc


VV

A:Paths , Librabries ?

You need to remember that library's only point to the actual file somewhere on the network or on your own machine in the "user" files. If you need to delate something from the library you should delate the file from the actual source "my pictures" My documents" "my music".

But there is a way to make it work like you want.

Just go into Windows Media Player, choose the "organize" tab then "options" then choose the Library tab and set it to "delate files from the computer when delated from the Library. Although I believe that only works if you are delating files from Library of the machine that contains the source files.

That should allow for delating from the Library, but only from the machine that the files reside on, I don't believe it will work accross the network. It think it still works best if you delate from the file source instead of the Library.

1 more replies
Answer Match 40.32%

Hey:

I'm trying to enter a registry value. However, the place to enter it is dimmed:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\

When I right click App Paths "New" appears and should allow me to left click on "Key". However, "Key" is dimmed so I cannot select it.

I am the admin and logged in as such. I have XP Pro SP3 installed.

How do I make "Key" available?

Thx

A:How to make xp app paths key available

Sounds like a permissions issue of some kind.

Right click App Paths then click Permissions
Administrators and System should have Full Control and Read access, Power Users should have Read and Special, and Users should have Read access. Creator Owner should have Special. These should all be greyed out, meaning they are inherited.

4 more replies
Answer Match 40.32%

Hi,

I recently had to get rid of of my slave harddrive, and therefore had to reinstall a few programs:

A problem occurs when i try to setup software using setup files that worked perfectly before:

---- 1607:Unable to install InstallShield Scripting Runtime.

I check this out on net. Download the required isscript.msi, which should automatically install the required installshield again. But then i get it automatically pointing towards my old hd

---- Error 1327. Invalid Drive: G:\

Can someone please help me understand whats wrong and how to find a solution?

Cheers,

Xav

More replies
Answer Match 40.32%

http://www.mediafire.com/?hlnmttzzyrg

I am using Parallels running Windows XP.
I try opening the run.bat file from there but it appears and disappears in a second. I managed to click it like crazy and see what it says. "UNC paths are not supported." I also opened CMD and dragged the run.bat file over into it. This is that I got...

Any help would be much appreciated.
 

A:UNC paths are not supported

I've posted this on 10 sites and all I got are witty remarks. People are just dumb these days....
 

2 more replies
Answer Match 40.32%

All,

Looking for a way to add a single file to an existing .ZIP file, but need to specify the path within the existing file structure.

Example - I ZIP a directory and it's subs with all of their files. It has about 6 different subs and each of them have up to 10 subs of their own.
C:\WEBSHARE\WWWROOT\PE\SUB1\file1.asp

I need to add 1 single file and tell it that the path I want it to go to is:
C:\WEBSHARE\WWWROOT\PE\SUB1\file2.asp

BUT - the file is not coming from the same directory on the system being used to create the ZIP.

Please help.

Thanks,
Shaun
 

A:WinZip paths

6 more replies
Answer Match 40.32%

I am trying to show a friend how to use a used computer he purchased recently. I have done some exploring in his files and folders. My experience is limited to XP only; so some things look different to me. I found this path: C:\Users\username\AppData\Local\Temp\services.exe which seems odd. Is a temp folder where Vista would place services.exe, or does this indicate a problem?

Thanks for your replies,
welf
 

A:vista paths

6 more replies
Answer Match 40.32%

I did not know which forum to post in for my problem. Sorry if this is the wrong one.


I recently tried to relocate my data folders and something went wrong. When I was done I had dble folders. This is a picture of the results.
Attachment 171583

I moved them back to it's original place. I want to be able to move them a separate partician. I know that the problem has something to do with paths being incorrect.

When I click on the start menu and on my username icon it opens up my real user folders and not Libraries. I wonder if this is a clue. I have returned the start menu customizations to default and it still opens my user folders. Can someone help me figure this out?

Thanks.

A:Need to fix folder Paths.

Hi ariel5345

Have a look at this - Start Menu User Folder Buttons - Open to Users Instead of Libraries The second set of .reg files will reset your start menu open locations.

This should help put your user folders back to their default location - User Folders - Restore Default Location

Follow this excellent tutorial to help move your user folders successfully - User Folders - Change Default Location

Post back with any questions

Danny

6 more replies
Answer Match 40.32%

Im new to windows 10, i upgraded from windows 7. I am beyong annoyed with the File looking for is here, there, in that folder and dont forget the folder under it lol. I sync my phone to pc for Dropbox, Files starts to sync and im seeing the same file syncing over and over like 4 times, along with the annoying windows sounds each time. I look to see where they are going and one goes to a folder
Same file here
This PC-Windows C-users Branscum-dropbox

same file went here
Network-THEBRANSCUMS201-Users-Branscum-Dropbox
and here
C-users-craig and lisa-Dropbox

i could go on but im confusing my self even more...Please i dont need all them access points for the same file ...Could some one explain this to me
 

More replies
Answer Match 40.32%

Applications won't run because the paths can't be found but the files and folders all exist

More replies
Answer Match 40.32%

I'm writing a batch file which calls a 32 bit .exe program. I want it to be compatible with the different Windows operating systems. The problem is that the path to "Program Files" is different depending which OS is being used. For instance:

I know the paths for these OS' since I use them:
- WinXP 32 bit: C:\Program Files\
- Vista 64 bit: C:\Program Files (x86)\

Could some kind souls please tell me what the 32bit paths are for:
- WinXP 64 bit:
- Vista 32 bit:

And for Windows 7 also would be nice:
- Win7 32 bit:
- Win7 64 bit:

Thanks!
Sky

A:Need help with paths in XP and Vista.

Environment variable - Wikipedia, the free encyclopedia

Look down in the section called "system path variable" for %ProgramFiles%.

Some other good stuff on that page as well.


Gil

6 more replies
Answer Match 40.32%

there two windows xp professionals installe dmy pc .
How can I delete the second?

A:Boot Paths

Go to Start/Run and type msconfig go to the Boot.ini tab click Check All Boot Paths

2 more replies
Answer Match 39.9%

Dear All,

One of my user is facing copy paths issue in window 7 enterprise . User get the following error.




Thanks & Regards,
Kashiram Sawant

More replies
Answer Match 39.9%

ok this might sound stupid but, i have a wi-fi router that also has ports for wired connections.
my laptop is usually connected to the router through the wireless medium but if i connect the wire too then what path would the packets take?
the wired or
the wireless?
 

A:priority of routing paths

10 more replies
Answer Match 39.9%

I was wondering what would be a good career path to follow or combine with a mcse certification. Would it be better to go the cisco way and get the ccnp or with red hat and do the rhce? I am currently in South-Africa and been around to our local job sites but it seems that demand for both are low at the moment.
 

More replies
Answer Match 39.9%

There are still doubts about what the possible and legal upgrade paths are for Windows 7.

Below I tried to compile some information in a way which I hope will be helpful.

Thanks to my friend Kari for his valuable contribution
Any other additions or comments are much welcome

Definitions:
1) Upgrade: to move from Windows XP or Windows Vista to Windows 7
2) Custom or Clean Install: wipes the previous installation and install Windows 7 anew. Does not preserve user files
3) In-Place Upgrade: upgrades from specific versions of Vista to specific versions of Windows 7, preserving user files and programs.
4) Upgrade version: Windows 7 license for those who own a valid license of XP or Vista
5) Full retail version: Windows 7 license to install on any PC, independent of previous installations or ownership. Can be reinstalled on other computers (when activated the previous installation is no longer valid)
6) Full OEM version :Windows 7 license to install on one PC, independent of previous installations. Can only be re-installed on same computer and hardware setup

Upgrade paths
The chart below shows in what situations one can perform an in-place upgrade (e.g. from Vista Business to Windows 7 Professional) without the need to migrate files or programs, and the situations when one needs to do a Custom (Clean) Install and replace the data in the target disc. This is the case for all Windows XP owners or Windows Vista Starter. In this case you will need to migrate your personal files ... Read more

A:Windows 7 Upgrade Paths - FAQ

Excellent!

9 more replies
Answer Match 39.9%

Hello,
 
I can´t find a solution to this problem anywhere in the Net, so maybe you guys can help me. I just did a reinstall of windows 8.1 on my desktop using the option to keep all data AND program files. The process went on very well....BUT when I restarted some programs' exe files are not found by Windows when I try to open them (Ccleaner and Office 2010 are examples) Ccleaner I uninstalled and reinstalled but the message is the same " Windows cannot find [path], make sure you typed the name correctly and then try again...." Office 2010 I ran the repair option but the message came on again, so I reinstalled it and couldn´t open it because the message came on again. I think paths got messed up somehow because those files are certainly in my hard drive. Please can you help me out?

More replies
Answer Match 39.9%

I use WinAso Registry Optimizer; when I run it my computer crashes when it gets to Invalid File Paths, but when I remove the invalid file paths flag, it completes the process just fine. I would like some advice on correcting invalid file paths...thanks.
 

A:Invalid File Paths

Don't use registry cleaners. If you continue to use them, chances are that crashes will be among the least of your problems. Those things are junk, do only harm, and you should be thankful you were even able to reboot. Performance is not improved by using them, they remove needed entries, and they create their own "errors" so that they can "fix" them, making worse errors in the process.
 

3 more replies
Answer Match 39.9%

I have Windows XP Pro, sp 2.

I've encountered paths like: C:\DOCUME~1\ROYON~1\LOCALS~1\Temp. Except the tilde is higher. I don't know how to follow paths when there like this. Can someone please tell me how to interpret this path?

Thanks,

royeo
 

A:How do you interpret paths like C:\DOCUME~1\...

Hi.

This kind of path is contraction of the real folder or file names so that they are compatible with the old 8.3 DOS filename format. I don't know why it is necessary, but in (my) theory it works this way:
Long names are stripped of all spaces, even between words.
If the resulting string, without extension, is longer than 8 characters, the 6 leftmost characters are taken and an index appended, to distinguish between similar names.
So "ASDFGHJKLQWE" becomes "ASDFGH~1" while ASDFGHJKLRTZ" becomes "ASDFGH~2"

So the one you submitted translates to something like

C:\Documents and Settings\Username\Local Settings\Temp
Where username is different for each user of the computer.
 

2 more replies
Answer Match 39.9%

On my main PC i am running Windows 7 Homepremium 64bit. My Pc is connected via ethernet cable to BT Homehub3.

I have another PC running Windows XP SP3 connected via WiFi and a laptop also Wndows XP and connected vis WiFi.

I have a Kodak C110 AiO printer connected to the home pc via USB cable.

I have tried to set up printing on the other PC and laptop and the Printer is shown in the network map, but cannot and all my efforts have now disrupted the network; viz I cannot access shared files on the Network.

On the Home PC the network is called Network 2.

I want it to be the Homegroup or Work Group but cannot seem to make this happen.

Any suggestions please?

A:How do I reset my network paths

If I take it you want to print on the main PC from the other two ? I have a similar situation and set it up giving the main PC a fixed IP and then when adding the printer to the other two I used the local port method i.e \\fixed IP address\printer share name, having initially shared the main printer - you will need to install the printer driver on the remote systems. My main PC is ethernet and all the others are wireless.

Hope this is of help.

3 more replies
Answer Match 39.9%

How do you get to see the full path rather than have part of it cut off?
 

A:Seeing full drive paths

Take a look here:
http://www.ehow.com/how_2073275_display-files-complete-path-windows.html
 

3 more replies
Answer Match 39.9%

Hi guys.
I've just tried to use WinMX and found that it is showing the full paths as to where files are stored on the users' HDs.

Can I turn this off? It makes it really difficult to see the file you're looking for, with all this C:\My Documents\My Music\..... crap at the front.

Thanks.

Gram
 

A:[SOLVED] WinMX paths??

Hiya

Go to the Search page. Then, look for a button that says:

Show Full Paths. Press that, and the paths should dissapear

Regards

eddie
 

3 more replies
Answer Match 39.9%

Will the Windows Vista Upgrade path allow me to upgrade from 64 bit Home Premium to 32 bit Ultimate? I need to do this to use my legacy software without re-installing everything.
 

A:Vista upgrade paths

The last that I read, going from 32 to 64 required a CLEAN install. Based on that I would think that it would be the same for 64 to 32.
 

1 more replies
Answer Match 39.9%

Firstly, context: My student edition of Autodesk Maya was not working (something about the license being invalid or 'not found', and so when I searched for the error message online, a solution was to go into Environments and Paths, and replace/edit or add one for C:/Autodesk. It didn't work, and I ended up just uninstalling and reinstalling the program manually for it to work.
However, apparently I screwed around really badly in there, because now important things won't open, such as my MalwareBytes program. When I try, a window will popup and say this:
"C:\Program Files (x86)\Malwarebytes Anti-Malware\mbam.exe
The system could not find the environment option that was entered."
So, naturally, I try to find/open the Environments and Paths thing again, right? Nope. I can't open that either:
"Windows cannot find '%windir%\system32\SystemPropertiesAdvanced.exe'. Make sure you typed the name correctly, and then try again."
Even though I typed 'Environment' in my search bar to find it.
Then recently, Origin tried to install an update on my laptop, but it couldn't find the ProgramFiles, and so there was an error in installation. As a result of this, Chrome is not opening up immediately when I click it. It waits about five-six minutes after I've clicked it. I think it's what caused it, because it didn't do it before yesterday, when I tried to install the update.
So basically: how can I fix this despite knowing little to nothing about computers? How can I go into the Environments with... Read more

More replies
Answer Match 39.9%

I can ping by name or IP address, but trying to connect via
\\name or \\ipaddress fails. IP v6 has been disabled on the adapter.  The error message is: 
\\share is not accessible.  You might not have permission to use this network resource.  Contact the administrator of this server to find out if you have access permissions.  A specified logon session does not exist. 
It may have already been terminated.

Thanks for helping!

More replies
Answer Match 39.9%

after i run winaso registry cleaner/optimizer i get a messeage that i need to delte invalid files path

how do i do that ??????????

A:invalid file paths ???

Do yourself a favor, and if a registry cleaner offers to do something you don't understand, decline. It's far easier to clean the system to death than to actually fix something with a registry cleaner.

1 more replies
Answer Match 39.9%

Hello,

A little background first.

I have a shortwave radio that is of a new type where a lot of the functions such as filters, etc. is done via software that resides on the PC.

The radio is mfg. by the WINRADIO company.
The model of the radio is a G31 DDC

After playing with the radio, it automatically Saves the frequencies that you have listened to, and puts them into Memory to be able to recall them later.
The file that it creates is called "User Memory"..

I seem to have the User Memory File in the right place, I think, but the "path" to get there seems to be different.

I have one path of:
Libraries/ Documents/ WINRADIO/ G31 DDC/ User Memory

And another path of:
C:/ Users/ Bob/ My Documents/ WINRADIO/ G31 DDC/ User Memory

They both seem to lead to the correct file of User Memory.

a. My main question: Is there really only one file of User Memory, but two different ways or paths to get to it ?

b. What's with Libraries; I've never set that up ? What are they ?


c. Notice that one path has My "Documents", and the other just "Documents".

If anyone could explain this for me, I would be most appreciative.

Much thanks,
Bob

A:Two Paths To The Same File Question ?

A Library doesn’t contain files, but provides a single aggregated view of multiple folders and their contents.

These links may help:

Libraries - Personal and Public User Folders

http://msdn.microsoft.com/en-us/magazine/dd861346.aspx

Windows 7 Libraries: Frequently Asked Questions

http://technet.microsoft.com/en-gb/l...33(WS.10).aspx

2 more replies
Answer Match 39.9%

Since a picture is worth 1000 words....



I can't figure out how to edit booloader paths.

I had the triple boot working- 7, vista, WUBI ubuntu. Then I installed Snow Leopard and tried to add it in via easyBCD.....and all hades broke loose.

Anybody know how to fix? And how to actually set OSX to boot from windows, since there's no drive letter?

A:Edit Bootloader Paths

Open an elevated command prompt in Windows 7

IMPORTANT: make a backup of your bcd file first. To do that, type:


Quote:




bcdedit /export C:\SAVEDBCD




For Vista:

Quote:




bcdedit /set {*insert here*} device partition=F:




* insert the Windows vista BCD ID, too small for me to read (take out the *'s)

ok, Vista should be working now, please test it to make sure

For Ubuntu: - optional; this will rename "nst Linux Loader" to "Wubi Ubuntu"


Quote:




bcdedit /set {*insert here*} description "Wubi Ubuntu"




* insert the "nst Linux Loader" BCD ID, too small for me to read (take out the *'s)

It is getting late, so try those, which should get Vista back on its feet, also go to the elevated cmd and type "bcdedit" please post back the results right-click the cmd prompt and select "mark" then highlight every thing, then post the results. Please copy the results, so i will be able to copy and paste

Also, what is the "EFI snow leopard" partition for???

19 more replies
Answer Match 39.9%

Hi,
We are stuck for the time being using Window Media Player to Rip/Burn/Sync music with. I've set the paths for the ripped music and library to go to a separate partition/drive, but each time the system is reset, WMP resets the paths back to c:\documents\ etc........
Should this be the way things work?
Thanks for your time,
patmac
 

A:WMP Rip and Library Paths Don't Stick

6 more replies
Answer Match 39.9%

So I've been trying to use system file checker, and encountered a problem where it can't repair a file. I found this page detailing how to manually fix the problem:

Use the System File Checker tool to troubleshoot missing or corrupted system files on Windows Vista or on Windows 7

I was fine until step 2, where it says

"For example, type takeown /f E:\windows\system32\extremely_simplified_example.dll"

The problem is, my CBS.log file says stuff like:

Cannot repair member file [l:24{12}]"FWPKCLNT.SYS"
Unable to repair \SystemRoot\WinSXS\Manifests\\[l:24{12}]"FWPKCLNT.SYS"

and I don't know how to translate that into a path to use with the takeown command. I searched for that file using explorer and found a dozen different copies, so I'm not sure which one to replace.

Semi-related questions: Can I just replace them all? I'm planning on using a copy of the file from a similar system that works, is that ok?

Thanks!

A:Help understanding CBS.log file paths

Hello Southbound, and welcome to Seven Forums.

Those instructions there are fine, but just a bit vague. OPTION THREE in the tutorial below can help give you only the SFC results to help make it easier to go through.SFC /SCANNOW Command - System File Checker
Next, the tutorial below can show you how to extract files from your installation disc to replace any listed files that SFC cannot repair.Extract Files from Windows 7 Installation DVD
Before doing anything, please post back and upload your sfcdetails.txt file to see what all may be wrong, and if it any file that cannot be repaired is worth worrying about.Screenshots and Files - Upload and Post in Seven Forums
To help interrupt what it says to know the path:Cannot repair member file [l:24{12}]"FWPKCLNT.SYS"
Unable to repair \SystemRoot\WinSXS\Manifests\\[l:24{12}]"FWPKCLNT.SYS"
The first line says that SFC cannot repair the FWPKCLNT.SYS file.

The second line is the path of the file. "SystemRoot" is a variable "%SystemRoot%" that is actually just a shortcut for "C:\Windows". This leaves you with the file path as:C:\Windows\WinSXS\Manifests\FWPKCLNT.SYS
Doing a search on the C: drive for the listed FWPKCLNT.SYS file would help give you all of it's locations if needed as well.

Hope this helps for now,
Shawn

3 more replies
Answer Match 39.9%

How would I set up Windows 8 so that I can edit the `path` environment variable in a fixed pitch font such as `Console` or `Lucida Console`? I don't want to change the font for other parts of Windows - only where paths are displayed. It seems I've been doing this in a terribly inappropriate font for many years and my tired eyes aren't great for semicolons.

A:change the font for paths

Hi Broiyan,
In windows 7 it was so easy by going to control panel, but now is much harder(you`ll see what i mean):
As Far As i know go to regedit>>>>HKEY_LOCAL_MACHINE>>>>SOFTWARE>>>>Microsoft>>>>Windows NT>>>>Current Vision>>>>FontSubstitues>>>> thats all what i know now i need an MVP like brink to hep you with here.

9 more replies