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!

xlwk.sheets(1) question

Status
Not open for further replies.
qureshi

qureshi

Programmer
Mar 17, 2002
104
AU
Hi,
Is it possible to have a variable in the above statement
e.g.
xlwk.sheets(SheetName).select

the worksheets i am trying to get have been renamed in the format ER0001,ER0010,ER1022 etc

Any help will be appreciated
Qureshi
 
Status
Not open for further replies.

Similar threads

rdpress
  • Locked
  • Question
Question Open Shellling to File Explorer
Replies
3
Views
218
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
541
dhookom
dhookom
RolandR
  • Locked
  • Question
Access Rich Text Memo Field Question
Replies
1
Views
236
RolandR
RolandR
priac
  • Locked
  • Question
Windows 10 Camera
Replies
2
Views
383
strongm
strongm
VickyC
  • Locked
  • Question
Field question in DAO 1
Replies
3
Views
149
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top