-1

How to delete Column B (Hide+?) in output file?

Garfield

October 12, 2017 12:47

None

Follow

Hi

I have Hide+? in Cell B1.

When I schedule to run the report, all Hide columns and rows are deleted except Hide+? column.

That is I have a blank Column A in the new output file.

How do I get rid of it?

 

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Heather Rowe October 12, 2017 13:12

  I have not found a way to eliminate this column - but you can minimize it.

  With the report in design mode, resize the column to it's smallest possible possible width. 

  Remember, since you have already designed the report - you don't have to be able to read the data in that column.

• 0
  
  Cynthia C.N October 12, 2017 17:48

  Hello Garfield, 

  Another workaround that is available is to 'WHITE OUT' the conditionally hidden column so that you don't see it.
  
  

  Cheers,

• 0
  
  Garfield October 13, 2017 03:25

  Hi All

  The issue is this file will be upload to another program that has strict format.

  I have 20 companies, which means 20 files monthly, manually deleting them will be unproductive.

   

• 0
  
  Heather Rowe October 13, 2017 13:06

  Perhaps VBA code that will cycle through the files in the folder

  1. Open single file
  2. delete the extra column
  3. close the file
  4. open the next file
  5. repeat