Help Me Make This Faster

2017-06-22 Thread QCIT3 MMisonora
Hello there, Recently the company I am working for has downloaded your program, OpenOffice and have tried to open some files we have previously made files on Windows Excel with your program. However, it took about twenty minutes to load, so I was wondering why is it loading so slow and how can

Macro Code Trrou

2017-06-23 Thread QCIT3 MMisonora
Hi there, I just gotten the macros on a file that was originally from Excel to OpenOffice to appear and sometimes run. However, on one of the macros there is a mistake on one of my lines according OpenOffice and was hoping if someone can tell me how to fix it. The line says "LastSn = rng.Find("

Macro Troubles

2017-06-23 Thread QCIT3 MMisonora
Hi there, I have an excel file with macros on it and have gotten it onto OpenOffice, but the coding for the macros on the file keep saying there is an error, so I was wondering if anyone can please inform me as to how I can fix these two lines in two separate codes. 1. LastSn = rng.Find(

Help OpenOffice is Taking Half an Hour to Load Excel Files?????????

2017-06-29 Thread QCIT3 MMisonora
Hi there, I am a new user to OpenOffice and am trying to get some files with VBA macros that were originally written in Excel to open onto OpenOffice. However, it is taking about half an hour to load just one file, so I am wondering why it is taking so long as well as how I can fix it. Thanks

I Got A Question

2017-06-29 Thread QCIT3 MMisonora
Hi there, I am a new user to OpenOffice and I need to have files, originally from Excel with macros able to work on OpenOffice and Excel. However, I know that VBA and API both use a different format of coding, so I was wondering if I were to write the macros in another format such as Python or

Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

2017-06-29 Thread QCIT3 MMisonora
Hi there, I am a new user to OpenOffice and was wondering if when I write lets say a spreadsheet with macros on it and sent to someone who would have to open that file in Excel cause they don't use OpenOffice, would the macros still work or would it not work like when one opens an Excel file wi