#Install visual basic for mac excel 2011 code#
The code clears that sheet's content and replaces it with the data from the opened files. csv files, then I run if statements depending on the name of the file in order to insert it into a specific sheet on my main workbook. MsgBox "We skip this file : " & MySplit(N) & " because it is already open" MsgBox ("File not set in macro, please add it where this message appears in the code and reselect the file in question") 'if this message appears, simply add a "elseif" like the ones above with part of the name of the file and sheet name Mybook.Sheets(1).Cells.Copy Proactive.Worksheets("resetting").Range("A1") Proactive.Sheets("resetting").UsedRange.Clear Mybook.Sheets(1).Cells.Copy Proactive.Worksheets("tripstatistics").Range("A1")ĮlseIf mybook.Name Like "*resetting*" Then Proactive.Sheets("tripstatistics").UsedRange.Clear Mybook.Sheets(1).Cells.Copy Proactive.Worksheets("ReinitiateActivationJobPending").Range("A1")ĮlseIf mybook.Name Like "*tripstatistics*" Then Proactive.Sheets("ReinitiateActivationJobPending").UsedRange.Clear Mybook.Sheets(1).Cells.Copy Proactive.Worksheets("ERROR1302").Range("A1")ĮlseIf mybook.Name Like "*ReinitiateActivationJobPending*" Then Proactive.Sheets("ERROR1302").UsedRange.Clear Mybook.Sheets(1).Cells.Copy Proactive.Worksheets("ERROR207").Range("A1")ĮlseIf mybook.Name Like "*ERROR1302*" Then Proactive.Sheets("ERROR207").UsedRange.Clear 'Get file name only and test if it is openįname = Right(MySplit(N), Len(MySplit(N)) - InStrRev(MySplit(N), _ 'We can do things with the file paths now like I show you belowįor N = LBound(MySplit) To UBound(MySplit) 'If you select one or more files MyFiles is not empty "set text item delimiters to TID" & vbNewLine & _ "set thePOSIXFiles to thePOSIXFiles as text" & vbNewLine & _
#Install visual basic for mac excel 2011 how to#
'See to know how to use other and more formats.įileFormat = "" & vbNewLine & _ 'In this example you can only select csv files Set Proactive = Workbooks("Proactive Cleaning_V2.0.1.xlsm") 'Here we set the proactive file to be named Proactive in the function 'Select files in Mac Excel with the format that you want I've been struggling with this code: Sub Select_File_Or_Files_Mac()
0 kommentar(er)
