Over 1 million tech questions and answers.

Identify which FW rule is responsible for blocking specific data

Q: Identify which FW rule is responsible for blocking specific data

How can I determine exactly what firewall rule is blocking particular data?
I have an application that gets all the way through opening an FTP connection and logging onto the FTP server, but then stalls on mput (the actual upload command), leaving a zero-byte file on the FTP server. The log reveals that the FW is blocking port 20
(the FTP data port) even though it is not blocking port 21 (the command port). That explains why it stalls only when it gets to the actual file upload. Here is a sample DROP line from the log:
2016-03-24 22:19:06 DROP TCP [FTP server address] [Workstation address] 20 49432 60 S 2753606402 0 29200 - - - RECEIVE
I added an explicit TCP Allow rule for remote port 20, and this allowed the process to complete the upload correctly. But then I disabled it for further testing and then re-enabled it--and now the process is again stalling on the FTP data transfer.
I cannot understand is why this process is not blocked on other stations not having explicit port 20 rules. But it seems that it would be most useful to somehow trace all of this to what (rule), explicitly, is blocking port 20 on this workstation and/or
allowing it on other workstations.

Read other answers
Preferred Solution: Identify which FW rule is responsible for blocking specific data

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


how do i setup a rule in outlook 2k3 to sort all mail from a specific domain to a specific folder.

i tried using the "domain".com where you would normally put the persons email using the 'from people or distribution list' to no avail. Also tried "@domain".com

any help appreciated!


A:Outlook 2003 rule for specific domain

Have you tried to filter the incoming messages using the "with specific words in the sender's address" choice? It works for me to sort out e-mails from people at specific companies without having to add new people each time.

Read other 1 answers

Hi to all,

I was directed to post this query here after submitting it on the MS Community forum.

I have searched for related answers but I think I'm using the wrong search words as no specific replies were found.

I have a Windows 7 Ultimate (x86) in a virtual machine in VirtualBox and am using this vm to teach students about basic security on a Windows operating system.  The problem is that when I add a new Deny rule to stop a specific hypothetical
user from using Windows Media Player (wmplayer.exe from Publisher with no exceptions), the rule is also including the Administrators but not in preventing them from running wmplayer.exe but from installing a program or running an executable file such as VirtualBox's
Guest Addons image.  The users are created locally and not on any domains.

