Search results for query: *

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

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

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

I don't know whether this is VBA or not. I have a big old Excel workbook with a large bit of VBA in it. There is no weird coding going on in there that I know of. It was written in Excel 2000 on both NT2000 and Win98. I opened it on my new XP box and WAMMO. I click on the worksheet, and I...

Maybe this is stupid, but how come from inside my "@ Work" version of Excel 2000, I have NO VBA control to do a grid, or a mini-Excel worksheet? I have MSFlexGrid as an option to turn on, but it says it isn't Licensed correctly. I don't have a "regular" grid or data-grid...

Hey, How can I put several text documents that I have scanned, into ONE PDF file? I try to save to an existing file, but it doesn't work... Any help? Mr. Pickles