D
Donna
Hi
I currently use CreateObject in Access to produce Charts in Excel. I would like to create Journal records on my new tablet PC and link them to records. I'm limited to Office 2002 as I work in the NHS and that's all our IT dept will let me have. For Journal I can't use
Set xlApp = CreateObject("Journal.application")
because presumably it didn't exist in 2002. If i use Shell to open it i think that would work, but I don't think I can then use code to name the file and save it. Any help would be appreciated.
I currently use CreateObject in Access to produce Charts in Excel. I would like to create Journal records on my new tablet PC and link them to records. I'm limited to Office 2002 as I work in the NHS and that's all our IT dept will let me have. For Journal I can't use
Set xlApp = CreateObject("Journal.application")
because presumably it didn't exist in 2002. If i use Shell to open it i think that would work, but I don't think I can then use code to name the file and save it. Any help would be appreciated.