Search results for query: *

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

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

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

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

I have something in windows that I cannot get rid of. It started long ago when machine first setup and Virus Checker/Firewall not yet installed. Something is opening up ports and leaving them LISTENING. After 36 hours all 5000 ports are left listening and there are none free for my applications...

Any time I attempt to download any .EXE file from another server I get a screen response with a small icon in top left of screen, rather than the usual 'File Download' dialogue asking where to save it. I can get around it in most cases by right-clicking and saving it. However some downloads are...

can anyone think of a way of manipulating the Sequence of DIVs on a page? I'm trying to find a way of displaying the first few DIVs on a page and then inserting another, the position being dependendent upon its content. I can make the DIVs hidden as below but can I then make them visible in a...

I have a problem with XMLHTTP It appears to be unable to handle 'special characters' such as french characters. I've tried to specify various CharSets in the setRequestHeader "Content-Type" but it doesn't seem to make any difference. I dont have the problem on every site I access but...

I've tried just about every syntax I can think of but with no success. Response.write(objxml.xml) <<<< No problem onclick='javascript: passfare(&quot;<%objxml%>&quot;)' <script language=&quot;javascript&quot;> function fillfare(objxml) { alert(objxml); <<<<<<< empty } </Script>...

Because of the unreliability of a site I hyperlink to regularly for its photos I would like to take a copy of these and hold them locally. Only going to the remote site for further Detailed viewing. Of course this is possible by manually loading and saving the image with right-click/save as...

I've create my VBA functions as part of a .xls spreadsheet and have no problems issuing that with all the macros specified as Shortcuts as required. Now I try to create these functions as an AddIn as I dont really want the user to load the .xls each time in order to use the macros. However...

How can I create 2 different processes from ASP that will run concurrently? I have 3 functions A, B and C, each of them taking 5 seconds. Function C uses the results of Functions A and B Functions A and B are completely independant of each other and their processing is performed on different...

How can I create 2 different processes in VB6 that will run concurrently? I have 3 functions A, B and C, each of them taking 5 seconds. Function C uses the results of Functions A and B Functions A and B are completely independant of each other and their processing is performed on different...

I have written an ADO EXE with 3 Functions: One function to Open Sessions. Another Function to Pass data through them. Another Function to Close them. Works fine if I write it all as one executable in the same instance of the Program. If I create a ActiveX EXE it does not work anymore. Opening...

From ASP VBSCript I have a problem calling a VB function I've written. In the ASP... 'The objxml is correctly formed at this point 'defined as.... set objxml=server.CreateObject (&quot;Microsoft.XMLDOM&quot;) 'Then set objapi=server.CreateObject(&quot;FA_Hotel_Project.Hotel&quot;)...