I happened to notice this when I logged on the VM using an administrator account and wanted to install the VirtualBox Guest addons.  The error - "This program is blocked by group policy..." popped up.  I found that I can still
run/install and exe if I use the Run as Administrator option from context menu.  But this is tedious :-(

I have also tried adding an allow Path rule with the "*" path to allow administrators free reign but this still does not work.

Can I somehow prevent the rule/s in Applocker from also blocking the Administrators group? I tried adding the default rules to Windows Installer and Script rules but this also b... Read more

A:An Applocker deny rule is also blocking administrators from installing software

this is weird behavior...
1.Have you try to make a rule that would be pointed to the admin account that you use and not just for the built in group?

2.Also have you try to run the executable from different locations? The blocked file path is also using the environment variable "%REMOVABLE%" this could be a problem.

3. Also check these options:
Figure 2: Setting Enforcement Properties Skip Administrators An administrator may want to disallow the running of programs for most users, but allow administrators to run anything. For example, a customer may have a shared machine that multiple users connect
to using Terminal Server. The administrator may want users to be able to run only specific applications on the machine, but allow members of the local administrators group to run anything. To do this, use the Skip Administrators option. If the software restriction
policy is created in a GPO attached to an object in Active Directory, the preferred way to skip administrators is to deny the Apply Group Policy permission on the GPO to a group containing the administrators. This way less network traffic is consumed downloading
GPO settings that do not apply to administrators.
However, software restriction policies defined in Local Security Policy objects have no way to filter based on users. In this case the Skip Administrators option should be used. To turn on Skip Administrators: Select the following option
in the Enforcement Properties dialog box... Read more

Read other 5 answers

I have a problem with Windows Firewall and was hoping to get some expertise help/suggestions on this matter.
I have made a correct exception rule for all network profiles (domain, private,
public) and everything is working as it should and my program running just fine.

However the problem
arises if I pull out my two network cables from the computer and then plug them back in, then the Windows firewall starts to block my packages (checked the firewall log) and my program fails.
The strange thing here is that if I restart my program it starts to work again and the firewall stops blocking
my packages again.
There also is a little strange thing happening, both my network connections are classified as "Domain" but after I pull both cables and
then plugs in both again it's just one connection that will return to the "Domain" classificatgion the other one is stuck in "Identifying" state and therefor stated as "Public", and
it will be stuck on identifying forever and never regain "Domain" classification.However,
this should not matter anyway I think as my firewall rule is set to work on ALL profiles, and when I restart my program it works again even though "Identifying" & "Public" on the connection.

Is there anyone here who is more versed in how security in Windows works?
It is ... Read more

Read other answers

I am not sure if this is a question that belongs here but i dont know where else it would belong. So i was talking to a tech-smart guy about a type of wire i would need... basically what we have now is a y-splitter compatible and used with an ipad, and the splitter has two ends: on for a mic and one for headphones. for the specific thing that i want to do, he said that i would need a y-splitter but instead of an end for a mic and an end for headphones, i would need a y-splitter that both its ends (or three ends, but right now im guessing i really only should ask for two ends) have mics. i dont need an end for headphones, although if there is such a thing that has two mic ends and one headphone end i would like to search that up too. so what i would like to know is, what is the name of this type of "wire" and maybe where would i buy this thing?

Read other answers

Hi, Guys.
Good Day!
Need your assistance on how to determine who re-enabled a certain user AD account in AD via Event Viewer? Please advise.
Thank you in advance!

Read other answers


I have attached a sample excel document
Basically each morning I receive a .txt file and I export it to excel.
I have a macro which deletes blank rows and therefore tidies the file up somewhat as the size is humungous!
There will be approximately 1000 brach i.d.'s on a daily basis within my file, but I have provided a few in the sample excel doc.
Within my attachment I have highlighted a specific branch and the information that comes with it. I only need part of the information (therefore many rows can be deleted within each branch i.d.

Please review the attached sample and keep in mind the following:

1. I need to keep the branch i.d. at the top of each section
2. I really only require the information that relates to "outstanding" and the few subsequent rows beneath

Can someone please assist??? I would be very appreciative

A:Need Help with wriitng Macro/code to rid unwanted data and retain specific data

I think this macro will work for you, though with dates involved, you never know.

BTW, I suggest that next time, Excel related threads should be started in the Business Applications section. You get help there sooner. Maybe better help as well.


Read other 1 answers

How can I block a specific website so that it can no longer by accessed?

A:Blocking A Specific Webiste

Tools>Internet Options>Content>Content Advisor>(enable button)>Approved Sites> Type the address of site and press "never". It should block it now.


Read other 2 answers

how can i block specific ports manually? for instance, in another thread someone mentioned port 135. is this done in the dos window? batch file? internet options? what instructions would i type?

A:blocking a specific port

Read other 13 answers

Yes, I was wondering if anybody could help me. I am somewhat familiar with blocking websites in the host file but I do not want to block the whole website just a profile from being veiwed within the website. The site is http://www.vampirefreaks.com and this is the url of the profile i want to block http://vampirefreaks.com/u/jackofalltrades

Is there any way that I can specifically block just that profile from being veiwed so that my daughter can still use vampirefreaks.com without knowing that I blocked that profile from being veiwed?

A:Blocking A Specific Website

I've never attemped this, but have you tried just putting the whole url in the blocked websites option under internet options?

Read other 1 answers

Hi, firstly apologies if this has already been posted somewhere (a quick search didnt bring anything up).

I was wondering if anybody new a way of blocking access to a specific website, but this doesnt seem to be any ordinary website.

The website in question is www.imperiaonline.org

I have Linksys wireless boradband router(WRT54G), using its built-in "access restrictions" i added the above site but it failed to block access. I entered a second website (www.cheese.com) to block in the same policy and this is blocked, so it is not an mistake in the configuration of the policy.

I then tried blocking access via Internet Explorers restricted access option, this also fails to block access attempts to the formentioned site.

I also tried a search in google.co.uk for the String "imperiaonline", amazingly it times out every time whereas any other search takes under a second for the results to be displayed... which seems a little dodgy to me.

If anyone has any information regarding this site or any suggestions on how i might go about blocking this website or if anyone could test blocking this site on any installed applciations you may use to prove it works, it would be most appreciated.
Its IE6 but it isnt being blocked in Firefox either.



A:Blocking a specific website

I think you have to block imperiaonline.org also because I went there with www.imperiaonline.org and imperiaonline.org so if you blocke the one it just used the other that you did not have blocked.

You could also block the site with your hosts file.
But your need to add both

Also www3.imperiaonline.org wanted to set a cookie so add it too.

Read other 3 answers

Is there a way to block a specific web site. For example, need to block MYSPACE.com for kids...can I block this particular site without installing some bloated software program?

A:BLocking a Specific Site

i am sure there is. but i would not want to give bum advice at this time so instead i post this to give you a bump

Read other 2 answers

I am not sure if this is the correct area for this quesiton. Can someone please help me and give me instructions on how to block a specific IP address with my firewall.

I have been able to access the "exceptions" area that allows certain IP through the firewall, but cannot find how to block a specific address.

Any help will be greatly appreciated.


A:Blocking Specific Ip Address...how Do I Do It!!

Read other 12 answers

There are two websites I want to block my kids from accessing on my computer. I dont want to buy a whole computer "watch guard" software or anything, its not worth it. I use Firefox/IE (firefox more so), and just need to find out how I block these two websites?

A:Solved: Blocking Specific Website

Read other 7 answers

We are tracking a specific real estate website as we are looking to
purchase a home in Phoenix. After you enter this site and find a specific
property you are looking at, there is a SEND button halfway down the page which allows you to send that specific webpage to hotmail email address. We have been doing this for several months.

And then it just stopped working.

I had other people check that webpage and it works for them, they can
send specific webpages back to their email address.

I've been all over Hotmail email security (blocked senders, etc.) and nothing works to solve this.

I then found the below information regarding Microsoft's Smartscreen spam filtering, which appears to me that I have no control over.

I've been working on this for over a week with no resolution. Does anyone
have any idea why MSN Hotmail is blocking this and how I can fix it.

SmartScreen is the spam filtering technology developed and operated by
Microsoft. SmartScreen is built around the technology of machine learning.
SmartScreen's filters are trained to recognize what is spam and what
isn't spam. In short, we filter incoming emails that look like spam. I am
not able to go into any specific details about what these filters
specifically entail, as this would render them useless.
Hotmail/Windows Live Mail limits the number of e-mail messages a
particular IP can send within a time period. Based on an IP's reputation
(built based on various data sources) it is allotted an allowed send... Read more

A:Hotmail Blocking Specific Email

since it looks like it is beyond your control, then it may be time to use another email addres for that specific webpage. If that is too inconvenient, then pick a new free email address that will forward to hotmail.

Read other 3 answers

Oops! I checked my HOSTS file, and the site was listed there, somehow, so now it's working again. I suppose this post was useless then - sorry that I can't delete this.

Read other answers

I'm currently installing an application that requires me to block/unblock specific files/folders.  I'm not sure how to do this.  It doesn't specify a specific antivirus.  Right now the one on my computer is Norton Security Suite.  I looked around and didn't see any feature like that.  Is it common for most antivirus software to do that specified function?

A:blocking specific folders/files

What are you installing, and what folders are being requested to be unlocked?

Read other 3 answers

Hey, firewall only controls 'exceptions', but I'd to make sure a certain program of mine DOES NOT access the Internet. IS there any to to create a 'block list'?

Read other answers

I have a web app at work that I need to access from home. The app is on a specific port and Comodo is blocking it.

I did some searching and added a new rule to Comodo based on what I read but it still isn't working.

A:Comodo is blocking web app on a specific port

Read other 11 answers

The library I work for wishes to create specific user accounts for those who aren't old enough to use social networking sites. We'd like one dedicated account with security measures in place to prevent them from accessing sites like Myspace, Facebook, etc. We log the user in for each session so we could see the patrons birthday on the card and give them the appropriate account.I've yet to run across anything that'd allow me to block access to sites for a specific account. I've found a few that allow an override password but I'd rather have something more hands off. So, if anyone has a suggestion, I'd be greatful.Edit: Moved topic to the more appropriate forum. ~ Animal

A:Blocking Websites For Specific User Accounts.


Read other 1 answers

Hi all!
I have been having issues with third party Windows Store apps. I am running Windows 10 Pro, version 1607. The specific apps in question are Wifi Commander (which I purchased) and Netflix apps, but any third party app I try to install has the same issue. The problem I'm having is that when installing, I get a licensing error, 0xC004C007, and then the installation fails. FYI, this is the first time I've ever tried to install ANY of the Windows store apps on my computer.
I've tried every potential fix I could find on-line. I don't want to list them all for brevity purposes, but trust me, I've tried them all. I even contacted an MS tech who took control of my computer, tried several fixes and then finally told me to use the media creation tool to update my computer. That worked and was able to install and use the apps mentioned earlier, but when I restarted my computer, I was back to square one where when I opened either app, it displayed for about 1 second then crashed.
So with this said, I'm tired of wasting my time trying the myriad of so-called solutions on-line or using the MS media creation tool to repair my computer, all for 2 apps, only to have them crash the next time I turn my computer on. If I keep my computer powered without ever restarting, then yes the apps are good to go but is not a realistic solution. I don't know what changes are being made to these apps making them do this. It's definitely not changes I'm making unless you call clicking the p... Read more

Read other answers

I need to be able to block an outgoing email to specific email addresses. Basically I send out a very low level (less than 20/week) of marketing emails to addresses culled from various sites. Occasionally I get an email back asking me to remove an email address from my mailing list (which I don't really have). Is there any way for me to enter the email address in a distribution list and then have Outlook (2007) verify that the To: addressee is not in that list or, if it is, to alert me and/or defer/block the send?



A:Blocking outgoing email to a specific address

I am confused. Where are you getting these email addresses if you don't have a list?

Read other 1 answers


I have a user that is having a strange problem when he tries to create a rule in Outlook 2003 by right clicking a message and creating a new rule. If he goes to tools>rules and alerts it works fine but of course, that is not good enough! The issue that I am seeing occurs when the user right clicks the message from someone and wants to forward it to someone else for example. Normally, you can click a link to open up the address list and select the account to forward to but on his machine, he does not even get a link to click on to select the forwarding account. I have already removed and recreated his outlook profile to no avail. Has anyone else seen this before? Thanks.

Read other answers


I have a telecom management software (NMS) where we host the CORBA naming service in our machine. The network elements, thousands of them, have the reference to the naming service hosted in the NMS. To avoid the naming service from getting overload we have limited the number of thread and connections to max 500.

Typcially during the startup of the NMS all the network elements access the naming service more or less at the same time, some succeed while some fail and retry after some time.

The naming service is also used internally also in the NMS and during the NMS startup it competes with the network elements for the naming service connection. This slows down the NMS bringup significantly.

Is there a way to temporarily stop the external clients (I have specific IP addresses etc) from accessing the naming while allowing the local clients access to naming service.

We tried blocking it using /etc/host.deny etc but it works only for services like ftp/telnet but not for GIOP.

Suggestions , references welcome.
Thanks and Regards,

A:Blocking CORBA (GIOP) calls for specific host

What NMS is this?

I'm confused as to why all of your network elements reach out to Corba when it starts...? I'm thinking maybe that the element manager is polling based on it's inventory during startup.

Read other 1 answers


I accidentally downloaded a file from the internet and now that file is blocking me from going to a certain site , how can I figure out what hidden file on my computer is blocking me and how to remove it? Please be specific on how to do this. Thanks.

P.S. I have windows Vista and Norton 360.
P.S.S. I am Administrator.
P.S.S.S. When I try to connect it goes to a blank screen then after about a minute this comes up:

Network Timeout

The server at *********.com is taking too long to respond.

The requested site did not respond to a connection request and the browser has stopped waiting for a reply.

* Could the server be experiencing high demand or a temporary outage? Try again later.
* Are you unable to browse other sites? Check the computer's network connection.
* Is your computer or network protected by a firewall or proxy? Incorrect settings can interfere with Web browsing.
* Still having trouble? Consult your network administrator or Internet provider for assistance.

Silly Boomer

A:How can I find a hidden file thats blocking me from using a specific site?

Read other 16 answers

I have an associate who owns a smallish business with an equally smallish network.

A problem has arisen in that a member of his staff has "lost" some important and sensitive data from their networked PC.

We have analysed the hard drive & that of the shared Server and "recovered" deleted or otherwise "lost" files which appears to have worked inasmuch that we obtained data which had been deleted over a considerable period of time before and after the "lost" data was created, yet there is no sign whatsoever of the lost data.

There is a suspicion (but only a suspicion) that this particular staff member just might have saved these files to a USB stick, rather than the hard drive or Server and I am wondering if (and if so, how difficult is it) evidence can be obtained which would show the date and time a USB drive has been employed and (even better) whether such might detail the contents (or at least the filenames and types) of data that was saved in this way?

Would Windows event viewer reveal any or all of this and how would we go about isolating USB drive activity etc., through this means, if so?

Any advice, please?

Read other answers

Hello, I have been through the ringer and back trying to find out why my spyware doctor program(which I'm so fed up with, I have now deleted it and switched to a paid MBAM and avira antivirus) kept scanning something called, "Invisible Keylogger," and a "Lantern Keylogger Viewer" even though I can't find it anywhere on my laptop. So far, I've had little luck and I'm not focusing on that right now. I simply wanted someone to first tell me what these undeltable hijack this hidden data steams could be. Some of them are part of my volume information folder, and before I ditched my PC because of a monumental infection, that is exactly where the root of the problem was hiding. Now the same type of stream is showing up on my laptop. After that, all I want to know is what these avira warnings could mean and I will be out of your hair. I don't want to go through the whole process again. I just want to know if the problem could be idenfiied in these two specific samplings. If it can't be, that's fine. I don't need anything other than that.

C:\ProgramData\Temp : 430C6D84 (102 bytes, MD5 D41D8CD98F00B204E9800998ECF8427E)
C:\ProgramData\Temp : A8ADE5D8 (109 bytes, MD5 D41D8CD98F00B204E9800998ECF8427E)
C:\ProgramData\Temp : DFC5A2B2 (198 bytes, MD5 D41D8CD98F00B204E9800998ECF8427E)
C:\ProgramData\Temp : 430C6D84 (102 bytes, MD5 D41D8CD98F00B204E9800998ECF8427E)
C:\ProgramData\Temp : A8ADE5D8 (109 bytes, MD5 D41D8CD98F00B204E98009... Read more

Read other answers


I am trying to automate the completion of a monthly cash flow spreadsheet in Excel 2003

I currently create the sheet and link to previous sheet running balances, then manually enter the numbers according to when they come out of the back account.

The data to enter on Bank sheet is listed on Data sheet, and may be any order though I put in date order to make easier to follow when entering manually.

Things to note:
1) It is important that if two payments on same day for same Type then show as "+200+300" rather than just 500

2) If fall on weekend (and thus no date as cloumn header) then must show on next available date.

3) The New Sheet may start on any day of the month.

4) I copy the last week of each workbook to the first week on new workbook, and so the first week tends to be already completed.
If you have any questions let me know.

I appreciate your help.


Read other answers

thanks in advance for any help anyone can offer, whether it's an application someone is aware of for doing this sort of thing or whether it can be done with scripts to work the files without opening them etc.

It's a two stage problem really, both elements concerning how to get or match data from files way too large to open in excel or access etc. with a view to adding considerabl numbers of extra product lines to my Amazon pro seller account, then keeping the stock and price figures updated.

Stage 1
Basically I first want to extract certain information from a 2Gb .txt file. The text file contains approximately 6.2 million product records (books mostly) and is provided to me weekly. I want to extract the same single piece of information (the 'I3' field) for every product which has one of a certain set of values for a different piece of information (the 'GC' field).

The I3 (that's a captial I not a 1 btw) field gives the 13 digit unique product identifier. The GC is basically a category code.

So all I want to end up with is a column of 13 digit codes. Every other bit of information is irrelevant.

Below is an example of three products from the text file. The ** is the separator between products.

IB 0702026174
BI Hardback
IU 275 ILLS.
PD 20011213
NP 600
RP 69.99
RI 69.99
RE 69.99
DI 279 x 221
YP 2001

Read other answers

I'm hoping someone can lead me in the right direction here. I have a sql query that was written for me some time ago. I need to have the data placed in specific columns and rows within the csv file. Is it possible for me to do this? Here is what I have below... Lets say I need to place "ASSRREAL.Street" in column D row 3 of the csv file. Any help or ideas would be great. Thanks

SELECT '"' + RTRIM(ASSRREAL.Unique_id) + '"' AS Uniqueid,
'"' + RTRIM(ASSRREAL.Taxpayer) + '"' AS Name,
'"' + '"' As Name2,
'"' + RTRIM(ASSRREAL.In_Care_Of) + '"' AS Careof,
'"' + RTRIM(ASSRREAL.Street) + '"' AS Address1,
'"' + RTRIM(ASSRREAL.Street_Mailing_Addr2) + '"' AS Address2,
'"' + RTRIM(ASSRREAL.City) + '"' AS City,
'"' + RTRIM(ASSRREAL.State) + '"' AS State,
'"' + RTRIM(ASSRREAL.Zip1 + ASSRREAL.Zip2) + '"' AS Zipcode,
ASSRREAL.Acreage AS Acres,
'"' + RTRIM(ASSRREAL.Map_Block_Lot + Xtr_Mbl) + '"' AS MBL,
'"' + CONVERT(varchar(5), ASSRREAL.Volume) + '"' AS Volume,
'"' + CONVERT(varchar(5), ASSRREAL.Page) + '"' AS Page,
'"' + RTRIM(LTRIM(ASSRREAL.Prop_Loc_St_No)) + '"... Read more

A:Extract SQL data to specific columns

Read other 7 answers

My ISP charges for outbound traffic, even though they dont pay for it. According to them it is to stop people sharing files and stuff illegally. In my case, it's accounting for 10% of my allowance, and I've tried everything I can to stop it.

Somehow, people are getting into my network and transferring data. I've blocked all the ports for P2P programs that I can find, I've set up OpenDNS, I've told the kids to stop using P2P and Torrent programs.

My router (DLINK DIR655), doesnt tell me anything.

In the 29th of June I had uploaded 2314mb. On the 30th it was 5564mb (I got this from the Optus website), yet the kids say they didn't upload anything, and looking at their computers I can't see anything to prove that they did. So I have to give them the benefit of the doubt.

Is there a way to lock my network down so that they can't share stuff or open ports and no one can get in?

Is there a way to block the installation of programs on their computers without setting them up as standard users and creating an administrative nightmare for myself? I've looked at parental controls but it doesn't offer a suitable solution.

Is there any software that can keep a history of what ports have been opened on a network and what data has been moved around?

This is driving me nuts.


A:Blocking outbound traffic (data out)

hi !

what firewall are you using ?
it should be able to provide you with the history.

are you letting the kids use your ADMIN-account ??
of course they should use a USER-account, otherwise they can install software & change important settings and mess up your computer.

Read other 2 answers

Hi Guys

I can not add ip or address to firewall G DATA for blocking by firewall.

i set ip in rule firewall but firewall can not blocked ip and open website by opera.

Please help me by screen shot or video

@HarborFront @Lockdown @mekelek @MWNu72

Thanks my bro

A:How to blocking ip or address in the firewall G DATA

Help Me Decide - Trustport VS Emsisoft VS Dr.Web VS G-DATA - Which is the better Security Suite?

Enter IP address you want to block in both From and To fields.

Read other 1 answers


I"M looking to block selective data going OUTBOUND or replace with ***. Yes, in the clear.

I have OP FW pro 7 working on my set up.

It has a feature in it called ID block where I can insert private data like SIN numbers, credit card and bank codes wifes name and phone number etc.

What I'm looking for is a separate tool/product that isn't a feature of a FW or a Suite with AV, FW etc so that IF I change FW's or HIPS or AV's for what ever reason I can block packets containing these private data elements on open in the clear sends. Email etc.

The OP works since I have tested it and it can replace the private data with *** so message goes but not with private data.

Sorry to be long winded but there it is!

I have looked but can't see anything yet?

Any clues?
Who might know if you don't?

Read other answers

I have an Excel spread sheet that has city and state information in one field. I need to speparate into two field for sorting purposes. How can I do that in Excel?

A:Solved: Separating data with a specific field

In Excel 2003 (others may be similar)

Hightlight the first cell you want to split (remember you're splitting the entire column), look into the menu's Data then Text to Columns.

Follow the prompts. In step 2, you'll be able to move the lines with the arrow pointing up by simply putting your mouse pointer on it and dragging it right or left to your comfort level...

Remember - by the time it's said and done, you'll have two or more columns depending on how you split them...

Look here ( http://www.worldstart.com/tips/tips.php/1153 ) for the steps

Read other 3 answers

I have transferred information from a Lotus 123 database to Excel 2000. I would like to create a template and have it formatted a specific way. I need help in writing the macros.
Please see the following example:

Transferred Data Looks Like:

1 Product # Back
Code Ordered
2 ABC123 7
3 ABC123 2
4 DEF223 6
5 GG1126 3
6 GG1126 5
What I Would Like:

1 Product # Back
Code Ordered Total
2 blank row
3 ABC123 7
4 ABC123 2 9
5 blank row
6 DEF223 6 6
7 blank row
8 GG1126 3
9 GG1126 5 5
10 blank row

This transferred information is approximately 3000 rows long and
changes daily.

If anybody could possibly help me I would greatly appreciate it.

Thank you sincerely,

A:Insert a row between AlphaNumeric data then sum specific groups.

Read other 8 answers

Can I move data from a specific folder in Outlook Express to another computer.

I work on a desktop and data is backed up to a laptop. I use OEQB.

However the outlook express has many folders ie Invoices, jobs completed, Maintenance Sw, SE also has subfolders such as "not entered" "completed" "invoiced"

I wish to be able to move just the INBOX, or the Invoices, or jobs completed so that both computers are fully synchronised and the Boss can have exactly same info.

The work comes by email to desktop and is transferred to laptop for fieldwork. OEQB does all folders and we only want to move data in individual folders. Outlook Express does not want to transfer or export/import to a normal folder not connected to OE

Can someone help on this please

Read other answers

Hello everybody, I hardly can use Safari browser because the Data Execution Prevention feature close it when I want to open it. I unblocked it in the system and I can see it in the Exceptions window, but the issue continue happening very often. Sometimes I close the browser and reopen it again works, but this is a hassle! Is there some way to turn off or stop this program to control my computer? This is happening only with Safari so far.

A:Data execution prevention blocking Safari

If you are certain DEP is causing the problem, just disable it all together. While it's theoretically a nice feature, I disable it on all of my systems.


Read other 1 answers

I have a user form with two combo boxes, an add button and a close button. I would like the users choices from the combo boxes to be added to the worksheet "ReqM" starting with the first blank row on or after row 85, the 2nd choice on row 86 and so on until the users clicks the close button. The following code currently adds the data to the last blank row in the worksheet.

I appreciate any help:

Private Sub cmdAdd_Click()
Dim lRow As Long
Dim lPart As Long
Dim ws As Worksheet
Set ws = Worksheets("Req M")

'Need help with this section:

'find first empty row in database
lRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row
lPart = Me.cboEmployee.ListIndex

'copy the data to the database
With ws
.Cells(lRow, 1).Value = Me.cboEmployee.Value

.Cells(lRow, 3).Value = Me.cboPosition.Value
End With

'clear the data
Me.cboEmployee.Value = ""
Me.cboPosition.Value = ""

End Sub

A:Solved: Add data from a UserFrom to the first empty row in a specific range

Read other 15 answers

Evening all,

I'm very new to VBA and am struggling badly with this one. I'll explain what I need to do as the title is a little unclear!

I'm making an insurance calculator for classic cars, and on my welcome screen I have a button called lablled Edit Existing Quote. What I would like this button to do is, upon clicking, ask the user to enter the Reg Number (the PK in my client data table) of the client whos details they wish to edit. Once a reg number is entered and submit or something has been clicked I want that record to then appear in form view.

I've got as far as the:

DoCmd.OpenForm "frm_New_Quote", acNormal

(The form is named so because I use it to add new data as well, using the 'DoCmd.GoToRecord , , acNewRec' code, the form otherwise shows client data for the last record entered.)

I'm guessing it'll involve vbQuestion somewhere in there, or possibly some SQl...I'm really not sure. I only have a very basic knowledge of VBA and the two lines I've pasted there are about all I know! I'm staring at my VBA book but failing to find the relevant pages.

So, can anyone help me out with this one? It should run like :

Click 'Edit' button on welcome screen, then little box pops up asking for reg number, then that clients details is presented.

Please help!

my client data table is called 'Client Tbl' at the moment.

Read other answers

Hello Everyone, Its my first post here :-)

I have a text file with values printed like these;

Last seen: 14/12/2011 - 16:06:12
Vendor: Cisco Systems
Signal: -91 dBm
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 11, 12, 18, 24, 36, 48, 54,
Packets: 25
Unique WEP IVs: 0

Last seen: 14/12/2011 - 15:57:27
Signal: -96 dBm
SSID: Misuss
Enc: WEP
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 6, 9, 12, 48, 18, 24, 36, 54,
Packets: 7
Unique WEP IVs: 0

Last seen: 14/12/2011 - 15:56:49
Vendor: Cisco Systems
Signal: -95 dBm
SSID: Mobile
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 11, 12, 18, 24, 36, 48, 54,
Packets: 2
Unique WEP IVs: 0

I want to export this all to an excel spreadsheet with columns representing BSSID, Last Seen, vendor, Signal, SSID, Enc, Mode etc., and all the values belonging for an BSSID in a single row. Does it look doable? If yes, please let me know how to achieve this, and I will be highly obliged.

Much thanks!


A:Please Help - Data in Text File to be arranged in Excel in a specific

First, two questions: how proficient are you with Word and Excel? Are you comfortable using the REPLACE function in both?

If reasonably proficient and comfortable (understand) with the REPLACE function, it isn't difficult and will take about 15 minutes to accomplish what you seek.

Open the text file in Word.

Turn on the SHOW ALL switch (the paragraph mark icon).

Your post example has MANUAL LINE BREAKS after each line - if the source file has them, replace all of them with PARAGRAPH MARK.

Add a PARAGRAPH MARK (Enter) at the very beginning of the document.

Replace DOUBLE PARAGRAPH MARKS with PARAGRAPH MARK, hash mark (#) - makes it easier to see what you are doing next - and PARAGRAPH MARK like this:

Find what: ^p^p
Replace with: ^p#^p

Now add the tilde (~) in front of each line:

Find what: ^pBSSID:
Replace with: ^p~BSSID:

Repeat for each line of a record (total of 11 times).

Delete all of the hash marks (#):

Find what: ^p#^p
Replace with: ^p

Now your records are:
> Separated by a carriage return (paragraph mark)
> Fields are separated by the tilde (~)
> The first imported column will be EMPTY

Save the txt file and close Word.

Open Excel.
Open file type: All Files (*.*)

Select your text file.

In the import steps:
Step 1: Delimited
Step 2: deselect Tab and select Other, set to ~


Insert a header row and label each column.

Select each colum one at a time and delete the corresponding record field leaders. Be... Read more

Read other 2 answers


I am stuck creating a new macro. Currently I have a workbook and macro that emails each worksheet to a specific user (email address referenced on each worksheet). This works great, however, I have a new project that requires emails sent weekly to 200 individuals with significantly less data. I have a new workbook with a worksheet that compiles data from multiple sources (this is working fine). I need to email each user with only their data on the worksheet. Each section is the same (23 Columns x 13 Rows).

A1:W13 (with B3 containing the email address)
A14:W26 (with B16 containing the email address)
A27:W39 (with B28 containing the email address)
and so on...

I could setup 200 worksheets and have the block of data (23 Columns x
13 Rows) on each worksheet and use the code I have to email each
sheet, however, it is much too hard to manage that many sheets.

I have also setup code to select a range of data on a sheet but having cannot replicate it to continue until an email address is not found. I was thinking if the macro would look for an email address (@ symbol in the cell) in Column B and when found email Rows -2 (2 rows above) to row 13 below and continue until no email addresses are left, it would accomplish what I am trying to do. Below is my email each sheet code followed by my attempt to modify to send range of data on a sheet. It appears to select the range but does not populate email nor does it replicate to select the next section. Sections are the same so ra... Read more

Read other answers

Hello I have a "little" problem.
When i start downloading large data files with multiple connections (it does not matter which download manager i use - flash get, jdownloader, IDM) it starts to consume a lot of MB until it consumes all of it, but when i close the download manager only about 200 MB becomes free (before downloading started i had used only 900/2048 MB and after closing download manager, it is used ~1800 MB / 2048 MB and there is no program in task manager which would consume such a lot of memory and i can free the ram only by restarting computer. This happens to me on celan RC version and even on clean RTM version.
I have quite a fast conenction 50/50 Mbps so the RAM runs out quite fast (in 15 minutes i have no free ram).
This happens only in Win7 (in Vista, XP it downloads without any memory leak using the same download managers)

Does anyone have the same problem or know how to solve it?

//EDIT: I have 32bit systems; see My System Specs under this post to view HW ane please vote only if you are downloading in Win7
//EDIT2: Problem solved - since i uninstalled nod32, i have had no memory issues

A:Memory blocking while downloading large data files

Quote: Originally Posted by martinpelant

Hello I have a "little" problem.
When i start downloading large data files with multiple connections (it does not matter which download manager i use - flash get, jdownloader, IDM) it starts to consume a lot of MB until it consumes all of it, but when i close the download manager only about 200 MB becomes free (before downloading started i had used only 900/2048 MB and after closing download manager, it is used ~1800 MB / 2048 MB and there is no program in task manager which would consume such a lot of memory and i can free the ram only by restarting computer. This happens to me on celan RC version and even on clean RTM version.
I have quite a fast conenction 50/50 Mbps so the RAM runs out quite fast (in 15 minutes i have no free ram).
This happens only in Win7 (in Vista, XP it downloads without any memory leak using the same download managers)

Does anyone have the same problem or know how to solve it?

Well lets start with is ot 32bit? when this happens what does the process tab in task manager say is using the memory? to open task mgr rightclick taskbar.


Read other 9 answers

Hello,My hard drive has slowly depleted, and in the last three days, after a huge removal of files, gone from 15GB free to currently about 8GB. It has been full for quite some time, but it only occured to me something was wrong when my Kaspersky antivirus kept asking to be updated. About 7 times in the last week or so. Kaspersky managed to remove a huge amount last week, and thanks to the help of 'boopme' and 'DaChew' have managed to remove more. I've now been asked to post here. Topic referenced is here: http://www.bleepingcomputer.com/forums/t/216826/i-think-i-have-a-virus-but-i-dont-know-what-to-do/ ~ OBDDS (Ver_09-03-16.01) - NTFSx86 Run by Matthew at 14:57:16.13 on 09/04/2009Internet Explorer: 7.0.6000.16809 BrowserJavaVersion: 1.5.0_12Microsoft? Windows Vista? Home Premium 6.0.6000.0.1252.44.1033.18.2046.842 [GMT 1:00]AV: Kaspersky Internet Security *On-access scanning enabled* (Updated)FW: Kaspersky Internet Security *enabled*============== Running Processes ===============C:\Windows\system32\wininit.exeC:\Windows\system32\lsm.exeC:\Windows\system32\svchost.exe -k DcomLaunchC:\Windows\system32\svchost.exe -k rpcssC:\Windows\System32\svchost.exe -k secsvcsC:\Windows\System32\svchost.exe -k LocalServiceNetworkRestrictedC:\Windows\System32\svchost.exe -k LocalSystemNetworkRestrictedC:\Windows\system32\svchost.exe -k netsvcsC:\Windows\system32\SLsvc.exeC:\Windows\system32\svchost.exe -k LocalServiceC:\Windows\System32\spoolsv.exeC:\Windows\system32\svchost.exe -k Loca... Read more

A:Data consuming and antivirus update blocking virus.

Hello and welcome to Bleeping ComputerWe apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help.If you have since resolved the original problem you were having, we would appreciate you letting us know. If not please perform the following steps below so we can have a look at the current condition of your machine. If you have not done so, include a clear description of the problems you're having, along with any steps you may have performed so far.Upon completing the steps below another staff member will review and take the steps necessary with you to get your machine back in working order clean and free of malware.If you have already posted a DDS log, please do so again, as your situation may have changed.Use the 'Add Reply' and add the new log to this thread.Thanks and again sorry for the delay.We need to see some information about what is happening in your machine. Please perform the following scan:Download DDS by sUBs from one of the following links. Save it to your desktop.DDS.comDDS.scrDDS.pifDouble click on the DDS icon, allow it to run.A small box will open, with an explaination about the tool. No input is needed, the scan is running.Notepad will open with the results.Follow the instructio... Read more

Read other 18 answers

Hi All,

I have a workbook consisting of 10 worksheets. First three worksheets contains Pivot Table, which gets the data from 4th, 5th and 6th worksheets. 4th, 5th and 6th worksheets gets the data (using a web query) from an external CSV file. I want to have a "Refresh Data" on the fist sheet, which is when clicked, refreshes the external data and the pivot tables in the following sequence :-
Refresh the data on 4th Sheet.
Refresh the data on 5th Sheet.
Refresh the data on 6th Sheet.
Refresh the Pivot Tables on 1st sheet.
Refresh the Pivot Tables on 2nd sheet.
Refresh the Pivot Tables on 3rd sheet.

I used "ThisWorkbook.RefreshAll", but it refreshes the data in one go, not in the required sequence. I also tried "Sheets(index).Calculate" for different sheets, but it does not refreshes the external data.

Any help in writing the macro/subroutine to achieve this functionality would be highly appreciated.


Read other answers

i have a spreadsheet that updates with data from a number of different sources. i need to filter only the relevant data that i need. i'm almost there but need to find out how to pull 2 more pieces.

in the attached spreadsheet the cells i need are in column R and T. I need to know the corresponding "name" and "size" of the data that is in column S.

unfortnuately the actual values don't show up in the spreadsheet b/c they are live data feeds but the formulas written up until now are still there.

in a nutshell what i'm doing is getting 5 price feeds and i need to filter out which is the highest updated within the last 2 minutes. i actually have the only the price figured out in column S, but i also now which name and how big the size is related to that price.

your help is very appreciated.


A:Solved: excel - data returned based on the value of a specific cell

Read other 10 answers

I need some help creating a macro with some complex (I think) functions. This one might be tough!

I have a document that has fill in fields. The document is protected in order to enable the fill in fields.
Users will enter information in the fields depending on the answers to the questions in the document. The document is attached to show what it looks like.

What I need is a button (called "copy") at the end of the document that the user can just click and the macro will only copy text formatted as header and any fill-in fields that were completed.

Then the user can use the copied data to paste it somewhere else either by using their mouse (right click + paste) or using the Ctrl + v.

I'm not even sure if that's possible but we'll see if someone can help. It would be extremely wonderful if someone could figure this one out.


A:Creating a Macro to copy specific data within a protected document

Hi Nena, welcome to the forum
I'm sure it will be possible to read all entries using a macro like the one below


Sub test2()
Dim fld As FormField
For Each fld In ActiveDocument.FormFields
Debug.Print fld.Name & " - " & ActiveDocument.FormFields(fld.Name).Result
End Sub

I placed this macro in the documents VBA project,
I filled in "hello" in the Person: field and see here the result when I run the macro:

Dropdown4 - Select One
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Dropdown4 - Select One
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Dropdown4 - Select One
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Dropdown4 - Select One
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
- Yes....complete a-c
- Yes....complete a-c
Text1 - hello
- Yes....complete a-c
Text1 - hello
- Yes....complete a-c
Text1 - hello
Text1 - hello
Text1 - hello
Dropdown5 - No
Text1 - hello
Text1 - hello
Dropdown5 - No
Text1 - hello
Dropdown6 - Select One
Text1 - hello
Text1 - hello
Text1 - hello
Text1 - hello
Dropdown5 - No
Text1 - hello
Text1 - hello
Dropdown5 - No
Text1 - hello
Text1 - h... Read more

Read other 1 answers