Re: Help with DDE Dynamic Data Exchange

I found this on the web. Does most of the work for me, now I just have to
write a Macro to auto import the data.

http://redmondmag.com/forums/forum_posts.asp?tid=2362&pn=1
Hank - Sometimes beating ones head against the wall opens the Google
floodgates, and the answers come streaming in. Beating head,. helps open
ones query verbage.


"Hank Rouse" <hank_top_sf@xxxxxxxxxxx> wrote in message
news:zhgBf.24785$PL5.2793@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I'm writing a macro that will run DSQUERY * Which opens a command prompt
> and tells me all the machines in my Active Directory.
>
> Problem is I need assistance in instructing Access to bring this data in
and
> create a TBL, so DDE is where my problem is.
>
> Data will be used against another data source to verify clients are
> reporting into ePO correctly.
>
> Thanks,
> Hank
>


.

Relevant Pages

  • Re: Complicated Merge with Comments
    ... that allows that control to be exerted. ... and saved into seperate files with the name of a particular field within a ... > 4) The macro also takes each newly created file and inserts a header file ... > 'This code opens the directory with the brpt file. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Cannot Utilize a Macro When Excel Is Opened By Another Program
    ... MST must be starting Excel in safe modewhich by-passes XLSTART ... Run Macro, Break, Reset or Design Mode. ... i.e. the workbook just created. ...
    (microsoft.public.excel)
  • Re: The Strange Case of the Disappearing Document - Followup
    ... the Word error message is caught in an infinite loop; ... Beth; it *seems* that the macro is opening the log ... Sometimes the boss opens the file to get statistics, ... I suspect the file is there but as a temp file. ...
    (microsoft.public.word.application.errors)
  • Re: Folder Shortcuts / Word 2003 / Mail merge Fields / Odd Issue A
    ... > you open has an AutoOpen macro that opens another document then closes,> or ... the template opened by Word on the rogue machine has an AutoOpen ... >>> macro ...
    (microsoft.public.word.docmanagement)
  • Re: Cannot Utilize a Macro When Excel Is Opened By Another Program
    ... and then selecting Run Macro. ... I agree that the workbook that MST ... Perhaps due to the method that MST creates a new workbook and opens ... To where does the Excel spreadsheet of data get "exported" when you ...
    (microsoft.public.excel)