Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pasing Arguments To Excel Macro From Access

Status
Not open for further replies.
Aidy680

Aidy680

Technical User
Nov 1, 2006
138
GB
Can anyone tell me why this wont work.

I run it from Access calling it in Excel:

xlApp.Run "'Z:\Test1\Spreadsheet.xls\ATOM_DividendInfo.xls'!GetDividendInfo dteStartDate, dteEndDate"

It's the arguments I'm having problems with. Without them it runs fine.
 
Sort by date Sort by votes
...just noticed. Sorry about the spelling. In a rush...
 
Upvote 0 Downvote
...the error message says that it doesnt exist!?
 
Upvote 0 Downvote
...and the answer is:


xlApp.Run "'Z:\Test1\Spreadsheet.xls\ATOM_DividendInfo.xls'!GetDividendInfo", dteStartDate, dteEndDate


Cheers!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
388
Viswa.R
Viswa.R
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
2K
lameid
lameid
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
528
Andrzejek
Andrzejek
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
817
Knicks
Knicks

Part and Inventory Search

Sponsor

Back
Top