I am new at vba coding. I want to link a named range in an Excel spreadsheet to a new Access Table or Query (not sure which way this will work). Linking a named range is easy if it isn't a dynamic range. I have the range named using the offset function to go to the last cell with a value. Because of this it does not show up in my named ranges list during link wizard.
So I have been trying to figure out how DDERequest works. I am able to get DDEInitiate to work and I get the Channel that is needed for the DDERequest function. When I step through the code it stops at 'Application.DDERequest chan, "GroupTime"'. I get error #285 - "The other application can't perform the DDE function or retreival you attempted".
1. I notice that I can get this information in a query cell. Will it work there? How?
2. Is my syntax bad for looking for a named range?
Please help me!?
Nsohenick
So I have been trying to figure out how DDERequest works. I am able to get DDEInitiate to work and I get the Channel that is needed for the DDERequest function. When I step through the code it stops at 'Application.DDERequest chan, "GroupTime"'. I get error #285 - "The other application can't perform the DDE function or retreival you attempted".
1. I notice that I can get this information in a query cell. Will it work there? How?
2. Is my syntax bad for looking for a named range?
Please help me!?
Nsohenick
