VBA and SQL Question

C

Coach3131

Board Regular
Joined
Nov 23, 2007
Messages
242
If I am trying to overwrite a table, what settings do I need to set it so that I don't get the VBA error? I don't want a table refresh and I don't want to delete the table because it will cause a REF problem as I have a sheet linking to the data.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
Explain what you mean by "overwrite a table"?

Show your VBA ... and explain what you mean by "the VBA error"?
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
VBA to run when a table with a SQL query is refreshed?
Replies
3
Views
254
DickyWest32
D
R
  • Solved
VBA Queries refresh and Save data as TXT
Replies
2
Views
260
Artik
Artik
D
  • Question Question
Pivot Table Refresh Issue
Replies
7
Views
867
Alex Blakenburg
A
9
  • Question Question
VBA code deleted in macro enabled workbook when i overwrite workbook with save as
Replies
3
Views
78
RoryA
RoryA
S
  • Solved
How do I automate opening an excel document every 24 hours in the background, refresh connections, save and close the workbook in excel using vba?
Replies
6
Views
224
SPS41
S

Forum statistics

Threads
1,224,516
Messages
6,179,231
Members
452,898
Latest member
Capolavoro009

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top