Updating excel from vb

27-Apr-2020 09:19

This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. script: I am running the following from the command line as "Start script.vbs".

This script suppose to adjust a column width and add a freezepanes and save the changes.

The script is working but I need to make another adjustment so I pass the file name and file path as parameters to this script.

Close (False) End With Set obj XL = Nothing Thanks for the response.

Select the "Refresh Every" check box and enter the number of minutes you want Excel to wait between automatic updates.

Click "OK." Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine.

She is certified in Microsoft application and served as the newsletter editor for Office

I tried using VBA to call the macro but it would just cause Excel to freeze and then you would have to use task manager to shut it down. Jay I think I tried that but excel still had to be opened manually. The spreadsheet is also in a format to be printed so my boss can see the intermediate tally results. I'm trying my best on my end and if i reach a solution before anybody else finds one, I will be sure to post it. Jay Did you try adding Excel and Access libraries to your VBA environments?

You can then automate the process of updating by accessing the Access model from Excel and vice versa. I did those things, I'm pretty sure it has something to do with the macro security in Excel. So I wonder if there is code to change that and then change it back when it's finished.....ideas?

Select the "Refresh Every" check box and enter the number of minutes you want Excel to wait between automatic updates.Click "OK." Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine.She is certified in Microsoft application and served as the newsletter editor for Office I tried using VBA to call the macro but it would just cause Excel to freeze and then you would have to use task manager to shut it down. Jay I think I tried that but excel still had to be opened manually. The spreadsheet is also in a format to be printed so my boss can see the intermediate tally results. I'm trying my best on my end and if i reach a solution before anybody else finds one, I will be sure to post it. Jay Did you try adding Excel and Access libraries to your VBA environments?You can then automate the process of updating by accessing the Access model from Excel and vice versa. I did those things, I'm pretty sure it has something to do with the macro security in Excel. So I wonder if there is code to change that and then change it back when it's finished.....ideas? Close Set cn = Nothing End Sub Thank you for you prompt respond. Formula) 0 ' repeat until first empty cell in column A With rs str SQL = "select * from Table Name where Field1 = 'project'" ' On Error Resume Next .