LinkBack URL
About LinkBacks
How could i get the below code to work with a variable as the file name?
Or could I use something like "thisfile" to determine where to import to.
thanks in advance
Please Login or Register to view this content.
How could i get the below code to work with a variable as the file name?
Or could I use something like "thisfile" to determine where to import to.
thanks in advancePlease Login or Register to view this content.
Hi, ratdogexcel,
ThisWorkbook could be used to rely on the workbook with the code:
You should rename Sheet to a different name.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
HaHoBe
that works a treat. thanks
Out of interest........... Why should I rename my sheet?
Hi, ratdogexcel,
I for my part try to use different names for variables and leave the VBA Keywords alone because using them inside a procedure may interfere with their normal usage as the local variable sort of overwrites the VBA meaning for that procedure.
Ciao,
Holger
oh so you are talking about this name
Workbooks("exportedCSV.csv").Worksheets.Count
Hi, ratdogexcel,
not exactly, I was after
Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks