Search found 10 matches

by darnocian
Tue Oct 29, 2019 4:27 pm
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

Thanks Lars,

I don't seem to be getting mails from you.

Thank you for your assistance.

Regards,
Conrad
by darnocian
Thu Oct 24, 2019 5:27 pm
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

Hi Lars,

So it doesn't seem to work on XLSM? I get an exception reading and writing.

Any tips on settings to fix this as this is quite key for me as well as I have a mix of xls and xlsm to deal with.

regards,
Conrad
by darnocian
Wed Oct 23, 2019 3:37 pm
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

Thanks Lars, xls I think this update helped considerably. https://lh5.googleusercontent.com/bTsrnyYwu8i6SMWU1lueqcZF4o3unyTFE_whtOt6C24L-x8ai97fEiiCLHF5ji8g2893d8RNhN6TchdQwbgK=w2560-h300 I got it to do what I needed. with vmtDocument, the code is added in the 'Microsoft Excel Objects' section. with...
by darnocian
Tue Oct 22, 2019 1:16 pm
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

Just confirming - I've tried switching between VmtMacro and VmtDocument.

I've also tried writing for xvExcel2007 which fails as writing xlsm is also required.

BTW: I'm not sure I'm getting your emails.
by darnocian
Mon Oct 21, 2019 5:56 pm
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

Hi Lars,

I tried that. I emailed you the example and output.

Unfortunately no luck for me.

Regards,
Conrad
by darnocian
Mon Oct 21, 2019 2:05 pm
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

Hi Lars,
I don't seem to be getting your mails. I've checked spam folder as well.
Regards,
Conrad
by darnocian
Fri Oct 18, 2019 1:52 pm
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

The example you sent doesn't work for me. with the library, I can read the VBA code that was written by the library, but it does not seem to be available in Excel when I open it that way. I still don't see any change to the installer - I did a binary difference. Is the update you mentioned somewhere...
by darnocian
Wed Oct 16, 2019 5:23 pm
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

Do I need an update - could you please refer to what I must download? Nothing changed from the reinstallation I mentioned above (and have downloaded twice)

The example above does not work for me.
by darnocian
Tue Oct 15, 2019 9:45 am
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

Re: How to write VBA to an XLSX file?

Hi,

I redownloaded xlsSpreadSheet_ddx103_reg.exe but I don't see any change.

Regards
Conrad
by darnocian
Fri Oct 11, 2019 10:21 am
Forum: XLSReadWritwII 6
Topic: How to write VBA to an XLSX file?
Replies: 16
Views: 18153

How to write VBA to an XLSX file?

Hi, I'm having issues writing VBA to a new file , or read writing VBA in an existing file. I'm not sure if I'm doing something wrong or some sequence issue regarding settings. Here is a sample application with 3 methods: TestReadVBA - works fine TestReadWriteVBA - fails TestWriteVBA - fails program ...