Search results for query: *

In Excel I have a userform with an CRVIEWER1 viewer on it. My code loads an existing .rpt report to the viewer fine. Export, printing and all other functions on the viewer(stop,search,navigation etc.) also work fine. All those functions work without any code. PROBLEM is the refresh does not...

Hi and thanks for reading this ! I need to return the users Outlook signature or VCard if one exists. The rest of my app works well except I need to include the users signature in the body of the new message . Just the signature code is needed as in what to Set and the command line to return...

How to set focus to an embedded text box control on a shared worksheet, NOT part of a UserForm collection of controls Thank you, Dave Rattigan

This is as far as I've got so far.....I need to return only the page numbers from certain panes in a word file....but this returns the entire header. ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader With Selection.HeaderFooter.PageNumbers pg = .Parent End With Thank you

Looking for the get commands (?) for use in automatic logon to IE from NT. GetUserName and GetPassword.....?.....wish it was that simple. I will continue to read the help files. It will then put the allow the following to run without the NT user prompt for IE username and password...

Looking for the get commands (?) for use in automatic logon to IE from NT. GetUserName and GetPassword.....?.....wish it was that simple. I will continue to read the help files. It will then put the allow the following to run without the NT user prompt for IE username and password...

Looking for the get commands (?) for use in automatic logon to IE from NT. GetUserName and GetPassword.....?.....wish it was that simple. I will continue to read the help files. It will then put the allow the following to run without the NT user prompt for IE username and password...

I have written several types of VBA programs using Excel, and Word as an interface for several different applications....database,userforms,intranet,email, etc. My only exposure and use of VB has been with text files. I really enjoy VBA and was wondering if there was any VBA certification tests...

My VBA macro in Excel will need to open an instance of Word, then via Word open an 8meg 85,000 row text file and delete the blank rows and save it as a text file. If I get that far I can then fit it into Excel and take it from there. Thanks people. Ratman

I know VBA in Excel but am a total beginner with Access. A good portion of my VBA programs start with the parsing or opening of a text file in Excel and saving it as a .xls Excel file. My problem is this huge 8meg 85,000 row text file(many blank rows) will not fit in the 65,000 max Excel rows...

How can I Freeze Panes or Split Column in a ListBox which is in User Form......using the ListBox's horizontal scrollbar I need the first 3 columns to always be visible. thx people drat@mediaone.net

I need to have this formula =AVERAGE(IF(rngDate>=rngFromDate,IF(rngDate<=rngToDate, IF(rngAcct=rngAcctCriteria,rngAmt)))) reference the rng of another workbook. rng's Date, Acct and Amt are the rng's that will be remote. rng's ToDate FromDate and...

I have a macro that copies an excel file(lets call it file#1),&nbsp;&nbsp;&nbsp;closes it, saves it as another file name(lets call it file#2 which now contains the main macro), executes several commands,&nbsp;&nbsp;assigns 3 other macro's to commandbars, then before it closes it is saved to...

ALL I NEED IS FOR IT TO ADVANCE FROM THE END OF LAST CELL IN COLUMN RANGE TO THE THE TOP OF THE NEXT COLUMN.<br>I WROTE THIS SCRIPT TO SELECT MY RANGE AND IT SELECTS FINE BUT AND WILL PROBABLY END LOOP AT T46 BUT IT BLOWS RIGHT PAST THE LAST CELL IN THE 1ST...

I need to know how to compare ( &gt; ) an activecell date read on an Excel spreadsheet by my macro (cell is already formatted as &quot;m,d,yyyy&quot;) to the actual current system date.<br>Global declaration for this????<br><br>My variable for this is currentdate as in.....<br>Sub...

I have many .xls files in same directory.&nbsp;&nbsp;Each filename is named mmddyy.xls&nbsp;&nbsp;&nbsp;&nbsp;<br>example<br>c:\My Excel File\Production Files\0705.00.xls<br>or as referenced in the macro<br>C:\My Excel Files\Production Files\&quot; & myFile<br><br>I now have an InputBox that...

Received a great countif from you fine people the other day that when placed in column H (Panels)<br>=(COUNTIF(G2,&quot;&lt;&gt;0&quot;))*40<br>and manually(blah) copied down tested if column G (Pieces) had non-zero's to multiply it by 40.<br><br>My boss says:<br>The sheet ultimately needs to be...

Excel's generic Subtotals option offers the &quot;count&quot; function which includes zero's in it's results and not the &quot;countif&quot; function I need.<br>I need a VB script that will sort by column &quot;D&quot; then subtotal on each change in column &quot;D&quot; using the...

I have an excel file with 7000 rows. Column B's&nbsp;&nbsp;alphanumeric values are 3 to 8 character lot#'s and column C's numeric values are 3 character associated suffix's. After sorting entire file by column B,&nbsp;&nbsp;&nbsp;I drag down this formula to tag all duplicate shop orders which is...

Hello....I have an Excel worksheet with an intense backgroud gif file formating from A1 through M30.&nbsp;&nbsp;On this worksheet (not a user form) I have commandbuttons(no macro's attached to the command buttons)with hyperlinks to other Excel workbooks and everything is fine except when I...