Creating multiple spreadsheets based on text

charlesdh · #1 04-06-2015, 11:30 AM

Hi,

I modified this part of the code.

Code:

On Error Resume Next
                Workbooks.Open Filename:=MyPath & "\" & Item & ".xlsx", UpdateLinks:=0
                If Err = "1004" Then '' this will be chaned when you determine if you want to create a new vendor workbook
                    MsgBox " Hi! At this point you need to create a new file for this Vendor will now exit sub"
                Exit Sub
                End If

ksigcajun · #2 04-06-2015, 11:36 AM

Quote:

Originally Posted by charlesdh

Hi,

I modified this part of the code.

Code:

On Error Resume Next
                Workbooks.Open Filename:=MyPath & "\" & Item & ".xlsx", UpdateLinks:=0
                If Err = "1004" Then '' this will be chaned when you determine if you want to create a new vendor workbook
                    MsgBox " Hi! At this point you need to create a new file for this Vendor will now exit sub"
                Exit Sub
                End If

Didnt change anything, that I saw. Still filters, copies, message box is displayed and thats it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a table that automatically updates based on entries of a heading in the document	cahphoenix	Word	3	10-29-2014 01:11 PM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Need help creating a Word document that is populated based on certain selected values	alidaanish	Word	1	01-10-2014 10:44 PM
Creating Report based on 'Task Summary' and 'Sub Tasks'	alijahed	Project	1	02-01-2013 04:20 AM
Creating formula based on if data is correct in cell	MattMurdock	Excel	1	08-06-2012 03:11 AM