Over 1 million tech questions and answers.

How to change a macro run on active sheet run on many non-active files in a folder?

Q: How to change a macro run on active sheet run on many non-active files in a folder?

Hi everybody,

I am new here and actually after I checked different contributions, I liked the place, it's really helpful, and I hope to be a permanent member. Well, I am new to VBA, and I just got a macro that runs on active open sheet, then I need to run the same macro, but this time on more than a file/ sheet (actually it's a big number, like 1000+), closed and already saved in a folder. I would pretty appreciate if anyone helps me to add the necessary code ( which will direct the macro to : focus on a specific folder in a specific location (e.g. E:\myfolder) , then run on every excel file in that folder, and to save every file before close , doing that until the last file in that folder .. that's it .. Any help?

Many thanks
Jim

Read other answers
RELEVANCY SCORE 200
Preferred Solution: How to change a macro run on active sheet run on many non-active files in a folder?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 108.4

What is the macro to print out an active sheet in excel? What I am wanting to do is run a report that will update info and print it out from a different sheet in the same workbook.
 

A:Solved: print active sheet macro in excel

Worksheets(1).PrintOut where 1 is the index number of the sheet

or

Sheets("Sheet1").PrintOut

or

ActiveSheet.PrintOut

Rollin
 

Read other 1 answers
RELEVANCY SCORE 107.2

Hi

I am using excel 2003 (version: 11.8341.8341) SP3 and created a macro to rename the active sheet:
Code:
Sub renamesheets()
Dim activesheet As String
If activesheet = "[B]Sheet01[/B]" Then
Set Sheets("[B]Sheet01[/B]").Name = "[B]qryOfficeNetForeign[/B]"
Application.ScreenUpdating = True
Else: End If
End Sub
SO the active sheetname is: Sheet01 and should be renamed to qryOfficeNetForeign.

This code is not working I am wondering why...

Thanks,
Wouter
 

A:Solved: macro to rename active sheet in excel 2003

You don't need the SET keyword.
Code:
If ActiveSheet.Name = "Sheet01" Then
ActiveSheet.Name = "qryOfficeNetForeign"
End If
or
Code:
If ActiveSheet.Name = "Sheet01" Then
Sheets("Sheet01").Name = "qryOfficeNetForeign"
End If

Regards,
Rollin
 

Read other 2 answers
RELEVANCY SCORE 107.2

Hello,

So I am trying to figure out a macro that will allow the user to click a button and return to the last active sheet.

Basically why I need this is because I have 2 separate interfaces that have links that go to the same set of sheets. Based on what interface you are using (quick or advanced) I want the "return to home" link to go back to the interface that you were previously on.

I am imagining something like If(lastactivesheet=1,link to interface1), if (lastactivesheet=2, link to interface2) else (link to interface1)

I am not great with programming so any help would be much appreciated
 

A:Solved: Easy Excel Macro help, return to last active sheet

Hi,
Check this link. It may answer your question.
http://forums.techguy.org/business-applications/546347-excel-macro-previous-worksheet-easy.html
 

Read other 3 answers
RELEVANCY SCORE 97.6

I'm trying to run an Excel 2007 macro from Access 2007, when I get to the point where I want the macro stored in the active workbook I'm getting the following run-time error: run-time error '91' object variable or with block variable not set . It won't run the macro at all. I would greatly appreciate it if someone could help me fix my code so the macro will run. The code is listed below; step 10 is where I get the error.
Code:
Option Compare Database
Sub GetJournal_Entry_Data_transfer_to_Excel()
'Step 1: Declare your Variables
Dim MyConnect As String
Dim MyRecordset As ADODB.Recordset
Dim MyQueryDef As DAO.QueryDef
Dim MyDatabase As DAO.Database
Dim MySQL As String
Dim MyRange As String
Dim s As String


Dim Db As Database
Dim xl As Excel.Application
Set xl = CreateObject("Excel.Application")
Dim xlwkbk As Excel.Workbook
'Dim xlworkbk As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim i As Integer


'Step 2:Declare your connection string
MyConnect = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info = False;Data Source= P:\FINANCE\Balance Sheet\Inventory\Project TAN\Project TAN.accdb; User ID = Admin;"

'Step 3: Build Your SQL Statement
MySQL = "Select* From [mtb-TantasticJE's]Where [mtb-TantasticJE's].[Dscrptn_Text]='Culls_Stat34'and [mtb-TantasticJE's].[Co_Code]='1381'"

'Step 4: Instantiate and specify your recordset
... Read more

A:Access 2007 VB code to run Excel 2007 macro in active sheet

Read other 7 answers
RELEVANCY SCORE 94.4

Hi All,
I found an old post (http://forums.techguy.org/business-applications/632779-selecting-previously-active-sheet.html) which is exactly the same issue I'm having...
...however the thread starter said that they managed to sort but didn't explain how! A little frustrating...I've search for similar issue but couldn't find one so sorry if this has been covered elsewhere.
Anyway in short, I have an interactive dashboard whereby it only shows one worksheet at a time both for aesthetic and functionality reasons. A user moves through the workbook via buttons. A number of worksheets may lead to one worksheet or visa-versa. Because of this I'd like a macro that when the user clicks the 'Back' button they are returned to the last active page they were on but hides the page they have just come from, so still keeping the one worksheet format.
Currently I'm writing a separate code for going back to a particular sheet, laborious considering I have 60+ sheets (and counting). Plus I intend to use this dashboard format for other uses in the future so having a catch-all macro to go back would be very useful.
Help much appreciated.
Thanks!
 

A:Solved: VBA: Select previously active sheet and hide current sheet

Read other 15 answers
RELEVANCY SCORE 83.2

select row in sheet1, gather data, select sheet2 & paste gathered data.

Problem is how to update a cell in the active row of sheet1 without having to goback and select sheet1
Just update a cell in sheet1 whilst staying in sheet2

I tried
Sheets("newquick").Application.WorksheetFunction.ActiveCell.EntireRow.Cells(1, 71) = 1
but no luck

It would not be the same row in sheet1 all the time.

Can row number be used somehow?
 

A:Solved: updating cell in active row on another sheet

Read other 6 answers
RELEVANCY SCORE 83.2

[Firefytr: sorry! didn't intend to go against forum etiquette. ]

I want to be able to go back to the previously active sheet by using a commandbutton. I've got the following code:

In a standard module:

Code:
Public strLastSheet As String
Sub GotoLastSheet()
On Error Resume Next
ThisWorkbook.Sheets(strLastSheet).Activate
End Sub
Then in the ThisWorkbook module:

Code:
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
strLastSheet = Sh.Name
End Sub
What do I need to add if I want to automatically hide the active
sheet before going to the previously active sheet? And what do I need
to add to activate the previously active sheet if that is hidden?

Thanks

cavasta
 

A:Solved: Selecting the previously active sheet

Read other 8 answers
RELEVANCY SCORE 82.4

The active desktop I have is an excel file that has been saved as an html. How do you make it such that the active desktop automatically refreshes every half hour? THe excel sheet itself is already programmed to update itself, but I need the active desktop to update in order to take the excel updates into account does anyone know how I can do this?

Any help would be appreciated.
 

Read other answers
RELEVANCY SCORE 81.6

Hi all

Here's a fairly simple one that's eluding me.

1) My workbook has 3 sheets (sheet1, sheet2, sheet3)
2) Each sheet has a command button which, when clicked, activates userform1.
3) Userform1 shows a series of options, with each option activated by a command button.
4) One of the options on userform1 is called 'cancel'. When clicked it unloads the userform:
<Code
Private Sub CancelButton_Click()
Unload Me
End Sub
Code ends>

