Recent content by R3D3

I have nice piece of code that brings data into my Excel macro from a file (I think I got it from Tek Tips long ago.) ------------------------------------- hdle = 1 Open XML_FILE_NAME For Binary As #hdle Do Until EOF(hdle) Line Input #hdle, strLine XML = XML & strLine Loop Close #hdle...

Application.Caller.Row is what I was looking for. Works a treat. Your a star. FYI. Namedfield was one of a collection of Names.

Getting closer but what I want is the .Row of the cell that contains the function rather than that of the Namesfield supplied to the function. thanks

I want to write my own function which takes details from same rows but different columns on another sheet. I dont want to pass the Row in the function. Is there a way of identifying which row the function is recalculating. I thought it would be Activecell but of course this is the cell where the...

You are abolutely spot on. Thanks.

Hi PDQBach, One limit at a time:) If I understand correctly, I'm already doing this... tTNotes = projApp.ActiveProject.Tasks.Item(T).Notes xlApp.Cells(n, cTNotes).Value = tTNotes but even in tTNotes I only get the 253 chars. If I view the projApp.ActiveProject.Tasks.Item(T).Notes in the...

I understand that there are some limitations in MSProject regarding the Notes. ie you can only see the first so many characters unless you go onto the actual Dialogue box that maintains the text. It seems the same limitation is in VBA structure. eg projApp.ActiveProject.Tasks.Item(n).Notes is...

I have all my contacts & emails currently in MSOutlook 2000 and I now have to use Outlook Web Access for next 3 months. There must be a way of synchronising the two. I dont have the POP3 or IMAP settings to link into OWA server and there are no import facilities in the OWA. I tried setting OWA...

Solved. Some machines did not have latest Windows upgrades. Downloaded them and problem went away. So there was a fix amonst these.

I'm absolutely stumpted by this problem which appears to be so simple. I have a number of machines that appear to be configured the same. Some work fine - others do not. The Problem: On some machines the following Hyperlink does not work from Word nor Excel...

I could be faced with the same solution if there is no way around it. Unfortunately my example was rather simplistic and each sheet is different with common column headings that would hopefully be matched for a consolidation pivot table. Still hopeful...

I've searched everywere & tried everything before posting this so it is obviously impossible... unless you can solve it of course! I can create Pivot tables without any problem. However when it comes to Multiple Consolidation Ranges to do exactly the same using data from 4 different worksheets...

Within my DLL created via VB6 code I am connecting to an SQL Database and I use a connect string like this.... "userid=sa;password=xxx;data source=yyy; initial catalogue=zzz" where yyy=Name of SQL Server yyy=Name of database How can I access the name of the machine from VB so I dont have...

Seems simple enough, all I want to do is use some of the data in the HTML screen within a template Word document. I can Link to Word Doc of course from the LAN that will contain the bulk of the document data. However I want to include the Name/Address that is appropriate from this screen. No...

There is no machine with this address on the LAN. I've heard that 6667 is more than likely an IRC trojan or a trojan using standard IRC ports to mimic an IRC server. Isn't there a way of the firewall stopping the tcp packet from reaching the port? Or opening it up again after it has been denied?