I can't Run My VBA with MSOffice 2010

[chelseaaa]

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"

 

[Smitty]

You haven't really posted enough to see what does/doesn't work.

Where does the code fail? If you step through it does it error on a particular line or does it do nothing? Do you get a specific error message?

 

[chelseaaa]

Never mind it was my fault not MSOffice.

 

[Smitty]

Glad you got it sorted.