Using excel through dde?

  • Thread starter Thread starter mkichar
  • Start date Start date
M

mkichar

Hah, please forgive me as this topic is probably too advance for m
knowledge and you will probably get fustrated trying to explain this t
me. I apoligyze in advance. I wrote a script that allows me to sor
through a text file that I have on my computer, and see who is almos
due, overdue, and never trained at my work. Now I need this program t
reference excel (perferabbly through dde, never messed with OLE) an
simply has this information put in certain cells. I was hoping fo
something simple like /dde excel workbook.xls a1="name", etc but hav
no idea :( Any help would be GREATLY appreciated. I am using Exce
2003
 
mkichar

DDE will certainly not be an easy option, but if you can open the text file
in Excel, why not then do any manipukation there using VBA or functions. To
see if your text file will open in Excel, simply go to File>Open and change
the 'files of type' to either '*.txt' or 'all files'. This will invoke the
wizard which you can navigate simply adjusting the settings as you go.

Once you have done this successfully, then do it again, this time recording
it as a macro (Tools>Macros>Record New Macro). You may well have to addapt
the code to suit later 'loads' but it will be much esaier to manipulate now
you have it in Excel.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top