Windows 10: To write an Excel file from a VB.Net programme.

Hi,

I have made an application in Visual Studio 2017 that generates an SQL-express database (Database.mdf).

The database is read by the programme and the data are sent to an Excel file and the Excel file is written on an USB-Stick . This works fine at my developer unit, with Windows 10 and Excel is installed.

But when I transpose the programme to the target machine and starts the making of the Excel file I get an exception, Cannot create ActiveX Object.

The target machine is Windows 10 IoT and has not Excel installed. The idea being to have as little as possible of software on the target machine.

The code is:


objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.AddIns("QzData Excel Addin").Installed = True
objBook = oExcel.Workbooks.Add


The third line makes no difference but I searched for solution and found that the error may be that there are error controls built in Excel that may kick in and that it would be fixed by the AddIns!? I also tried to write the Excel file to C:\Users\Public but the same error was received as when I tried to write to an USB-stick.

I would appreciate any help to get this solved.

Best Regards,

Per

:)

 

FIles in Word, Excel and other programmes will not open from the explorer

Hi Brian,

Thank you for posting in Microsoft Community and thanks for providing us an opportunity to assist you.

Please follow the steps.

Step 1:

Lets try to disable the DDE option following these steps:

• Click the File tab, and then click
  Options.
• Click Advanced, and then click to clear the
  Ignore other applications that use Dynamic Data Exchange (DDE) check box in the
  General area.

Click OK.

Step 2:

If the issue persists, uncheck the compatibility options by doing the following:

Right click on Excel (.exe) Properties > Compatibility > uncheck all the boxes

To access Excel (.exe), open the following location:

Windows 8 32bit: C:\Program Files\Microsoft Office\Office14

Windows 8 64bit: C:\Program Files(x86)\Microsoft Office\Office14

For reference:
http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_programs/there-was-a-problem-sending-the-command-to-the/56ee1743-b476-43a5-9b00-169b8c6ef37a

Hope the suggestion is helpful. Reply for further assistance.

 

VBS Msgbox

Denis,

• I was too lazy to compute the size programmatically. And, it the 2005 version the message box always came up hidden, so I always used 0 for the top. It's also part of my OCD to be able to control everything.
• I personally don't need it to timeout. I used this in vbs files to ask to continue to the next step, skip the next step or cancel the vbs. BTW, I added the code back in but keep it assign it to 0.
• Sound was calling Windows Media Player: WshShell.Run "C:\Users\donast\desktop\sndrec32.lnk",7,false the lnk is a shortcut on my old desktop that had: "C:\Program Files (x86)\Windows Media Player\wmplayer.exe"
  "C:\Users\Public\Music\Wavefiles\Twilight.wav"
• Yes. The value is the number of the button in the order specified when calling it.
• Never really thought about it as all my VBS/VBA code is relatively simple and I add comments in the file as necessary to remind me what is going on. I don't usually have anyone to share my code.

FYI I use a VBS to call it. Here's a line from a test vbs I use to run your version:

choice=Wshshell.run("custommsgbox.vbs " & wscript.scriptname & " ""CopyFiles.vbs done. Continue with UnArchVista.vbs?"" ""White"" ""Black"" 40 ""Yes"" ""No"" ""Cancel""",1,true)

Copy it to a text editor to see all the spaces, etc. Took me a while back the to figure it out.

Don

 

CSV files used to open in Excel....not now!


Hi, you say Excel is installed. Does it run normally?

You can't find Excel in (an unspecified) list of applications. I don't know which list that is for sure.

For example, in the list related to:
- rt click a file. Open With
- this list:



- this list:




- some other list...

If Excel does not appear in the above, I suggest you repair your office installation.

Maybe the above gives you some ideas. Otherwise please post a screenshot of where you think you should see it but don't. Thanks.