Here's what I'm after:

If sheet1 is the active sheet when the cancel button is clicked, I want userform2 to automatically show. I only want this to happen on sheet1. If the cancel button is clicked when sheet2 or sheet3 is the active sheet, I just want userform to unload. What do I need to add to my code to enable this to happen?

Thanks

cavasta
 

A:Solved: Load Excel userform when specific sheet is active

Hi there, welcome!

You could use something like this ...
Code:
Private Sub CancelButton_Click()
If ActiveSheet.Name = "Sheet1" Then
Me.Hide
Load UserForm2
UserForm2.Show
End If
Unload Me
End Sub
HTH
 

Read other 2 answers
RELEVANCY SCORE 77.2

Hello, hopefully you guys can help me out. I made a work book to stream line the paper work in my lab. This work book has all the forms in together and uses a master data sheet to auto populate the fields in the various forms. There is one big problem, in order to be effective as a time saver each sheet will need to be saved to its a specific directory.

Here is what I am looking for: I would like a button on each sheet that will save the active sheet to the correct folder (the file path of the folder is typed into a cell on the sheet). Each file needs to be named according to the data entered into certain cells. For instance, A40 G3 B5 would come out to J000245 VCO-8004.007 1494601.xlsx. I also need the "save" button to be deleted in the saved file.

