Will Excel macros work in Access 97? 1

[chuck74]

I have a series of macros that I use in excel. I want to find a way to do my work in access instead. Can I copy/import a macro into Access from Excel? Are there more choices than the &quot;actions&quot; dropdown list contains in the macros design view? Can I get Excel formulas into Access as well? Any help would be great.<br>
<br>
Thanks<br>
Chuck74

 

[DougP]

Macro's and VBA are specific to each Program.<br>
So yes and no to answer your question.<br>
The words &quot;IF Then Else&quot; works in all of them.<br>
As do &quot;DO LOOP&quot; and other commands words<br>
<br>
But to refer to a Cell in Excel is not used in Access.<br>
Cause Access uses Record sets.<br>
It depends on what you want to do.<br>
If you want to open a recordset then you can usually use the exact same code<br>
i.e.<br>
dim db as database, rst as recordset <br>
set db = opendatabase(&quot;blahblahblah&quot<br>
<br>
and so forth.<br>
<br>
Hope this Helps<br>
DougP<br>

 

[DougP]

Yes to the formulas<br>
Go to help in Access and type in the function name.<br>
Now Access does not do the really complicated ones such as finacial ones that have to do with mortgages and interest<br>
where you give it several parameters. heres one for example &quot;CUMIPMT&quot; <br>
<br>
But thats why they invented VBA<br>
you could create a function like<br>
x=CUMIPMT((0.0075,360,125000,13,24,0)<br>
<br>
Public Function CUMIPMT (Value1,Value2,Value3,Value4,Value5)<br>
'do the calculations here<br>
End Function<br>
<br>
If you know the formula you can recreate it in VBA<br>
I've done some wild things there.<br>
<br>
I have really not found anything at all that I can not do in Access period. I have used it for 7 years since version 1.1