Recent content by J741

O.K. I guess I didn't make myself clear. I know how to do this manually, but I don't know how to do this programatically in a macro. I think I need to make use of direct object references and array variables, but I'm not sure how. Part 1 of the problem (Which I don't have any idea how to...

Hi all. I am relativly inexperienced when it comes to VBA macros in Excel, and am in need of help with a task I am trying to automate in Excel 2007, as follows: I have 2 spreadsheets with data. One is a static history of all-time, the other is fresh data from a recent snapshot in time. I...

Hi SkipVought. So the parts I don't understand in your example, are as follows... thisworkbook.sheets(somesheet).range(somerange).copy 1. What if the source is not in the current workbook? I expect that the reference to 'thisworkbook' would not work. (maybe this is answered in the next...

SkipVought, thank you for your input, however I don't understand it. I am a relative novice when it comes to VBA stuff, so I have been creating my macros by using the 'macro recorder' in Excel and then editing / manipulating the resulting VBA code to fit my need. So far this has worked out...

Yup. Wrong variable name used. D'oh! Thank you jges, for your sharp eyes. I feel foolish now. My memory is not as good as it should be, and neither is my memory. I have forgotten more than I can remember

Hi. I am trying to write a macro to copy some content from one workbook to another workbook (not different worksheets in the same workbook) and I am having some difficutly with which I need urgent help. Se the following bits of code from my macro: Public sWorkbookName As String...

Hi all. I am in need of an SNMP Management software that I can use for the purpose of demonstrating how SNMP is used by an IS department, to key decision makers in our department. This is for the purpose of some hands-on training (instead of just screen shots). However, due to political...

How can I get an accurate report of memory use in Windows? Windows' task manager has a column for 'Mem Usage', but if I add up all of those numbers it is not even close to the reported 'PF Usage' in the 'performance' tab (Which I have always referenced as actual total memory use). I tried...

** WRONG - Problem NOT solved ** I was mistaken about the results, as they were performed using Microsoft Outlook Express to test the resulting e-mail's 'from' header information (which showed the desired 'from' address). But When other e-mail clients are used to read the e-mail...

** PROBLEM SOLVED ** After setting up a Google GMAIL account, enabling it for use with POP 7 SMTP, and using it's SMTP servers with a secure login for outgoing mail, everything I sent was modified to show that it came from my GMAIL account instead of the desired 'from' address. The solution...

Thanks 'smah', but gmail automatically changes the 'from' address to my gmail account, and not the e-mail address I actually want to look like it came from. Any other suggestions. - James. My memory is not as good as it should be, and neither is my memory. I have forgotten more than I...

That looks more like it. Thanks Bill. My memory is not as good as it should be, and neither is my memory. I have forgotten more than I can remember

Does the Windows 2000 computer connect to a Domain based network ? If so, then 'Everyone' does not mean everyone. It actually means everyone who has used an authenticated logon to the network domain controller, and nobody else. However, if the Windows 2000 computer does not connect to a...

I have a client who is looking for a simple program to allow shared access to a calendar / schedule between 3 users on 3 different computers. I know that Microsoft Exchange Server will do this, but that is serious overkill for this client's needs. And Exchange Server requires the use of a...

I have a situation in which a user with a notebook computer has 5 different e-mail accounts from 3 different ISPs. He uses his notebook regularily from no less than 3 different locations each week. Now, when he attepts to send e-mail he usually gets a bounced message stating 'Relaying not...