Re: Access to Excel

Hi Steve,

If by "action arguments" you mean things you type into the fields in an
Access macro grid, the answer is no. The only way to do what you want is
with VBA code.

Probably the best resource is a good beginner's Access book. I'm not
going to recommend one, because everyone has different ideas of the kind
of book they learn from best. But if you look at the shelves in a good
bookshop you should find an assortment; pick one you like, as long as it
has chapters that cover VBA and, preferably, Automation.

Also, take a look at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
where there are links to a huge amount of information on using Access.

On Mon, 19 Feb 2007 00:52:16 -0800, Steve.M
<SteveM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

John I really apreciate your feed back. As I was reading your reply I could
see that I was clearly over my head. I am guessing that what you were giving
me were action arguements.

I have read over some of them and I simply don't understand the language in
them or where and how they are applied.

Can you point me to a resource that can show me these things? I searched all
over the help files in Office and read all kinds of posts here but I can't
find the command stuctures terms and symbols that you guys are using let
alone where to place them in the macro box.

But I'll tell you this, when I figure this out I'll be the hero in our
office at work : )

"John Nurick" wrote:

Hi Steve,

Naming fields with words that are also the names of common functions or
properties sooner or later causes problems, so don't use "Name" as a
name. Use something else, e.g. PartName.

The general idea is

1) set a reference to the Microsoft Excel Object Library

2) Then use VBA code along these lines (this is untested air code):

Dim oBook As Excel.Workbook
Dim strPartName As String

Set oBook = GetObject("D:\Folder\File.xls")

'need to add a criterion to the next line to specify the record
strPartName = DLookup("PartName", "MyTable", ???)

oBook.Names("PartName").Value = strPartName

oBook.Close True


On Fri, 16 Feb 2007 21:07:22 -0800, Steve.M
<SteveM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Basically I want to type a name in an access table/field titled name. I want
the name to simply be inserted in a cell named name in excel. I want that
done on 3 excel forms.

The excel forms are just report forms with a description part number etc. no
calculations or special features, just type and save.

Everything I have read seems to say that I can, but how? Please help.

--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.


--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.
.

Relevant Pages

  • Re: Excel Calcs in Access
    ... pefrom this in access since i have about 30000 rows in excel to do this to, ... "John Nurick" wrote: ... below is the result of the same query but 1 line above. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.modulesdaovba)
  • Re: Excel Calcs in Access
    ... show below looks to me like an Excel sheet with one column of ... "John Nurick" wrote: ... below is the result of the same query but 1 line above. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.modulesdaovba)
  • Re: Excel Calcs in Access
    ... Import it from an excel spreadsheet into a table. ... "John Nurick" wrote: ... below is the result of the same query but 1 line above. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problem with Follow Hyperlink
    ... "John Nurick" wrote: ... Type the location of an Excel file (e.g. ... UntilTime = DateAdd("s", SecondsToWait, Now()) ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • Re: Make access database from works wdb file
    ... CSV file and importing that into Excel. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
Loading