Search results for query: *

I didn't think that OE had a programmable interface. But, based on the first answer, I figured it was worth a look. Anyway, assuming I grab hold of it, I'm now wondering what SendKeys to send? I assume it would be a "Alt-S", since that is the quickie command to send the email...? Mr...

Thanks for the info. I'll give it a try tonight. I didn't use the objMail method, as I didn't know what Outlook Express was/is called. I saw a routine for Outlook, and wondered if Outlook Express followed the same mentality, but I never tried because of the naming question... Mr. Pickles

Inside VB6, I have normal code that will open the default mail client (Outlook Express in this case), and supply the Subject, To, and Body automatically. Now how do I have this thing press the Send key and close the mail client? Any help is appreciated, Mr. Pickles

All, I need to get the value of a Variable that is the result of a JavaScript routine on a web page. I am using VB6. It seems that all the normal things to try return a null string, since the Variable is a result of a JavaScript routine. I need the value. Either in a textbox, a VB6 variable...

I have a workbook containing worksheets. I am saving one of these worksheets. When I do it, Excel truncates the cell contents to 255 characters. I looked into it, and it seems like my "ActiveSheet.Copy" line is the problem. I do NOT want to simply "rename" the file, whcih is...

I would ask the printing company what "color profile" they use to print. They should know. If your using "Adobe RBG" and they are using one called "Fuji Frontier" or something, then the colors will be way off. If you can try this by setting your PS to print to a...

Have you tried to load them manually? Click (or is it a right-click) on the little right facing arrow to the right of the Actions tab and there should be a menu pop up with browse or open on it...

All, I'm trying to set the Print Margin's in Excel's VBA. My settings are not taking when the print margin is something different before you open my file. The code I am using is below. If the "default" worksheet has top and bottom margins of 1.125", then they stay that way...

All, Is it possible to get all of my Excel VBA stuff and open it in VB6? I need the code (of course) and the forms too. The code shouldn't be a big deal, even if it was a cut and paste, but what about the forms? Thanks, Mr. Pickles

Nevermind. Brain Fart issue resolved. Workbooks.Open DOES have the password in it, so I am now saving and loading password protected files. Ain't help files wonderful....

Well, come to find out, I'm not getting them back. Actually, in the saveas command you can specify the password, so I made a standard one. But when I go to open (Workbooks.Open) the file to import the data, there doesn't appear to be a way to specify the password via VBA. unless it is hidden...

xlbo, Thanks for the reply. I'm doing what you suggested, slightly modified. Concerning the password "giver", it is in the ActiveWorkbook.SaveAs command, using the Password option Now all I got to do is get the range of filenames and stick it in a listbox so someone can pick the...

To make it simple, I have a complicated front-end in Excel VBA that saves worksheets (not the workbook). I change the file extension of the worksheets when I save them, just to keep stupid people away in Explorer listings. I also give them a password when I save them. NOW, I want to open one of...

I have a routine that save one worksheet in my workbook. What it does actually, is makes a "copy" of a worksheet and opens it in a new "window". It then saves that workbook automatically, getting it's name from a cell in the original workbook. Then it switches the window back...

I have a need for a M$ file called DSOleFile inside my Excel VBA code, in a couple of files. Everything is fine in NT 2000. When I copy my spreadsheets and install the DSOleFile on my XP machine, one of the spreadsheets crashes while opening (error opening file, goodbye), and another seems to...

Okay, stupid question number 3. I got a bazillion variables with values assigned in my VBA code, inside Excel. Is there a way to clear ALL of them when I click the End button on a VBA form? I seem to have a memory glitch after I play with it for awhile and then close Excel. Excel doesn't want...

A dummy needs help, I have a form (Form1), that has a textbox (Text1) and a button on it that opens another form (Form2). Form2 does some stuff, and then you click on a button on Form2 that closes the form, and returns to Form1, with the textbox (Text1) on Form1 containing the value of a...

Anybody know of a VB way to grab values from textboxes in a for...next loop? Example... You got (3) text boxes named Text1, Text2, and Text3 whose value is in this example 10, 20, & 30 respectfully, so For x = 1 to 3 y = Text(x).Value 'something like this Print y Next x Need the...

While I am here questioning, what is with XP's Read-Only Directories. I looked in Explorer and right-click on a directory (any off them). In Advanced, they are listed as read-only. Wanna change it? Sure, and everything in there too. Okay, hit Apply and then look again. Yup. Read-Only again...

Here is an update. My Excel 2000 will NOT Save or Saveas ONE file. I'm using XP. The file works FINE on another XP box. It works fine on a 98 box, and a NT2000 one. I open the file and tell it to saveas and you get the dialog saying "Document Not Saved", but the name changed. If you...