Recent content by NWPA

Hello, I have a question. I am trying to write a VBA function that will capture everything right of a "/" for example if i have the url. abc.biz/abc/preference/abc.php I want to capture everything right of the first "/" so my next cell shows abc/preference/abc.php I know i need to create a...

Okay that makes complete sense. I am sorry i thought you were saying i needed a function in the sheet VBA. Works Perfect thanks a ton.

I currently have in modules a Module1 with the DomainSuf function. The data is in Sheet 1 column A. The only purpose of this excel workbook is going to be importing a list of about 2,000 Urls into a column and attempting to capture the root domain and suffix every week. The problem is some of...

I am sorry but I am struggling on this. I understand a Module is like a global reference throughout the workbook but I am having problems with how the function works. If I have the Url Column that I want altered in worksheet1 column A. Will this function alter Column A or put it in Column B...

I pasted the function into a module (not Class Module) and still did not have any luck. Once again I appologize for not being knowledgeable.

Hello, I am sorry i have zero experience with VBA scripting in Office. Where exactly do i place this function Tools>>Macro>>VisualBasic Script Editor? Do I need to name the url header DomainSuf? How does the Function know that i am pointing towards the URL Column? I am sorry if I sound like...

Hello, I was wondering if there was any way of VBA coding to extract just the domain name and end suffix from a url column. For Example If I had 3 entries in a URL column http://www.tek-tips.com http://www.tek.tek-tips.com http://www.tek.tip.tektips.com Is there a VBA Script to only up...

Hello I am working on a database where i have a table that contains a field that has a url field. What I am trying to do is write a query that will give me the root domain and none of the sub domains. Example: If I have the urls.... http://tek-tips.com, tek.tek-tips.com and...