Macros Import |

[Doru Gherghin]

I currently have an excel worksheet set to import certain values from a Text file. Below code was written to import certain values from specific ranges in the text file.

Basically on my excell worksheet the cell D23 imports a range of values from the text file. The range is named WPB = Range("$E$46") - Range("$E$44") - Range("$B$30")


Now the import works perfectly for Infort and Nabbert text files however Rotton text file has a diffrent configuration and the import does not work.

For the the import to work on Rotton the range should be WPB = Range("$E$66") - Range("$E$64") - Range("$B$30")

How can I adjust the code to keep so it works for all 3 text files considedring the range for Rotton is diffrent? Basically I do not want to create anothere excecl worksheet for Rotton only, my goal is to have the same excel worksheet to import the files regardless of their configuration

Please Login or Register  to view this content.

[Richard Buttrey]

Hi, and welcome to the forum.

Please take a moment to read the forum rules. Code like this should be enclosed in CODE tags. It helps immensely with readability. I'll change it for you on this occasion but note for the future.

Why not just put the exception in the Case statement and populate the WPB variable before the Case statements. e.g.

Please Login or Register  to view this content.

[Doru Gherghin]

Thank you for the quick reply, did that but now the import works perfect for Rotton however when I use Infort or Nabbert the import is not done correctly.
To give you an example: E46 is 1447, E44 is 0 then B30 is 410, correct import figure should be 1037, however right now shows -410. To mention each file has the name of the text file on range B3, so I was thinking to put in a condition to say if the file is Rotton import this range, however if the file is Infort or Nabbert import this range.

[Richard Buttrey]

Hi,

Have you stepped through the macro to see what the WPB variable is when you get to it?

I see no reason why this doesn't work so would you upload both the workbook containing the macro and the sts_fgv.0.9 file.