Blank columns to start

[dodge20]

Is there a way to stop excel from dropping the initial blank columns on a spreadsheet? I receive spreadsheets that I load into an informix database, and a lot of times I want the first several columns blank. When I save it as text (pipe delimited), it drops off the blank initial columns. Is there a way to prevent this? Dodge20
If it ain't broke, don't fix it.

 

[Nikita6003]

Hiya

If your Informix db will stand it, try using column headers in your first row; this'll force Excel to deliver the empty columns as well

If necessary, you can always remove the first row containing the dummy field names

HTH

Cheers
Nikki

 

[RobBroekhuis]

If you're using my code from a previous post to generate the pipe-delimited text file, the problem arises from using the usedrange property. In that case, you could

a) apply some formatting to a cell in the first column, e.g. make it bold. Even if it's empty, this will cause it to be included in the usedrange

b) slightly retool the code so it will automatically include these columns. I can help with that, if you'd like.

Rob

 

[dodge20]

Thanks you 2. Rob if you would like to help me I would be most appreciative. I am curious to how this will work. Dodge20
If it ain't broke, don't fix it.

 

[RobBroekhuis]

I will follow up in original thread, so I can copy and modify the code.
Rob