Search results for query: *

I'm running Windows 98, XL97 for a workbook with password protection at VBA ThisWorkbook level. I have a text box contol embedded in a cell with max row height on cell set at 409. Text box format control is set to 'move and size with cells' and PrintObject = True. Properties for text box...

bblekfeld, Yes, I did finally get this code working and it will allow you to generate your reports in MS Access XP, then attach PDF files (one for each page) and send through MS Outlook XP. I will post for you all next week. Sorry, I cannot stop to post right now.

As today is Monday, I have a fresh pair of eyes on this coding snafu.....Tried your coding fix, thought it worked on Friday, and am now getting a MsgBox "Compile Error - Expected Expression" on the "DrawingObjects:=True" line of code. Also, have not resolved the macro...

Zathras, Thank you for responding so quickly. I tried this, and although the coding works OK, I think my problem lies in the macro that actually "adds" the worksheets to the file. I will try other fixes since this did not solve the macro deactivation problem and keep ya' posted when...

Hello, I'm trying to use the ThisWorkbook.Open() event in an xl97 workbook (code originally written in xl2002) with multiple worksheets to .Protect/.Unprotect the macros running within each worksheet. The macros run correctly on the first fire, but upon the creation (using...

With both of your assistance.....sure to make this work.....will keep ya posted. Thanks!

TLady.....thanks for the help....will work on integrating this code into my procedure. CosmoKramer.....re: code necessary.....Not sure if this code is necessary or not....copied it from another newsgroup post. Would you consider sending me the code that you DO use? Again, thanks!

I don't have to use the Contacts in Outlook.....I just don't know any other method for sending the emails. My main purpose is to get the data from Access to Outlook and then send the reports to each individual (or grouped) email address. The relationship for the records is: Vendor ID = Email...

Yep....got it installed. One thing that occurs to me now is, do I have to have the Contacts set up in Outlook BEFORE I try to send the emails over from Access? I thought not, because the unique IDs will change based on the reports that are generated in Access each time the sub procedure is...

Hello All, Need assistance for MS Access to Outlook XP tasks using Visual Basic....here's the problem: Have a dBase set up that generates reports based on multiple ID's with page breaks separating the distinct records. This report is based on a CLICK event in the form's sub procedure. The...

Hello, I recently found coding on your site that saves a MS Access file to .pdf and then emails it using MS Outlook (see faq703-2533). I have attempted to run my code and keep receiving this MsgBox error "User-defined type not defined" at line: Dim appOutLook As Outlook.Application...

Thanks for the help....johnwm....this is the code that you helped me out with last week for copying from one worksheet to another....I almost have it.....ADoozer.....your faq was super....I forwarded it to our dBase Sup also....gracias

Thanks for your quick response, Mark. I'm still having trouble placing the "Static Count = 0" code in the procedure. Here's what I have now. What am I not seeing? I've searched Help feature....just cannot make the code work. One note, once the Adj 1 is created, Adj 2 is copied...

Hello, Working in Excel XP and need assistance with VB coding listed below. Trying to copy the ActiveSheet and rename the sucessive sheets. VB gives me a 'Run-time error' that says, "Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook...

My responses: I appreciate all of your assistance.....I'm still struggling with the logic of this procedure....new at this stuff. To: johnwm, I did consult the VBA help feature. To: mwolf00, I need to work more on the nesting to get it right. To: foada, I'm using your logic and should be able to...

Hello, I need assistance with a compile error that I cannot resolve - "Else without If". The error occurs when the it hits the first 'Else' within "Budget Form (2)" code (see code below). Here's what I'm trying to do: Copy Budget Form to Budget Form 2 if user clicks on...

User Loomah asks: What do you mean by properties? My response: Sheet1 formatting (properties) should match Sheet2 formatting exactly except for the column headings and some protected text in Sheet2. Thanks for the information on posting to VBA forum and the code for the subroutine. My...

Problem: The worksheet is comprised of Sheet1 that has calculated fields and macro buttons that: a) add rows to the sheet; and b) should create a copy of Sheet1 properties with the calculated fields (no data, just formulas) to Sheet2. Is there an Excel function that will copy the properties...