Forums

Link with excel

javisuesk

Hello!

I am creating a new project and I have two questions:

1) How can I get the value of a determined cell from excel to AMS? for instance from the cell: 1 row, 1 column.

2) How can I export a Grid from AMS to an excel archive?

Tha...

2 days ago
Reply to Link with excel

sameer valva

Big Hug man .

Hiding the file will do the job now, ill do some tests today and give feedback.

Thanks...

10 hours ago
Administrative Installation

MohammedMars

how to make the whole installation in same access right "Admin". and stop from asking me more than one time for take admin privilege.

i have three custom action depends on some, and i want make sure to doing these actions from the same user "Admin"

I'm...

11 hours ago
Run on Startup

pedro01

Hi

Is there any option to get an installed program to run on windows startup?

I'd like it to be an option they set during the install.

Let me know

Pete

1 day ago
Reply to Run on Startup

Ulrich

You can use a Check Boxes screen, or a Custom screen with a checkbox on it, offering the option to create a shortcut in the Startup folder of the Start menu. Check the documentation and examples of the screen types I mentioned, and read the documentation for the Session Variables and Shell.CreateShortcut()....

21 hours ago
Reply to Link with excel

BioHazard

Are you opening a workbook in the existing Excel file? Or adding a new workbook to it? If it's the latter, the replacement code should be working fine. If however you're 'opening' an existing workbook, you'll have to tell LuaCOM that you're 'opening' rather than 'adding'. And you'll have to instruct...

1 day ago
How to capture wmic output

wawazx

I'd like to get the "wmic csproduct get name, identifyingnumber" and use the output as a variable
What's the easiest way of getting that wmic output and being able to use it in AMS ?...

2 days ago
Reply to How to capture wmic output

BioHazard

The sample provided in my apz-demo (Unique Harware IDs via WMIC) at Post-5 in the "Creating a unique ID" thread which you initiated is probably the easiest way to do it.

You could also do it via the LuaCOM plugin but is unnecessarily complicated. The only other way to pipe in...

1 day ago
Reply to Link with excel

BioHazard

@javisuesk,
@sameer,

I've just noticed a bug with COM errors getting returned when the Excel file is closed prematurely. Still ironing out some kinks, guys. Also, I need to modify the Excel Dependency notification as Microsoft Excel (or equivalent XLS writer) is required - not the...

1 day ago
Reply to Link with excel

colc
Hi and welcome to the forum @javisuesk,
I have a SQLite3 Database which I import into AMS via a grid object
It has 28 Columns (A1 to AC1) , adjust code to your needs
Code:
```
local oExcel = luacom.CreateObject("Excel.Application");
if oExcel then
    oExcel.Visible
```
...
2 days ago

Announcement

What's Going On

Indigo Rose Software Forums Statistics

Latest Topics

Advertisement

Tag Cloud

Advertisement Sidebar2

Recent Blog Posts