Transfer Spreadsheet (Link) to Specific Worksheet and Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a link, using a macro, to a specific worksheet and range.
What is the syntax?

e.g., I want to link create to worksheet "Sheet1" and range A1:B300 in the
Excel file "C:\Transactions.xls". What values should I type in the macro
fields?
 
In the Macro area

TransferSpreadsheet
type - Link
Table Name - your table name
File Name - Full directory path and file name of where
spreadsheet is.
Has field Names yes or no
Range - [Sheet1]!A1:B300
 
Back
Top