Hard code the workbook name in macro

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a macro to delete a worksheet.
When its run multiple excel files are open. To be sure it doens't accidently
delete the sheet from the wrong file, how can I hardcode the workbook name
into my macro. Assume my workbook is called myFile.xls

Bruce

Sub DelSheets()
Sheets("Sheet2").Delete
End Sub
 
Hi,

Try this with the name changed to your other workbook

Workbooks("Otherbook.xls").Sheets("Sheet2").Delete

Mike
 
When you open the workbook set an object to the workbook

set bk = workbooks.open(filename:=book1.xls)

set sourceSht = bk.sheets("sheet1")
MyName = Sourcesht.Range("A1")

bk.close savechanges:=false
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for all Excel Workbooks to print to PDF 2
Run macro from active workbook whose name keeps changing 20
Problem in adding macro to ribbon through Add-in 7
Copying cells and formula from closed workbook to all sheets in open workbook 0
Run code from another workbook 7
Error Message - Macro to Unlink MS Queries from Workbook 0
Delete Worksheets Named Sheet1, Sheet2, Sheet3, etc. 7
Run macro on all files in a specific folder 3

Back
Top