MS Access macro interface with Excel question

  • Thread starter Thread starter luis.a.roman
  • Start date Start date
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.

Luis
 
Back
Top