I am trying to manipulate some Excel worksheets and outlook objects for sending mail from the VBA in Access 97.
Is this impossible without using VB directly or something?? Cos I can't even do something like the following results in complilation errors complaining that Worksheet is unknown-
Dim myWorksheet as Worksheet. I basically want to do things like select different cells, and process them, and with Outlook Objects, I want to use them to send mail
If these really are impossible tasks without using VB, then are there any utilities for porting the code from Access VBA's Form to VB?? or would Copy & Paste simply do?? (Note that there are differences like DoCmd OpenForm "myForm" in VBA and myForm.Open() in VB)!
MAny Thanks! [sig][/sig]
Is this impossible without using VB directly or something?? Cos I can't even do something like the following results in complilation errors complaining that Worksheet is unknown-
Dim myWorksheet as Worksheet. I basically want to do things like select different cells, and process them, and with Outlook Objects, I want to use them to send mail
If these really are impossible tasks without using VB, then are there any utilities for porting the code from Access VBA's Form to VB?? or would Copy & Paste simply do?? (Note that there are differences like DoCmd OpenForm "myForm" in VBA and myForm.Open() in VB)!
MAny Thanks! [sig][/sig]