Yes, that makes sense.
Thanks for all your help with this, I really appreciate your time and knowledge.
N2Deep
Last Activity: Aug 8 '08, 04:52 AM
Joined: Aug 1 '08
Location: San Francisco Bay Area
-
You are correct same name .txt instead of .xls.
It worked perfectly thanks!
However, before your reply was posted I was playing with naming the files 1.txt, 2.txt, etc for as many files that run through the macro.
As it ran, I saw in...Code:Dim f As Long f = f + 1 ActiveWorkbook.SaveAs Filename:=f, FileFormat:=xlText, AddToMRU:=False ActiveWorkbook.Close SaveChanges:=False
Leave a comment:
-
This Macro is opening up an excel spreadsheet in a folder, making changes, and then saving it, closing it, and then moving to the next file.
For Filename I don't want to specify (I think you say hardcode) or else when it runs the second file it will have the same name, and that will obviously cause problems. Can I save it with the name it had when it was opened?
I'm just not sure what to put in the "..." below...Leave a comment:
-
NeoPa,
Thank you very much for you help, I appreciate your style of teaching which has been helping me to learn.
I understand everything you are saying in your posts on this thread.
I've tried unsuccessfully many times now since last night. I've tinkered around with these last few lines, but just can't get it to work.
Here is where I'm at:
...Code:ActiveWorkbook.SaveAs FileFormat:=xlTextPrinter
Leave a comment:
-
Saving .xls file as .txt (VBA Excel 03')
I have a macro that does a few things to an Excel workbook and then saves, and closes to an Excel workbook. I now want to save, close the Excel workbook as a text (tab delimited .txt) file.
Currently I am closing/saving the file near the end of my Sub with:
wbResults.Close SaveChanges:=Tr ue
Dim wbResults As Workbook...at the beggining of my sub.
I've tried many things and can't seem to... -
Yes that makes sense...thank you.Leave a comment:
-
Janders468...th ank you very much for that. I added EntireRow (ActiveCell.Row s.EntireRow.Del ete) and it worked like a charm.
NeoPa...thank you for helping me understand. I see what you are saying about lines 18 & 16. I do also understand about starting from the bottom, but would you recommend that in this case where I sometimes I have up to 30k+ lines of data?Leave a comment:
-
VBA for Excel 03' need help with delete row macro
I'm new at trying to write VBA, and have been working on this delete loop for a while, and could use some help.
I want the macro to start in cell B1, if it finds the string "Contract Type" in cell B1 I want it to delete that entire row and exit (Contract Type will only ever appear in cell B1).
If it doesn't find string "Contract Type" in above, I would like it to move down the B column one cell at... -
Thanks for your response.
I'm importing .txt files into Access, and that is where the duplicates are coming in from.Leave a comment:
-
Deleting Duplicate Serial Numbers in Access Field (2003)
I have a table named SUPPORT DATA, I have a field named Serial Number. In the Serial Number field I have many duplicates, and I only want one of each.
Sample serials ABB045000MG, JBX05050016
Until now I have been running an update query which identifies the duplicate serial numbers in the SUPPORT DATA table by:
In (SELECT [Serial number] FROM [SUPPORT DATA] As Tmp GROUP BY [serial number] HAVING Count(*)>1...
No activity results to display
Leave a comment: