Re: Access to Excel

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.

.

Relevant Pages

  • Re: Exporting Hierarchy to Excel (Jack`s Macro)
    ... Thanks John For your guide, ... Now an empty Excel ... Sub dwn ... How exactly did you copy Jack's code into the VB editor? ...
    (microsoft.public.project)
  • Re: Help!!! Excel column is invalid when spreadsheet is linked as
    ... Thanks a lot, John, I saw the link you indicate also in another mail and I ... I cannot make the same change in the registry of the users' ... but deadly problem with Excel and Access. ... but NOT on my PC if I copy the DB and the Excel sheet! ...
    (microsoft.public.access.externaldata)
  • Re: Lookup latest entry 1
    ... Excel will automatically enclose the formula in braces, ... Miller, John, CA23, 52000, 1 ... John's sales figure would be ...
    (microsoft.public.excel)
  • Re: Merge actuals from 2 seperate tasks?
    ... post would have elicited a better response. ... There is a merge feature when data is imported from another application ... (e.g. Excel), but I don't know of any merge functions for an existing ... John ...
    (microsoft.public.project)
  • Re: Find & Replace Whole Words
    ... John, I had another thought. ... I do not think Excel has the functionality you require built-in. ... string or a whole string, NOT a whole word within a string. ... I am sure there are ways do this in VBA, but I cannot think of anything ...
    (microsoft.public.excel.programming)
Loading