Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to read sheet of currently opened workbook
Hello,
I'm trying to write som VBA code (in Access) that will read the contents of an excel file. It's a web query, so I can't just open it normally. The excel file reloads data every 60 seconds, and I want to transfer that into Access, so I need to have Access read the file that's opened (not saved - actually, I could create a function in Excel that saves every 59 seconds, and then just keep reopening it from Access, but I'd prefer a direct read from the opened file). Any ideas on how to connect to the currently running Excel process with VBA? Thanks, Bodi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to read sheet of currently opened workbook
Afraid not. Never looked at it and never done any Access programming.
It would however be fairly simple to have an Ontime command running to write your Excel data to an Access table every minute and have Access look at itself. I would have thought that was an easier way around. Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "Jedi" wrote in message able.rogers.com... Hello, I'm trying to write som VBA code (in Access) that will read the contents of an excel file. It's a web query, so I can't just open it normally. The excel file reloads data every 60 seconds, and I want to transfer that into Access, so I need to have Access read the file that's opened (not saved - actually, I could create a function in Excel that saves every 59 seconds, and then just keep reopening it from Access, but I'd prefer a direct read from the opened file). Any ideas on how to connect to the currently running Excel process with VBA? Thanks, Bodi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit to number of opened Read Onlys | Excel Discussion (Misc queries) | |||
Excel files suddenly "read only" or encrypted and cannot be opened | Excel Discussion (Misc queries) | |||
Read-only access by SHEET (not workbook). Is it possible? | Excel Worksheet Functions | |||
Excel file opened as read-only, if saved by another user | Excel Discussion (Misc queries) | |||
Rules that act on messages after they are opened & read? | Excel Discussion (Misc queries) |