Excel columns - Nevermind

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
cvlr
Newbie
Posts: 18
Joined: Thu Jun 07, 2018 4:40 pm

Excel columns - Nevermind

Post by cvlr » Fri Jun 29, 2018 2:00 pm

I'll just create blank templates ahead of time and populate those with the built in functions that don't cause problems.

Without using the vbeval function is there a way to format the size of an excel column? I have a script which creates a spreadsheet based on oracle data but then it has to save it and reopen it with the vb workbooks app functions to do the sizing which works but results in a memory access violation error about 50 to 75 percent of the time. I need something that is more stable.

User avatar
Meryl
Staff
Posts: 124
Joined: Wed Sep 19, 2012 1:53 pm
Location: Texas
Contact:

Re: Excel columns - Nevermind

Post by Meryl » Mon Jul 02, 2018 2:11 pm

So you're all good? Or still having problems?

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts