access violation 0cx0000005 in vba excel

N

ngm

Dear recipient:

I have this error access violatio 0cx0000005 to open file excel,
generate this file in code vba.Don't have idea where is the error.

I have a next code fragment

For p = 0 To num_pems - 1
Workbooks(libro_paquete).Activate
Sheets("MFisicas " & pems(p)).Select
MsgBox "pem i" & pems(p)
Sheets("MFisicas " & pems(p)).Delete
Next
Application.DisplayAlerts = True


Workbooks(libro_paquete).Save
Workbooks(libro_paquete).Close

if elimite the sentence for to open file correct.

Can you help me please?

Regards
 

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

Save workbook without shapes 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
how do i loop thru all the worksheets in 2 files one by one 0
VBA Coding Help for Beginner 0
VBA for Dependents shortcut menu 0
Run macro on all files in a specific folder 3
excel macro to open word doc besed on user selection 1

Top