This code that I found on an old thread comes very close to doing what I need it to do:

Code:
Public Sub SaveToDir()
'
Dim wbk As Workbook
'
CDir = ActiveWorkbook.Path
'
SaveDir = CDir & "\" & ActiveSheet.Range("A1")
'
'check to see if Dir exists if not create it. Could also abort if the Dir should exist
If Len(Dir(SaveDir, vbDirectory)) = 0 Then
MkDir SaveDir
End If
'
'Checks to see if the Date cell is in date format
If IsDate(ActiveSheet.Range("B1")) Then
SaveName = ActiveSheet.Range("A1") & "_" & Application.Text(ActiveSheet.Range("B1"), "DD-MMM-YYYY") & ".xlsx"

Else
SaveName = Acti... Read more

A:Macro to save sheet to a specific folder and rename

Forgot to mention that this is on Excel 2010
 

Read other 1 answers
RELEVANCY SCORE 77.2

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?
 

Read other 3 answers
RELEVANCY SCORE 76.4

Hi,
I've been fighting with some sort of redirect virus. Checked my computer with Malwarebates in Safe MOde, Normal Mode, etc. It did find some viruses but removed them and nothing is present anymore. I also checked my comp with BitDefender online scanner, SuperAntiSpyware, HijackTHis. They don't find any viruses. Computer works fast, although aftre all this checking and removal I found that sometimes when I click two windows too fast it locks and I have to reboot it by reset button.
Now the annoying part is that when I do Google search it still redirects me to various random sites. I also found that when I disable active scripting it does not do that, but then I cannot view YOuTube movies, etc.
Is ther a way to analyze and search for scripts that cause this. I assume it's just some stupid script that gets activated when I'm on line, because none of the AV programs I use finds any viruses anymore.
Any help would be appreciated
Thanks

A:Google redirect? No viruses found but active when active scripting enabled

Could you please post the log files from all the programs you ran? (MBAM and SUPERantispyware) Do NOT post the Hijackthis log.

Read other 5 answers
RELEVANCY SCORE 75.6

OK, I am trying to pass a variable to either a web query or link. So for example, let's say I am trying to pass a variable to a web address that runs on a variable. For example, if you replace the last 3 letters in the following line with the one corresponding with a particular team, then you go to that teams clubhouse:

http://sports.espn.go.com/nfl/clubhouse?team=nyg

replace "nyg" with "phi" and you go to the Eagles clubhouse rather than the Giants.

So what I want to do is lets say someone has their cursor on a cell that has the teams symbol--like "phi" is in cell "B3". I want to be able to have someone execute a macro or a web query that passes that "value" to the query or macro. Now the value in "B3" may be relative to another cel. In othe words, "B3" may actually be "+D24", which returns what's in D24 so I want it to use the actual value in the cell, not the formula.

Here is a macro that I found that kind of does what I want, but its for saving a spreadsheet. I only use it as an example for reference.

Sub SaveSheet()
'error trap
On Error GoTo Etrap

Dim MyCell
MyCell = ActiveCell.Value

