I can't Run My VBA with MSOffice 2010

chelseaaa

New Member
Joined
Nov 7, 2010
Messages
18
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"
 
Last edited:

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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?
 

Forum statistics

Threads
1,170,988
Messages
5,873,156
Members
432,964
Latest member
bankeris

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top