saltkev
Active Member
- Joined
- Oct 21, 2010
- Messages
- 324
- Office Version
- 2013
- Platform
- Windows
Hello
I wonder could someone help, I seem to be missing a trick. I have a variable which hold the following information. Lets call it variable1
If I then say
The code falls over, however if I write the statement in full still using "With" there are no problems.
Many Thanks
P.S The objective is to import a CSV file.
I wonder could someone help, I seem to be missing a trick. I have a variable which hold the following information. Lets call it variable1
Code:
ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\Users\keames1\Desktop\Configuration Item.csv", Destination:=Range("$A$1"))
If I then say
Code:
With Variable1
The code falls over, however if I write the statement in full still using "With" there are no problems.
Many Thanks
P.S The objective is to import a CSV file.