Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using namespaces in an excel macro.
Hi all,
I've written a small piece of code in vb.net using system.io.filesystemwatcher namespace and it works fine. Dim Watcher As System.IO.FileSystemWatcher Watcher = New System.IO.FileSystemWatcher("C:\Documents and Settings\dpharris\Desktop\dump", "tmp.txt") .. .. The code runs fine. However when I copy this code to an excel macro it says "user defined type not defined" (for the first line). I've tried adding a reference to System.dll under references but it doesn't work. How do I re-use this code ? Thanks. -david. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Call macro stored in Excel workbook from Outlook's macro | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming |