Question about Sony Playstation 3 (PS3) Console
I need to create an exe file in visual basic which will take input as excel file and and delete its blank rows and shows the output as the formatted excel sheet.
i can delete the blank rows through macro but that code is not working in VB.
The error is 'activex','selection','application' are not defined.
what to do? please help. its very urgent.
Assuming you have code such as createobject() then it sounds like you may not have added the reference for Excel. The menu for "Reference" depends on your version of VB. In VB 2008:
In VB6 I think it's ion the tools menu. There is no COM tab in VB6. But otherwise the same.
Posted on Aug 28, 2009
Have you tried to read in one file and write back in excel format only the non-blank rows?
Posted on Mar 29, 2009
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jul 11, 2014 | Microsoft Office Computers & Internet
Jun 04, 2011 | Microsoft Excel for PC
Dec 25, 2010 | Microsoft Windows XP Professional
Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook
Aug 19, 2010 | Microsoft Windows XP Home Edition Service...
Sep 08, 2009 | Computers & Internet
Jun 08, 2009 | Microsoft Visual Basic 6.0 (361-00686) for...
May 27, 2009 | Microsoft Windows XP Professional
Feb 25, 2009 | Microsoft Visual Basic 6.0 for PC
216 people viewed this question
Usually answered in minutes!