P
PurdueNate
Hello. I am having problems correctly implementing the TransferSpreadsheet
Macro. I have am constantly updating an excel spreadsheet and want the
changes reflected in my database. Whenever I make an update to the
spreadsheet, it is saved and then I want my database to go out and import the
spreadsheet data.
The problem that I am running into is that the Transfer Spreadsheet Action
asks for a specified range. Since my file is always changing I'd like for it
just to reference the last value in the spreadsheet. As I understand it (and
I may be wrong b/c I'm a bit of a newbie), the EOF command will let me go to
the end of the file - the last row in the spreadsheet. This would be great
if I could get it to work. Problem is, when I type "A1:EOF" in for the
range, I get an error.
Am I just implementing this incorrectly or am I not able to use the EOF
command at all?
Thanks a bunch in advance for the help.
Macro. I have am constantly updating an excel spreadsheet and want the
changes reflected in my database. Whenever I make an update to the
spreadsheet, it is saved and then I want my database to go out and import the
spreadsheet data.
The problem that I am running into is that the Transfer Spreadsheet Action
asks for a specified range. Since my file is always changing I'd like for it
just to reference the last value in the spreadsheet. As I understand it (and
I may be wrong b/c I'm a bit of a newbie), the EOF command will let me go to
the end of the file - the last row in the spreadsheet. This would be great
if I could get it to work. Problem is, when I type "A1:EOF" in for the
range, I get an error.
Am I just implementing this incorrectly or am I not able to use the EOF
command at all?
Thanks a bunch in advance for the help.