L
luis.a.roman
I'm working on an access macro that will open a directory and select
all the excel files and parse them prior to load to access.
Problem is that when I read the first file everything works correct.
However, when I read the second file the insert instruction does not
work. Can someone help me correct this problem? I know that it is
possible but I can not figure it out.
The code is below.
Sub xAlphaCharacters(W As Excel.Worksheet)
Dim rowValue As Integer, interValue As String, loopcnt As Integer
Dim raR As Excel.Range, i As Integer
Set raR = W.Cells(3, 1)
W.Columns("F:F").Selection.Insert Shift:=xlToRight
Note: It does not process the above vba statement. It says a message
that I need to clear the non blanks.
Your collaboration will be appreciated.
all the excel files and parse them prior to load to access.
Problem is that when I read the first file everything works correct.
However, when I read the second file the insert instruction does not
work. Can someone help me correct this problem? I know that it is
possible but I can not figure it out.
The code is below.
Sub xAlphaCharacters(W As Excel.Worksheet)
Dim rowValue As Integer, interValue As String, loopcnt As Integer
Dim raR As Excel.Range, i As Integer
Set raR = W.Cells(3, 1)
W.Columns("F:F").Selection.Insert Shift:=xlToRight
Note: It does not process the above vba statement. It says a message
that I need to clear the non blanks.
Your collaboration will be appreciated.