Hi

I'm working with an sdv file that contains data that I wish to
retrieve without having to use pivot. My question is if its possible to
perhaps make a program in Visual basic og Excel scripting that would enable
me to get the data more easily. Or if any of
you have suggestions I would really appreciate it.

regards

Ruben

"Ruben Mikkelsen" wrote in message
...
Hi

I'm working with an sdv file that contains data that I wish to
retrieve without having to use pivot. My question is if its possible to
perhaps make a program in Visual basic og Excel scripting that would
enable
me to get the data more easily. Or if any of
you have suggestions I would really appreciate it.

regards

Ruben



What is an sdv file? Please explain.

/Fredrik

its an comma seperated file
you open it in excel and its all long lists of data, then you make
an pivot to get the data, the problem is that its time consuming and
difficult to work with the pivot functions in excel

ruben

"Fredrik Wahlgren" wrote in message
...

"Ruben Mikkelsen" wrote in message
...
Hi

I'm working with an sdv file that contains data that I wish to
retrieve without having to use pivot. My question is if its possible to
perhaps make a program in Visual basic og Excel scripting that would
enable
me to get the data more easily. Or if any of
you have suggestions I would really appreciate it.

regards

Ruben



What is an sdv file? Please explain.

/Fredrik

"Ruben Mikkelsen" wrote in message
...
its an comma seperated file
you open it in excel and its all long lists of data, then you make
an pivot to get the data, the problem is that its time consuming and
difficult to work with the pivot functions in excel

ruben


Maybe I'm missing something. If your problem is to create the pivot, use the
macro recorder to capture the necessary steps involved.

/Fredrik

That did indeed solve my problem :) Thank you !
Do by chance know if its possible to take the macros recorded
and copy them to another mashine ? That way I wont have to
record them over and over again for each mashine.

ruben

"Fredrik Wahlgren" wrote in message
...

"Ruben Mikkelsen" wrote in message
...
its an comma seperated file
you open it in excel and its all long lists of data, then you make
an pivot to get the data, the problem is that its time consuming and
difficult to work with the pivot functions in excel

ruben


Maybe I'm missing something. If your problem is to create the pivot, use
the
macro recorder to capture the necessary steps involved.

/Fredrik

"Ruben Mikkelsen" wrote in message
...
That did indeed solve my problem :) Thank you !
Do by chance know if its possible to take the macros recorded
and copy them to another mashine ? That way I wont have to
record them over and over again for each mashine.

ruben

It is. An easy way to transfer the macros is to copy the macro text and then
either paste in to a text file or directly into an email. The recipient must
know how to create a module in the VBA editor, of course.

/Fredrik