I installed Microsoft office 2010 and I cannot get my Excel VBA macro to run. Specifically the VBA is supposed to grab a Text file(Note Pad) and parse into columns in excel. Can someone help me? I have included part of the VBA code below.
Today = Application.InputBox(Prompt:="Enter Dispatch Text file's date you want to extract (ex. 09-30-10)?", Type:=2)
firstRow = 4
Do While Cells(firstRow, 1) = ""
firstRow = firstRow + 1
Loop
firstRow = firstRow - 1
startday = Format(Today, "mm - dd - yy")
Path = "E:\Planning\Dispatch Report\" & Today & ".txt"
Today = Application.InputBox(Prompt:="Enter Dispatch Text file's date you want to extract (ex. 09-30-10)?", Type:=2)
firstRow = 4
Do While Cells(firstRow, 1) = ""
firstRow = firstRow + 1
Loop
firstRow = firstRow - 1
startday = Format(Today, "mm - dd - yy")
Path = "E:\Planning\Dispatch Report\" & Today & ".txt"
Last edited: