Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding rows and deleting rows in an Excel File

We have a QV document that handles Expenses vs Budget. We want the user to be able to add comments to an excel file through a QV button. Also, the user needs to be able to remove a comment (meaning deleting a specific row in the file). Any suggestion/code on how to handle this?

I have done this with a Microsoft Access database in 8.2 (32 bit version), but there is no 64 bit drivers and we are on 8.5.

Thanks,

Stephen

37 Replies
Not applicable
Author

So I have everything working in 8.5 Developer but when users try to added a comment (or delete a comment) when using the Internet Explorer plugin an error message pops up "Macro parse failed. Funtionality was lost." with the caption of the box titled "QlikOcx".

Any ideas what is happening?

Not applicable
Author

Never mind. The problem was that the QV document was linking to a location that the user did not have permissions too.

Not applicable
Author

I'm getting an error when I try to use the line:

Set oXL = CreateObject("Excel.Application")

it says: ActiveX component can't create object: 'Excel.Application' and qlikview stops responding.

Any idea what's going on? I've tried looking it up but all of the solutions have to do with people using these script functions in web applications.

Not applicable
Author

Not sure but try setting "Requested Module Security" to "System Access" and "Current Locate Security" to "Allow System Access".

Stephen

Not applicable
Author

thats seems to have gotten rid of the error at that point in the script, but qlikview still crashes whenever I try to test it

Not applicable
Author

the crashing problem seems to have gone away.

My set up is very similar to sjcharles' in that I am only allowing these comments to be entered when a single Order ID is selected. My question is, from within the script, how do you put the selected Order ID into the excel document? How do I reference it in the script?

Not applicable
Author

To get the selected value, use the QlikView function: GetFieldSelections(Order_ID).

I would create a variable with the definition: =GetFieldSelections(Order_ID). Then in your script, use ActiveDocument.Variable("VarName").GetContent.String to pull out that value.

Not applicable
Author

I can't seem to get the field selection. The field is "Order ID". So it has a space in the middle. In general it seems if you put the square brackets: [Order ID] it works, like in counting orders with the Count function. When I try to make this call though, it doesn't work. When debugging it just says: GetFieldSelections Empty. For the record I know for a fact that an Order ID is selected 😛

Not applicable
Author

In this case, you want double-quotes.

=GetFieldSelections("Order ID")


I make it a habit to not use spaces in my field names. In many different data programs, you have to work a little harder to accommodate for those spaces.

Not applicable
Author

I just realized the actual error i'm getting is: Type Mismatch: 'GetFieldSelections'

this is my code:

Dim id
id = GetFieldSelections("Order ID")


not really sure what part of the code is causing this mismatch, if its the assignment of this value to id or using "Order ID" as an argument