sdv file question

[Ruben Mikkelsen]

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

 

[Fredrik Wahlgren]

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]

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]

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]

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]

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