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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open file and get an excel sheet to print

Status
Not open for further replies.
rwweiland

rwweiland

Programmer
Oct 15, 2003
9
US
Hello,
I need to ba able to open a file, get an excel sheet from the file and print it. Is this possible in MS Access VBA? If so can someone please help me?
 
Sort by date Sort by votes
Try the following :

Dim xlWB
Set xlWB = GetObject("Path\FileName")
xlWB.Sheets("Sheet").PrintOut
Set xlWB = Nothing

replacing "Path\FileName" with the XL file full Path and "Sheet" with the name of the sheet you wish to print.

A.C.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Open Word as ReadOnly 1
Replies
6
Views
384
Chriss Miller
C
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
392
dhookom
dhookom
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
662
mikrom
mikrom
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
968
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top