Need help with previewing issues.

I am having issues trying to preview any of my information in XLEcom. I minimized my browser and XLEcom side by side. I tried opening internet explorer and firefox to see if either of these would preview the pages for me. Neither is working.

All that happens when I hit any type of preview button in the program is that the XLEcom has a momentary flash like it tried to do something but nothing pops up.

As a side thought, is it possible that my browsers are treating it like a pop-up?

update

Just thought you might like an update. The issue was that Internet Explorer was not my default web browser. I just fixed that and low and behold I can preview what I have been working on for months :). Thank you again for your help.

It's amazing what you can

It's amazing what you can figure out once you get in and play with it.

I did figure out the test you wanted me to run and it resulted in a new tab in my firefox browser for the google search page.

1) xlecom version

1) xlecom version 4.1.424
2)I purchased the product directly from you website last year. I have never gotten the preview windows to work and back then I thought it was an issue with me. After viewing the tutorials you now have (which are wonderful by the way) I realize that I am not the issue. Also, when I originally registered I was using a different user name of firenflare. After being off my computer for soooo lond I couldn't find the original user name i used (but I still have the original email with the registration code).
3)Excel 2002 and Windows XP Media Center Edition

1) Yes macros are enabled and all my other buttons work, just not anything that has to do with previewing the pages. Do you want me to create a new regular speadsheet
2)You kind of lost me here. Could you explain these instructions in a little more detail. Visual Basic Editor? Never entered in my own macros before either. So this step I have not been able to complete yet.

RE: 1) xlecom version

(1) At this time the latest version of the program is XLEcom 4.4. I would recommend you upgrade to the latest version. Upgrades are Free.

(2) As a quick test to see if the previews will work on your system with a different XLEcom file, download just the program file XLEcom.xls (xlecom-setup.zip) itself and change the file path settings within the program to match your current file asset locations. Next, test it to see if the previews work. If this does not work, try the following test.

(3) Test to see if Excel can open a web page via a VBA macro

Try the following Excel macro. This macro will open a web browser window and then go to google.com.

  1. Create a New Blank Spreadsheet
  2. Open the Visual Basic editor
    To get to the Visual Basic editor, you need to have the Visual Basic toolbar visible. To make the Visual Basic toolbar visible, right click anywhere on the Excel toolbar and select the Visual Basic toolbar as shown in the following image.


    To open the Visual Basic editor, click on the Visual Basic editor button as shown within the red rectangle in the following image.
  3. Create a New VBA Module
    Within the Visual Basic editor, create a new VBA module. To do this, right click on the file's title VBAProject(book1) in the Project window's tree menu and select Insert >> Module.
  4. Copy an paste the following macro Sub Routine into the new module and run it.
    To run the macro, place the mouse cursor in front of the Sub Open_Website() statement on the first line and press the Run button. The Run button looks like a right facing arrow head similar to the first button shown in the Visual Basic toolbar as in the above image.

    If the macro does not run, then something is wrong with your system.

    Sub Open_Website()
        ActiveWorkbook.FollowHyperlink Address:="http://google.com", NewWindow:=True
    End Sub

    Note: You can run the macro from either the VBA editor or from the spreadsheet itself.

Sam Raheb
XLEcom Program Developer

Puzzled

Okay, I downloaded the upgraded version and it still did not let me use any of the preview options.

So...
I ran the test on excel to see if it would open the VBA macro in a new window and again that command it would obey. So that is working just fine. Which means I'm stumped.

Worse case scenario, I love your product to much to dismiss it because of this glich therefore I will have to create my pages and preview them live. Pain yes, do-able also yes. But if you have ANY other suggestions as to what is making my program misbehave please let me know.

RE: Puzzled

The XLEcom program uses the same VBA macro as in the sample I gave you for testing. It should work fine.

If you are using Firefox as your default web browser, the XLEcom page preview may be opening in a new tab. Close all your Firefox browser windows and try the preview again.

For another test, try changing your default web browser to Microsoft Internet Explorer. This way you can at least determine if there is a problem with your Excel application.

Sam Raheb
XLEcom Program Developer

RE: Need help with previewing issues

(1) First of all, what version of XLEcom are you using. Look at the bottom right of the Product Design sheet to get the version information.

(2) Is the program in Shareware mode or did your Register it?

(3) What version of Windows and Excel are you using?

This issue has never come up before, so we need to rule out a few things first.

It should have nothing to do with with pop-up blocking. You can turn pop-up blocking off and see if it works. If not, you need to perform a little test outlined below.

(1) Can you run any of the macro functions?
The macro functions are the buttons on the spreadsheet. If not, then you need to enable macros. See the following page for instructions on enabling macros: System Requirements

(2) It could be something wrong with your system.

Try the following Excel macro. This macro will open a browser window and then go to google.com.

1. Create a new spreadsheet
2. Open the Visual Basic editor
3. Create a new module
4. Copy an paste the following macro sub routine into the new macro and run it.

You can run the macro from either the VBA editor or from the spreadsheet itself.

If the macro does not run, then something is wrong with your system.

Sub Open_Website()
    ActiveWorkbook.FollowHyperlink Address:="http://google.com", NewWindow:=True
End Sub

Sam Raheb
XLEcom Program Developer