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.
Excel columns - Nevermind
Moderators: Dorian (MJT support), JRL
Re: Excel columns - Nevermind
So you're all good? Or still having problems?