Macros and save as

blakrapter

New Member
Joined
Oct 16, 2006
Messages
13
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!
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,831
Office Version
  1. 365
Platform
  1. Windows
Can you post your current code?
 

blakrapter

New Member
Joined
Oct 16, 2006
Messages
13
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top