'ask user to save
If MsgBox("Save new workbook as " & CurDir & "\" & MyCell & ".xls?", vbYesNo) = vbNo Then
Exit Sub
End If

'check value of activecell
If MyCell = "" Then
MsgBox "Please check the Cell Value", vbIn... Read more

A:Need Excel Macro to pass active cell value to web Query or Link

Hi Chris.

Re: "pass a variable to either a web query or link" -- "query" in Excel is something different from what I think you mean, so I'll stick will "link".

See the attached. The formula in B3 links to D23; D24 is the "generic" URL.

Clicking the link in D25 should take you to http://sports.espn.go.com/nfl/clubhouse?team=phi. Now change D23 to nyg and run the macro.

(note: B3 doesn't have to be selected for the code to run -- not sure about the "if the person accidentally is on the wrong cell" bit, but we can come back to that)
 

Read other 2 answers
RELEVANCY SCORE 75.2

Hi All,

My Application that is active and  40 users are using that, It was working fine on windows xp , but when we installed Windows 7 on users machine , they are facing issues that after few minutes their icon is disappearing and once we are going to check from
taskbar>>customize  and try to change the dropdown of the application it is showing "This
notification icon is not currently active. It will be shown next time it becomes active"

I tried almost all solutions that are on internet , deleting registry/scan system etc. but problem is still there.



Please help me on this.



Thanks,

Afzal

Read other answers
RELEVANCY SCORE 75.2

Hello, I am trying to find out what kind of network connectivity is typically required between 2 Active-Active data centers? (Keeping in mind the global traffic management would be required between the 2 sites and all the traffic would typically be coming to Site A first though Akamai).

We currently have a GigE (provided by InterNap) coming to our data center.

Thanks,

Sam.
 

Read other answers
RELEVANCY SCORE 74.4

That is my problem as stated above.

Henry

A:Can't change am/pm in settings, update,change active hours.

Hello Henry,

You should be able to click/tap on the arrows above/below AM/PM, or click on AM or PM to select one like below.

Windows Update Active Hours - Change in Windows 10

Read other answers
RELEVANCY SCORE 74.4
RELEVANCY SCORE 74

When I have any programs open that have gone to the taskbar because another program opened... How do I get any of those programs to activate again from taskbar?
This has driven me nuts since I got Win 10.
I click on the program icon on taskbar, and nothing happens. Only way I can get program active again is to right click, and start another instance of it.
I hope I'm making this clear. Cuz I really want to know how to get around this.
Thanks

A:active programs on taskbar - how do you make them 'active' again

See if this tutorial can hep...................
How to Clear and Reset the Thumbnail Cache in Windows 10
Thumbnail Cache - Clear and Reset in Windows 10

Please use Option Two.
It's easiest and fastest.

And, just in case................
How to Rebuild the Icon Cache in Windows 10
Icon Cache - Rebuild in Windows 10

Read other 3 answers
RELEVANCY SCORE 72.8

Hi,

I am trying to classify and code my inventory items in excel.
My classification sheet contains data in columns which I would like to copy to rows in another excel sheet.
Here is the sample data in ACMOTORS-ATTRIBUTES sheet:

The above sheet has to be converted to columns as in Item_Classificatios_Form sheet :

Can anybody assist me in writing a macro for the same.

Thanks,
mihaufo
 

A:Solved: Excel Macro to convert Rows from one sheet to columns in another sheet

Read other 8 answers
RELEVANCY SCORE 72.8

I need to copy n number of rows from a sheet in my local machine to a sheet in fileserver.
My requirement is - if I select last 2 rows in the sheet in my local machine I need the rows to be copied after the first blank cell in the sheet in fileserver.
Also it would be helpful if the macro code is only in the local sheet and not in the fileserver sheet.

I am a newbie to macros pls help....
 

Read other answers
RELEVANCY SCORE 72.4

My ultimate goal is to eliminate drive C altogether. Win Xp is installed on C ,Win 7 is installed on E, and I would like to set e as the active partition, remove all the files from C and uninstall xp. Please help me out!
I have attached a screenshot of my Disk Management.

A:Please help me change the active partition

Welcome to Windows Seven Forums.

Please read this tutorial on how to use Partition Wizard: Partition Wizard : Use the Bootable CD

However, before you go down this road I would clean up your current disk layout.

Personally, I would wipe the hard drive completely and clean install Windows 7. The reason I suggest this is because it is recognised as best practice to install your operating system to a primary drive rather than a logical volume.

During the install, Windows will want to create a system reserved partition of 100 MB, which will hold the master boot record and will become the active partition.

Windows will then be installed and will automatically give the partition it is installed on drive letter C.

Read other 9 answers
RELEVANCY SCORE 72.4

I basically want to swap the C: Drive for F:

Windows is installed on both right now, but I want to make F the main system/boot and active drive going forward

A:How to change System and Active HDD

Did you install Windows to the F: drive with the now C: drive installed?

Go into the BIOS and change the boot order to have the F: drive boot first.

It will then become C:

Read other 9 answers
RELEVANCY SCORE 72.4

I recently bought the Lenovo Yoga 920 and have been using my Active Pen 2 for only a day's worth or writing after first setting it up a couple weeks ago. It already says the battery is low. -Is there a way to turn Active Pen 2 off between uses? Is this recommended? Does Active Pen 2 use a lot of battery even when I'm not using it? -How often should I expect to have to change the tip? Also, I've found the guide mentioning how to change it but didn't realize the circle piece was needed. Is there another way to change the tip with a common item, or do I need to order something special? Where can I buy replacement tips when needed? 

A:Active Pen 2 turn off and tip change?

Hi confusedkaleigh,
 
Welcome to the Community Forums.
 
I don't think that there is any of button to turn off the pen similar to the discussion here. Aside from removing the battery, you can keep off any pressure from the tip of the battery that consumes the battery in between uses. This would give less battery consumption.
 
There is not much guideline on replacing the tip and not much also on separate tips/nibs sold separately (no separate part number to order ) although I was able to check on a discussion here for compatible Wacom Bamboo Smart 2-in-1 nibs that may be an option. Using the circle piece or similar tools may be needed to safely replace such part.
 
I hope this helps answer your query.
 
Regards

Read other 1 answers
RELEVANCY SCORE 71.6

Hi,

I need to write a macro which has to automatically fill the data written in sheet1 to sheet3.This should happen row wise.

For example if the data entered in A3 of sheet1 then this data should automatically get entered in A7 of sheet 3 upon a button press.

Advance thanks for your replies.
Sandesh K R
 

A:Macro to insert data entered in one sheet to another sheet

Isn't this just a copy and paste?
You could record a macro and then edit it
 

Read other 1 answers
RELEVANCY SCORE 71.6

Hi

I am looking for help on VBA to unhide a specific sheet to enable the macro to run, then once complete to rehide the sheet.

Code I have so far is as follows:

Application.ScreenUpdating = False
Sheets("IRIS_JNL_W2.1").Select
Range("A2:C500").Delete

Sheets("IRIS_JNL_W2.1").Select
Range("A1").Select
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[3]-'W2-1'!R[9]C[4]"
Range("B1").Select
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[1]"
Range("C1").Select
ActiveCell.FormulaR1C1 = "=""W2-1 - Jnl No.""&'W2-1'!R[9]C[-2]"
Range("A2").Select
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[3]-'W2-1'!R[9]C[4]"
Range("B2").Select
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[1]"
Range("C2").Select
ActiveCell.FormulaR1C1 = _
"=IF('W2-1'!R[9]C[-2]="""",IRIS_JNL_W2.1!R[-1]C,""W2.1 - Jnl No.""&'W2-1'!R[9]C[-2])"
Range("A2:C2").Select
Selection.AutoFill Destination:=Range("A2:C500"), Type:=xlFillDefault
Range("A2:C500").Select
Last = Cells(Rows.Count, "A").End(xlUp).Row
For i = Last To 1 Step -1
If (Cells(i, "A").Value) = "0" Then
Cells(i, "A").EntireRow.Delete
End If
Next i
Columns("A:C").Select
Selection.Copy
Selection.PasteSpecia... Read more

A:Solved: Unhide sheet, to run macro, then hide sheet

to hide
worksheets ("IRIS_JNL_W2.1").Visible=False

to show
worksheets ("IRIS_JNL_W2.1").Visible=True

Peace be upon you
 

Read other 1 answers
RELEVANCY SCORE 71.6

it is replying as in a manner
system error 5 occured

Read other answers
RELEVANCY SCORE 71.6

For months now, my on-board gpu has been making loud sounds while it spins, and getting as hot as 92C even on old games and even with a cooling pad. I've cleaned it out several times and checked to see if the fan is properly seated. I've also uninstalled drivers (with DDU), reinstalled multiple versions of nvidia, and downclocked the gpu with Nvidia inspector and MSI, all to no avail. Its gotten so bad now that the card only shows up on nvidia control panel on one of three restarts. I'm pretty sure its a hardware problem, and taking the laptop to lenovo for repairs is not an option where I live. As far as I know, the ultrabay gpu works fine still, so is it possible to set it as the active processor while disabling the faulty on board gpu? My web search so far hasn't turned up anything so this is my last resort, more or less.

A:Y510P SLI Possible to change active GPU to Ultrabay?

Hi kay6579 ,
 
Greeting.
 
Similar query was discussed here.
" The main GPU has to work in order for the Ultrabay GPU to support it during SLI gaming."
 
I don't think that the BIOS would offer this option but maybe you can set a program/ apps to run on specific GPU instead specially if you have re applied thermal paste and replaced the fan itself.
 
Hope this helps answer your query.
 
Regards

Read other 1 answers
RELEVANCY SCORE 71.6

I finally have installed Firefox 2. I want to change the color of the active tab because there isn't enough contrast between it and the inactive tabs. How do I do this? I figure that I start in about:config I tried changing the color code for browser.active_color, but that had no effect on the tab color, or anything else that I have been able to determine.

Thanks,

Orange Blossom

A:Firefox Change Active Tab Color

Your theme is probably what does that. Its pretty much up to you to go and change the theme if you want it to be darker. I'd just look for a new theme on the main firefox website. You'll probably find one that you like better anyways.Link for themes below...https://addons.mozilla.org/en-US/firefox/browse/type:2

Read other 6 answers
RELEVANCY SCORE 71.6

Wow... it's been a long time since I've posted here. Hope everyone is well.

Question about Excel. Is there a way -- without having to program -- to change the color of the active cell? When I do a search, for example, it is really hard sometimes to locate where the cursor has landed (the cell that matches search criteria). If I could change the focus to another color, it would be nice....
 

Read other answers
RELEVANCY SCORE 71.6

Hi, I just re-installed Windows and when I go into the Disk Management I notice that my secondary HDD which is split in 3 partitions has the first partition marked as "System, Active, Primary Partition" while the other 2 partitions only say "Primary Partition".

How do I change the first partition so that it too only says "Primary Partition"? At first there was no Drive Letter assigned to the first partition and I suspect that has to do with its settings being different than the other two..

Can someone please assist?

A:How do i change my second drive from being System and Active?

Hello orlando,

For now, please go ahead and post a screenshot showing all of your Disk Management to help see what the issue may be.

Disk Management - Post a Screen Capture Image

Read other 4 answers
RELEVANCY SCORE 71.6

Ever do anything stooopid? I seem to have a run going.

In switching over from XP to 7 I found myself also buying almost all new components, except hard drives. Due to a number of events that no one would believe humanly possible, I managed to establish my "C:" and "D:" drives on hard drive 1, whereas hard drive 0 is a bunch of free space. The computer boots up to W7 on "C:" on HD 1.

I want to switch cables on the SATA drives and then designate the new HD0 (which was HD1) as the primary active partition, but as we all know, I can't just switch cables as then the computer does not know to boot off HD0.

What the heck do I do to accomplish this?

A:Change active primary drive help please!

Please post a screenshot of your full Disk Management map using the Snipping Tool in Start>Programs menu, attaching it using paper clip in reply box.

Your description is not at all clear, but here are some options based on what I can interpret:

If you have System Active Windows 7 partition on Disk1 right now and you want it on Disk0, then Win7 already owns the boot and can be wherever it wants to be. Just swap the cables and make sure Disk0 is HD set to boot first in BIOS (after DVD).

If Disk0 somehow got marked Active then you need to unplug it, plug its cable into the other drive, boot into Window 7 installer Repair console and run Startup Repair 3 times.

We can say for sure after seeing the Disk Mgmt map

Read other 9 answers
RELEVANCY SCORE 71.2

I had an external HDD put in as an external HDD, but for some reason it is marked as active (when connected with my normal HDDs windows will not boot), can I make it inactive WITHOUT loosing all the data (It has only my movie collection ripped from DVD on it) nothing else. I only found out the other day when I replaced my PSU with a new one, and windows would not boot until I disconnected it. (after having it connected without a problem for about 2 years).

A:Make an Active drive non-active

In a standard Windows PC, the active partition would be C, or System Reserved if you have that partition. Do you have both of those partitions and is either of them marked "active"?

The active flag has nothing to do with data.

A screen shot of Windows Disk Management would help.

Read other 4 answers
RELEVANCY SCORE 71.2

So out of the box, my Yoga 920 was missing the batteries and tips for the Active Pen 2 but I got an empty pen.  So Lenovo ships me a new pen but this one is a Lenovo Active Pen although it does list 4096 levels of pressure.  What's the difference between the pens and is the original compatible with the Yoga 920?I have it still in the box... Thanks.

Read other answers
RELEVANCY SCORE 71.2

Hello Community members! I wish to buy lenovo Active pen for my Yoga 720, but i am not clear about the difference between Active pen 1 & Active pen 2. Can anyone please provide a detail comparision of both these pens?

Read other answers
RELEVANCY SCORE 70.8

I have been doing some work at a Library and one of the tasks is setting up Active Directory. I have never setup Folder Redirection before, but I am literally doing it exactly how everyone has told me to do it and how every page online explains it has to be done, yet when a user logs on, from any machine, even the AD server itself Folder Redirection does not work. Nothing happens at all.

The main task is to get My Document's for each user to be placed at \\SERVER\user\username\

In the settings I have set the Folder Redirection for:
\\SERVER\user\%username%

Now, I am 99.9% sure that I am setting this up correctly, but I think I am missing something else that needs to be done possibly?



Also, another thing is I have created a Visual Basic script which is executed when a user log's on. The script works perfectly when any user (in the Lib_Staff group) log's on from the AD server itself, but not from ANY other computer. Including 98, and XP machines. Neither execute the script. If the script is ran manually from any machine it works completely fine, but the script will not execute automatically at logon like it should.



What am I missing? Yes, the server has been rebooted.
 

A:Folder Redirection in Active Directory

Can't help you with the folder redirection :\

As for the logon scrpt, I assume the netlogon share is set up properly and the script placed in the right directory. It may be that running remote vbs scripts is disabled. Try with a simple batch file as the login script to eliminate problems with server-network-client setup.
 

Read other 4 answers
RELEVANCY SCORE 70.8

A coworker recently got married and I need to change her name and email in Active Directory. We are running Standard Server 2003, and Exchange 2003. Can anyone tell me the correct steps to follow?
 

Read other answers
RELEVANCY SCORE 70.8

I installed Windows 7 ultimate and had my 1 Tb harddisk divided in a 50 GB partition and another (the rest)

I wanted to install Windows on the 50Gb but now it's installed on the other partition

How can I change the active & boot stuff to the other partition?

A:How to change active partion in Windows 7 Ultimate

Are you wanting to move the whole OS, or just the boot files?

Read other 3 answers
RELEVANCY SCORE 70

1. span element inside a div element.
2. div's Background color will be changed by clicking either on div or span.
3. This is working in all browsers except IE11. 
Please find the code snippet for this,

<!DOCTYPE html>
<html>

<head>
<title>IE11 :active issue</title>
<style>
.parent {}

.child {
width: 100px;
pointer-events: none;
background-color: aqua;
}

.parent:active {
background-color: red;
}

.child:active {
background-color: red;
}
</style>
</head>

<body>
<div class="parent">
<span class="child">Click Me</span>
</div>
</body>

</html>



*please suggest me any work around for this. 

Read other answers
RELEVANCY SCORE 70

Hello, I have a problem...
I want to completely REMOVE the Windows XP installation. Windows 7 is installed in my physical drive C, while Windows XP is installed in a completely different drive (E) not a different partition but another HD.
The bootmngr.exe file and the boot folder both are located in E, i tried to copy that file and folder to C, set C as active, and E as inactive, but it didnt work and i could not boot. I cannot start the system in XP, since i changed the processor and motherboard and i get a BSOD.

Is there any way (easy would be best) to completely remove the XP files, and transfer the bootmngr.exe and folder to C: so that my Windows 7 starts as a clean installation without formatting and reinstalling again?

I used the BCDEdit and this is what i get:



Administrador de arranque de Windows
----------------------------------
Identificador {bootmgr}
device partition=E:
description Windows Boot Manager
locale es-ES
inherit {globalsettings}
default {current}
resumeobject {2c9da345-07ca-11df-92b6-971cbbda1734}
displayorder {ntldr}
{current}
toolsdisplayorder {memdiag}
timeout 0

Cargador del SO Windows heredado
--------------------------------------------------
Identificador {ntldr}
device partition=E:
path \ntldr
description Versi?n anterior de Windows

Cargador de arranque de Windows
-----------------------------
Identificador {current}
device partition=C:
path \Windows\system32\winload.exe
description Windows 7
locale es-... Read more

Read other answers
RELEVANCY SCORE 70

In Microsoft Explorer 7, if I click on "Tools" and then on "Internet" I get a message that says, "This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator."

Acccchhhhhh!!!! I AM MY SYSTEM ADMINISTRATOR!!! When I contact myself I have no answer for me. In fact, I'm not only the system administrator ... I am the only user on this computer.

Any ideas anybody? What I hope to accomplish is to change my Active X Controls so that I can install the printer program of a site that will allow me to print grocery coupons. Gotta save every penny I can, ya know ... retirement funds don't support me in the manner of which I have become accustomed.

Thanks much,
Darlene
 

Read other answers
RELEVANCY SCORE 70

Hello,  I have just installed Windows 7 RC 7100.  I have a netgear fa311 network card, which it did not automatically install.  I manually installed the drivbers and now it has identified my home network as a "Public network" so I can not connect to the internet.  I can't seem to find any way to change this to the "Home network".  Can anyone help please?

A:Cannot change active network from public to home in Windows 7

Hello Darene, Well, I have now given up on my previos two nics.  This is obviously a driver issue as I have now installed a 3Com and everything works fine!  If you want me to do any future driver testing for these cards just drop me an email.  Thanks for all your input guys.

Read other 70 answers
RELEVANCY SCORE 70

How do I change the way active/open taskbar icons look? I want to get rid of the blurred box around the icons and have a different effect such as a small indicator light under them to let me know they're open. Is that possible?

A:Change the way active/open taskbar icons look in Windows 7

I use classic theme though that sounds like a great idea... I doubt this can be done via any ico file or what have you. Would require a custom theme or third party application. I found another thread on here that asked the question. This is apparently controlled by DWM, and the closest thing you can do is a use a coloured theme and the blur will be a different shade of what ever colour you chose. The last thread was in mention of modifying the contrast here: How to change colors icons from the taskbar ?

Read other 1 answers
RELEVANCY SCORE 70

I'm running an iMac 233 MHz 64 megs ram and OS 8.6.
I have over 169 items in my fonts folder inside the systems folder. Why are they not available in my applications? (Photoshop, Illustrator, QuarkX and Pagemaker) I don't even have access to standard fonts like Times and Helvetica. I don't understand. I even copied fonts straight from Illustrator's program CD disk and they are not active either??

I'm guessing I can re-install all my applications and that will fix the problem? But I'm leary, will OS 8.6 just install a 2nd program rather than re-installing over old applications?

Also, does anyone know a free download for Netscape Nav. 6.0?
Please help asap!
Send all answers to my email [email protected]

Thanks
T
 

Read other answers
RELEVANCY SCORE 70

Hello

I've been using W7 now for couple of days and one thing I found really much disturbing with its explore.
In Vista, while scrolling down at left pane of explorer and double-clicking folder I want to expand, it will automatically move to the most top that folder, showing me the list of sub-folders so I can quickly click one I want see content of.
With Windows 7 the folder position goes most down Now that I find really stupid (or I'm stupid because don't know how to change? ) as I need to scroll down all over the way again to see sub-folders.
I've changed all possible settings, but can't find the way to fix
Please, if anyone can tell me how to change that behaviour, before it drives me completely nuts, soo annoying.

A:Active folder position while expanding folders

Have a look in Tutorials, I'm sure there is a solution for you there.

Read other 9 answers
RELEVANCY SCORE 70

Hello,
I hope this is the proper place for this. I've inherited an Active directory domain that is pretty messy, and its now my job to clean it up. I need a tool that I can use to find out what network resources that a security group or user has access to and what kind of access.
I know you can look at each folder's security tab and see the users and groups' access rights, but that is too daunting of a way to do the task when you have hundreds if not thousands of network shares. Unfortunately there is no tab on the user/group properties page in "Active Directory Users & Computers" that shows "Has Access to ..."
Is there a commandline tool, or does someone have a script that can do this?
Any assistance appreciated.
 

Read other answers