Save tab-delimited file to .IIF, not .TXT?

[ElBombay]

I've written a program that creates an upload file for Quickbooks but QB only recognizes the IIF extension. I have to manually copy *.TXT to *.IIF before QB will load it. Can Excel export the tab file with the IIF extension instead?

 

[Joe4]

What kind of program is this?
If it is VBA, you can program the file renaming part right into the VBA.
If you post your VBA code, we can help you do that part.

 

[ElBombay]

What kind of program is this?
If it is VBA, you can program the file renaming part right into the VBA.
If you post your VBA code, we can help you do that part.

Thanks. Here is the relevant bloc of code. It will obviously need memory variables to accommodate dynamic bottom-rows and filenames. We've got almost 100 statements to load and not a lot of to for cut & paste. Another client taken by surprise by the approach of year-end.

/*
'--------------------------------------------------------------------------------------------
Sub IIF_Create()
'
' Export reformatted data per QB specs
' 12/8/21
'
Save file
Range("A1").Select
Selection.End(xlDown).Select
Range("A1:I144").Select
Range("I144").Activate
ActiveWorkbook.SaveAs Filename:= _
"C:\Finances\QBooks\25SEP21B.txt", FileFormat:=xlText, _
CreateBackup:=False

End Sub
'--------------------------------------------------------------------------------------------
*/

 

[Joe4]

It looks like that is what you are telling it to do, right in your code.
Just try changing thie line:

"C:\Finances\QBooks\25SEP21B.txt", FileFormat:=xlText, _

to this:

"C:\Finances\QBooks\25SEP21B.iif", FileFormat:=xlText, _

 

[ElBombay]

It looks like that is what you are telling it to do, right in your code.
Just try changing thie line:

"C:\Finances\QBooks\25SEP21B.txt", FileFormat:=xlText, _

to this:

"C:\Finances\QBooks\25SEP21B.iif", FileFormat:=xlText, _

Thanks. Fresh eyes and a clear mind. I couldn't switch to IIF when recording the macro; the Dialog Box just tacked .TXT on to my [name].IIF. I had tunnel vision about changing it in the code.

As I was wos,figddlingg with the problem (including some pretty dense code by the board member Stacker) I tried the NAME command. This problem is solved but for future refence, do you see why the code below bombs at the starred line?


/*
Sub VBA_Name_Function_Ex1()

Dim sFileName1 As String, sFileName2 As String

sFileName1 = "C:\Users\Jim Gleason\Finances\QBooks\25SEP21B.TXT"
sFileName2 = "C:\Users\Jim Gleason\Finances\QBooks\25SEP21B.IIF"

** Name sFileName1 As sFileName2 **

End Sub
*/

 

[Joe4]

Thanks. Fresh eyes and a clear mind. I couldn't switch to IIF when recording the macro; the Dialog Box just tacked .TXT on to my [name].IIF. I had tunnel vision about changing it in the code.

Yes, while the Macro Recorder can be a great tool to get you started, it often requires a little bit of editing after completion to make the code more dynamic and streamlined.
I usually consider it a "starting point"; seldom is the recorded code a good finished product.

As I was wos,figddlingg with the problem (including some pretty dense code by the board member Stacker) I tried the NAME command. This problem is solved but for future refence, do you see why the code below bombs at the starred line?


/*
Sub VBA_Name_Function_Ex1()

Dim sFileName1 As String, sFileName2 As String

sFileName1 = "C:\Users\Jim Gleason\Finances\QBooks\25SEP21B.TXT"
sFileName2 = "C:\Users\Jim Gleason\Finances\QBooks\25SEP21B.IIF"

** Name sFileName1 As sFileName2 **

End Sub
*/

Your code worked just fine for me. What kind of error message do you get? What exactly does it say?