I figure in the worst case I can paste the data into an Excel sheet like I was doing and then import the records into Access, but it'd be nice to just paste into Access.
Thank you, bitRAKE :o)
Please, reply to board
I execute the other program (object really) through a COM interface - programmatically. I don't want to have to do this manually a few thousand times. :o) I wish there was another way to access the data - the interface to some hardware is custom and copywrite with no docs :-> bitRAKE :o)...
First let me say that I'm new to Access, but not VBA :->
I'm using an external program that exports a report to the clipboard. I want to run this a few thousand times and create records in an Access database. In the past I've just pasted the clipboard in an Excel sheet. I can specify what...
if you don't want to turn off all the other alerts you could just set that one file's 'Saved' property to TRUE. That way if the user has other files opened with changes, they wont loose anything.
objXL.ActiveWorkbook.Saved = True
Hope that helps,
bitRAKE 8-)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.