Macros and save as

[blakrapter]

Hello everyone,

I am having trouble with a macro I am trying to build (the first time I've attempted to create a macro). I have an excel workbook that takes data and manipulates it into a usable format for two different servers I upload to. One server requires a CSV file and the other a txt file. I have the workbook setup such that I have a sheet for each file type.

Currently, I am manually saving the files that have to be uploaded. The way it works is after I paste the updated data in, excel does its thing, then I "save as" in the appropriate sheet to save it as the appropriate file type, save it and repeat for the other file that has to be uploaded.

I want to create a macro to do this, but i cannot get it to work. I think the problem is it changes file names half way through the macro... How can I work around this?

Thanks!

 

[Norie]

Can you post your current code?

 

[blakrapter]

I can give it a shot, however, it will not contain the part of the code where it is failing. I am using the record function rather than coding it by hand, so when I am finished and press stop, it disappears. I cannot find it saved in any of the files (origional where it started, or the csv and txt file I created).

Would it be better to hand code it? My guess is yes it would be, but I have 0 experience in VB.

If there is a way I can capture the code, let me know and i'll post it.

Thanks!